LAB 8

User Generated

Unznq Voenuvz

Programming

Unformatted Attachment Preview

LAB 8_ Assignment Part 1 Creating a FORM: (1) Open the Access Database “Bright Lights Inc. Sales Information” (2) Create a FORM over the “Sales Reps” table. (3) Save the FORM and name it “Sales Reps Form” (4) Change the Form Header Section to “Sales Reps Information”. (5) Add a Label in the Footer Section that says “All Rights Reserved Bright Lights Inc.” (6) Open the Properties on each Label in the Form and change the Fore Color to Black. (7) Advance the Form to Rep ID 2, and change the First Name to Maryann. (8) Close the FORM and open the “Sales Reps” table and verify that Rep ID 2 has the First Name of Maryann in the “Sales Reps” table. Part 2 Creating a Table with a Composite Key: (9) In Design View, create the following FIELD NAMES in the “Sales Managers” table, using the following Data Types and Descriptions: Field Name: Data Type: Description: Record ID AutoNumber Record ID Number Manager ID Text Manager ID Last Name Text Manager’s Last Name First Name Text Manager’s First Name Date Hired Date/Time Manager's Hire Date Region Text Sales Region Note: The RECORD ID Field should be a Primary Key Field and the Index should say “Yes (No Duplicates). Page 1 of 2 Note: The Manager ID Field should be a Primary Key Field and the Index should say “Yes (No Duplicates). Also the Field Size should be 5. Note: The Field Size for Last Name should be 30. Note: The Field Size for First Name should be 30. Note: The Field Size for Region should be 30. (10) In the Datasheet View, key the following records into the “Sales Managers” table. Sales Managers Record ID Manager ID 1 11123 2 11124 3 11125 Last Name First Name Franklin Thomas Brown Judith Johnson Calvin Date Hired Region 8/8/2011 West 9/5/2011 East 5/16/2011 South Page 2 of 2
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Just what I needed. Studypool is a lifesaver!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags