1. Creating a Database
To solve the problems of accounting data on sales of goods, the database must contain the following information:
• list of goods;
• list of customers;
• Information on leave and payment (invoice).
The technology of creating database tables SALE
1.1. Create a new database file. To do this, execute the File-New menu command. In the New window, select New database. In the window that opens, specify the database name SALE_name (student). Specify the folder in which this file will be saved.
1.2. Describe the structure of records of database tables and name them as follows: PRODUCTS, BUYERS, REST, LINK. Field descriptions are given in Table 6.
1.4. When creating a table structure, follow the following procedure:
Select the tab Table and the Designer mode.
Fill in the rows corresponding to the fields of the table (how many fields, how many lines there will be).
For each field, define the characteristics on the Field Properties tab:
• the size of the field;
• the signature of the field (not to be confused with the description);
• for compound key fields, set the "Indexed Field" property to "Matches allowed".
For each table, specify the key field by clicking the button on the Toolbar. (Note: If you specify a key field for non-contiguous fields, use the <Cntr> key).
Save the record structure by assigning a name to the table.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at email@example.com the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)