Global Wold Access DB

PART 1: Employee Table

Step 1: A Blank Access database and save it as GWDB_yourname (e.g., GWDB_jDoe)

Step 2: Create the following Table (In Design View)

Step 3: Set the Field Properties

Step 4: Add data to the table (In Datasheet view).

Add your name as the last record. Make up field values as needed.

PART 2: Locations Table

Step 1: Create the following Table (In Design View). Name it Locations

Step 2: Set the Field Properties

Step 3: Add data to the table (In Datasheet view).

Step 4: Create an Entity Relationship diagram (ERD).

Using the Database Tools menu in Access, create the ERD diagram below. Make sure to enforce Referential Integrity in the Edit Relationships Window.

PART 3: Titles Table

Step 5: Add a third Table: Name it Titles

Step 6: Set the Field Properties

Step 7: Add data to the table (In Datasheet view).

Step 8: Modify the Entity Relationship diagram (ERD) you created in PART 2.

Using the Database Tools menu in Access, create the ERD diagram below. Make sure to enforce Referential Integrity in the Edit Relationships Window.

PART 4: ASSIGNMENT – Forms, Queries, and Reports

With this you should be ready to develop Queries, Forms, and Reports

1) Design a Form for each of the 3 Tables you created

2) Produce the following Reports (based on queries):

a) All employees with salary greater than $50,000

b) Females with Salary less than $50,000

c) Males with Salary Greater than $50,000

d) Salaries and Performances of employees located in Boston