MICROSOFT ACCESS CUSTOMERS ASSIGNMENT

Open Microsoft Office Access, click Blank Database, assign the filename Customers YourLastName in the bottom right hand corner of the screen $($click the folder following the file name box to choose where you want to save the file, if necessary$),$ and choose Create.

A table temporarily named Table $1$ with a field named ID is created. Change to design view to setup the structure of the table. When prompted, type Customer Info as the table name. Change the ID field name to Customer #$,$ change the data type to Short Text, and change the field size to $5($notice that it has been assigned as the primary key field$).$ Add the following fields to Customer #:

$\backslash$table$[[$FirstName$,$Short Text,$],[$LastName$,$Short Text,$],[$Address$,$Short Text,$],[$City$,$Short Text,$],[$State$,$Short Text,Change field size to $2$ characters$],[$Zip$,$Short Text,Change field size to $5$ characters$]]$

Change the view to Data Sheet View and enter in the following data:

$\backslash$table$[[88,$John Doe,$1$ Main Street,Fort Pierce,FL$,34950],[62,$Mary Smith,$3$ Main Street,Fort Pierce,FL$,34950],[45,$Tom Brown,$100$ Lake Lane,Jensen Beach,FL$,34947],[77,$Ann Jones,$222$ Second Street,Stuart,FL$,34997],[46,$Jill Johnson,$5$ Fifth Street,Fort Pierce,FL$,34982],[21,$Bill Smith,$111$ Lake Lane,Jensen Beach,FL$,34947],[34,$May June,$55$ Port Point,Port St$.$ Lucie,FL$,34983],[89,$April March,$45$ Port Point,Port St$.$ Lucie,FL$,34983]]$

Close the table $($leave the database open$).$

Create a new table $($in the same database$)$ and change to design view, naming the table Order Info. Change the ID field name to Order #$.$ Verify that it is the primary key field and that its data type is AutoNumber. Add the following fields to Order # with the data type and any other specifications listed below. Then close the table, saving the changes.

$\backslash$table$[[$Customer#$,$Short Text,Change field size to $5$ characters$],[$Order Date,Date$/$Time$,$Short Date$],[$Item$,$Short Text,$],[$Quantity$,$Number,$],[$Price$,$Currency,$]]$

Go to the Database Tools tab, Show$/$Hide group and choose Relationships. Show both tables and create a relationship between the two tables by pointing to Customer # in the list of fields from the Customer Info table and dragging until you are pointing to Customer # in the Order Info table. This opens up a relationship dialog box, click Enforce Referential Integrity and click the create button. Close this window. You will be prompted to save the changes; click yes.

Open Order Info table and add the following data $($the Order # field will be automatically populated due to its data type of AutoNumber $-$ just tab past it$)$:

$\backslash$table$[[62,\frac{11}{1}\frac{?}{2010},$College$-$ruled paper$]]$

$2$

$$2\mathrm{.}00$

Go to the Database Tools tab, Show$/$Hide group and choose tables and create a relationship between the two tables by pointing to Customer # in the list of fields from the Customer Info table and dragging until you are pointing to Customer # in the Order Info table. This opens up a relationship dialog box, click Enforce Referential Integrity and click the create button. Close this window. You will be prompted to save the changes; click yes.

Open Order Info table and add the following data $($the Order # field will be automatically populated due to its data type of AutoNumber $-$ just tab past it$)$:

$\backslash$table$[[62,\frac{11}{1}\frac{?}{2010},$College$-$ruled paper,$2,$$$2\mathrm{.}00$