Document Preview:

Shelly Cashman access 2010
Chapter 1: Lab 1
creating objects for the eco clothesline database
Skills
Save a database with a new filename
Import data from an Excel worksheet
Create a caption for a field
Resize columns
Create a table
Save a table
Add fields to a table
Change the data type of a field
Set the primary key for a table
Change a field’s properties
Enter records
Create a query using the Simple Query Wizard
Create a report using the Report Wizard
Add totals to a report
Project overview
ECO Clothesline is a local company that designs and manufactures eco-friendly casual wear, yoga clothing, and fitness apparel. All clothes are made from earth-friendly fabrics, such as bamboo, hemp, organic cotton, and natural silk. The company recently decided to store its customer and sales rep data in a database. Each customer is assigned to a single sales rep, but each sales rep may be assigned many customers. The database and the Customer table have been created, but there is no data in the Customer table. The Sales Rep table has not been created. The company plans to import the data from an Excel workbook containing information on the sales representatives that ECO employs. ECO would like to finish storing this data in a database and has asked for your help.
STUDENT start FILE
SC_Access2010_C1_L1a_FirstLastName_1.accdb (Note: Download your personalized start file from www.cengage.com/sam2010)
Instructions
1. Open the file SC_Access2010_C1_L1a_FirstLastName_1.accdb and save the file as SC_Access2010_C1_L1a_FirstLastName _2.accdb by clicking the “Save Database As” command in Backstage view. (Note: Verify that your name appears in the first record in the _SAMProjects table before you begin. If it does not, then please download a new copy of the start file from the SAM Web site.)
2. Import all the records from the CustomerData worksheet in the Excel file “support_SC_A10_C1_L1a_CustomerData.xlsx” into the existing Customer table in the current…