Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Get this document free

Access.T02

VIEWS: 28 PAGES: 4

									Access 2010                                                                                  Tutorial Project




TUTORIAL PROJECT
Data Files needed for the Tutorial Project:
    LuckyTire.accdb (created in the Tutorial Project for Access Tutorial 1)
    Customers.csv
    Sales.xlsx

Len Phan, the owner of Lucky Tire, has asked you to expand the LuckyTire database to store additional
company data, after seeing how comfortable you are working with Access. He asks you to include
customer and sales information. You decide to add a table for customers, and a third table that tracks
customer’s tire purchases.

1.   Start Access and open the LuckyTire database. Save the database where you save your data files. If
     the Security Warning is displayed, click the “Enable Content” button.
2.   Open the Tires table and in Design View, set the following field properties:
         Field Name             Data Type          Field Size
         PartID                 Text               5
         Model Name             Text               20
         Manufacturer           Text               20
         Unit Price             Currency           2 Decimal Places
         Type                   Text               12

3.   Save and close the Tires table.
4.   Len exported the customer data he was maintaining in another computer system to a text file, Import
     the data from Customers.csv into a new table in the LuckyTire database.
          Specify Customers.csv as the source of your data.
          Select Import the source data into a new table in the current database
          Select import in a delimited format.
          Select comma delimited and click the First Row Contains Field Names checkbox.
          Select the Indexed option Yes (No Duplicates).
          Choose CustID as the primary key.
          Name the new table Customers. (Do not save import steps.)
5.   Open the Customers table. Resize the columns as necessary to fit the data, and then set the following
     properties for the fields:
         Field Name             Data Type          Description        Field Size
         CustID                 Text               Primary Key        5
         First                  Text                                  20
         Last                   Text                                  20
         Address                Text                                  35
         City                   Text                                  25
         State                  Text                                  2
         Zip                    Text                                  5
         Phone                  Text                                  14
         Make                   Text                                  15
         Model                  Text                                  15
         Year                   Text                                  4




                                                    1of 4
Access 2010                                                                                    Tutorial Project


6.   Save and close the Customers table.
7.   Use Design View to create a new table named Sales using the follow table design.
      Field Name                Data Type           Description        Field Size
      Invoice                   Text                Primary Key        5
      InvoiceDate               Date/Time                              Short Date
      CustID                    Text                Foreign Key        5
      PartID                    Text                Foreign Key        5
      Quantity                  Number                                 Long Integer


8.   Add the following two records to the Sales table, and then save the table.
      Invoice        Date           CustID          PartID         Quantity
      77340          5/5/2010       50173           Y450T          1
      77341          5/5/2010       50211           G812T          1




Stop Here
9.   Len has been tracking recent Lucky Tire sales information in an Excel spreadsheet, Sales.xlsx. Append
     a copy of the records from Sales to the Sales table.
10. Open the Sales table. Resize all of the columns to their best fit, then save and close the Sales table.
11. Because every sales order needs to have a customer, define the one-to-many relationship between the
    primary Customer table and the related Sales table. Select the Enforce Referential Integrity option and
    Cascade Update Related Fields option for this relationship.
12. Because every customer sale needs to include a tire model, define the one-to-many relationship
    between the primary Tires table and the related Sales table. Select the Enforce Referential Integrity
    option and Cascade Update Related Fields option for this relationship.
13. Save the changes to the Relationships Window. Compact and repair the LuckyTire database, and then
    close the database.
14. Close Access.




                                                     2of 4
Access 2010           Tutorial Project




              3of 4
Access 2010           Tutorial Project




              4of 4

								
To top