Acess is one of the proposals for Microsoft database administration. The help of Microsoft Access application and summarizes: "Through Microsoft Access, you can manage all information from a single database file. Within the file, you can use: Tables to store data. Queries to find and recover only the data you need. Forms to view, add and update the tables. Reports to analyze or print data with a specific design. data access pages to view, update and analyze data from the database from Internet or from an intranet. "Upon entering the program the user will encounter a screen similar to the following: 
that allows you to open an existing database or create a database new, Create trade. This will take a blank database: Show the different objects that can be included (tables, queries, forms, reports, etc.). Of our interest are the two primeros.Para create table product, in view of design is as follows:
In the figure shows the name of each of the columns or fields and the type of data that contain. The reference field has been marked as primary key (using the wrench icon in the icon bar). As the key is automatically determined if the value is to be indexed and must be strictly required as this place and not allow zero length. This field is a 4 character positions. You may place default values to be taken at the time of inclusion of records, as you can define validation rules or constraints for those attributes or fields that require it. The column description is optional and serves to document the basis of datos.Para set the table name, then capture the information necessary, close the window and the following dialog box, type where the desired name, which must be consistent with the nomenclature used in the system:
If you were to create the table provider would have something like:
It is noted that the primary key is codprove. It has also used a field with field type date, which can be defined as a special format menu displayed. This is possible with other campos.Ya should be clear to those who have followed the course that is a foreign key in the product table (the field prove) that relates to the vendor table (primary key codprove). It is important to note that it is not necessary that the fields have the same name, but if he is having the same data type with the same length and, where necessary definir.Esta relationship can be specified as follows:
Pressing the button on relationships can select the different tables or queries (representing the views in access) to be associated.
In the event, product and supplier. Simply drag the field to try to prove on the field of codprove table supplier in the following table, asking for the full definition of the relationship: The precise details are shown in the following two figures: If you want to check referential integrity (which is usually desirable), select the option and enabled two possibilities for handling it. You can also define the combinations that would end permiten.Al be something like this: showing clearly the cardinality of the relationship (many to one). At this point if you want to enter data just enough pressure on the table in the main access
Publicar un comentario