Download Creating Tables-MS Acess-Tutorial and more Study Guides, Projects, Research Microsoft Access Skills in PDF only on Docsity!
Exercise Unit 3. CREATE A DATA TABLE.
If Access is not open, open it in order to be able to carry out the following exercises.
Exercise 1: Distributer.
1 Open the Cars database in My exercises folder in the hard drive.
2 Create a table named Clients with the following fields:
Field Name Data Type Client Code Number Client Name Text Client Surname Text Client Address Text Client City Text Client Postal Code Text Client State Text Client Phone Text Client Birth Date/Time The primary key will be Client code. 3 Create another table named Sold Cars with the following fields.
Name of field Type of data Licence Text Make Text Model Text Colour Text Price Text Extras Memo The primary key will be License. http://www.teacherclick.com/access2003/epr_3_2_1.htm (1 of 3)11/10/2010 1:12:25 PM
Access Tutorial
teacherClick tutorials
Tutorials selection
docsity.com
4 Create another table named Services with the following fields: Name of field Type of data Service Number Autonumber Oil Change Yes/No Filters Change Yesí/No Revise Brakes Yes/No Other Memo The primary key will be Service Number 5 Close the database.
Exercise 2: Clinic.
1 Open the Clinic database in My exercises folder in the hard drive. 2 .Create another table named Patients with the following fields.
Name of field Type of data Patient Code Number Patient Name Text Patient Surname Text Patient Address Text Patient City Text Patient Zip Code Text Patient State Text Patient Phone Text Patient Birth Date/Time For the moment we will not define a primary key. 3 Create another table named Doctors with the following fields.
Name of field Type of data Doctor Code Text Doctor Name Text
http://www.teacherclick.com/access2003/epr_3_2_1.htm (2 of 3)11/10/2010 1:12:25 PM docsity.com
