Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

Description

Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

Lab 1: Administering the ECO Clothesline Database
Problem: ECO Clothesline has determined a number of database administration tasks that need to be done. These include creating a template, splitting the database, creating indexes, and adding table and field properties.

Instructions: If you are using the Microsoft Offce Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 9. Otherwise, contact your instructor for more information about accessing the required files.

Perform the following tasks:
1. Open the Open Orders table in Datasheet view and add the Quick Start Priority field to the table. Assign a High priority to orders for customers AM23 and JN34. Assign a Low priority to the order for TT21. All other orders have a Normal priority.
2. The Main Menu navigation form should display automatically when a user opens the database.
3. Open the Customer table in Design view and create custom input masks for the following fields: Customer Number, State, Postal Code, and Sales Rep Number. The Customer Number field should consist of two uppercase letters followed by two numbers. The State field should contain two uppercase letters. Both the Postal Code and Sales Rep Number fields only can contain numbers.
4. Create an index on the Customer Name field that does not allow duplicates. Create an index on the combination of Customer Type and Customer Name. Name the index TypeName.
5. Save the ECO Clothesline database as a template with data but not as an application part. Create a new database from the ECO Clothesline template. Name the database ECO New. Split the ECO New database.
6. Open the front-end database and add a logo to the Customer Master Form. You can create your own logo or use one o the sample pictures included with Microsoft Access. (Hint: See the BTW on page AC 645 for assistance with this task.)
7. Submit the revised databases in the format specified by your instructor.