Your Status: Logged out Log in

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: 7 out of 10 stars (4 votes) | Words: | Submitted: Mon Sep 29 2003

Page Preview
Preview
Previous 1 of 21 Next

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...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 149,410 others
Register Now