Designing a Table Using Microsoft Access Page2 

Designing a Table Using Microsoft Access Continued Page 2

1. Turn on the Caps Lock and Click into the first Field Name Box

2. In the first box type the word NAME and press the enter key 3 times

3. In the second box type the word DAY and press the enter key 3 times

4. In the third box type in CAR SOLD and press the enter key three times

5. In the fourth box type in the word DATE and press the enter key three times

6. In the fifth box type in the word PRICE and press the enter key three times
   
   Your table should now look like this:-

Pressing the enter key three times was a quick way to set up the table, but by doing this we accepted Text as the Data Type for all of the fields.

We now need to change the Data Type for the DATE field to a Date/Time Format.

We now need to change the Data Type for the PRICE field to CURRENCY Format.

1. Click to the right of the word Text in the DATE row, and a dropdown box will appear, select Date/Time from the dropdown list. Press Function key F6 at the top of your keyboard and the the cursor will jump to the formatting box at the bottom of the page. In the Format Row select General Date from the dropdown list.

2. Click to the right of the word Text in the PRICE row, and a dropdown box will appear, select Currency from the dropdown list. No further settings are required for this field type.

Your table should now look like this:-

Notice that the Data Types have changed to DATE/TIME and CURRENCY.

We are now ready to Save our Table design.

Click here to see how to Save the table design

The author of Designing a Table Using Microsoft Access Page2 is Anthony George

For more articles like: Designing a Table Using Microsoft Access Page2 Visit:- 

http://www.accesstutorials.freetipson.co.uk

Source:  Article Designing a Table Using Microsoft Access Page2 was submitted by Anthony George for publication.

Back to the access tutorials Homepage

© Anthony George 2005 Designing a Table Using Microsoft Access Page2