In this section I shall design my database. I will make a total of 5 tables. 1. Customer Details Table 2. Jobs Table 3. Products Table 4. Suppliers Table 5. Employees Table
Member rating:
(4 votes)
| Words:
| Submitted: Mon Sep 29 2003
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
In this section I shall design my database. I will make a total of 5 tables. 1. Customer Details Table 2. Jobs Table 3. Products Table 4. Suppliers Table 5. Employees Table From these tables I will be making all the outputs necessary such as queries reports and so on. The design of each table is described in its respective section. Tables: The method to create a table is the same for any table I will be creating. The only difference would be some properties in the table. After I open Access, I start by creating a new database. This can be done by choosing New from the File menu. I then choose 'Blank Database' so that I get a completely empty database. I give my database a name and choose create. From the list of options that appear in the form of a box, I choose 'create table in design view'. I can then enter the 'field...

