DATABASE MANAGEMENT/ACCESS

1. Create a User view: set of requirements necessary to support opera8ons of a par8cular database user

2. Create a rela8onal database with at least 6 tables using Access 2016

3. Each table should have 4 or more fields.

a. Create one field with date and 8me

b. Format your fields.

c. Have one field a lookup field

d. Add an aIachment field

4. Add no less than 5 rows of data for each table.

5. Create the user view

6. Create an E-R diagram of your database. Showing all the fields the PK and FK. Use the right symbols to describe your diagram. (Such as the one to many rela8onship)

7. Make sure your database has correct referen8al integrity.

8. Build 4 Queries.

a. Use QBE to build

i. One with both an “And” plus an “OR” Criteria.

ii. Build a Calculated Query. EX: Unit F pg. Access 146 in MicrosoZ Access book

b. In Access SQL:

i. Build a basic query that fetches all field from a table

ii. Build a subquery like Figure 3-41 in the “Database Management” book

9. Create a Form

a. Build a form using at least two of your tables

b. Place a Logo in the top leZ-hand corner of your form.

c. Add a Print buIon

d. Add a sub form (with a few fields)

10. Reports ( You will have two reports)

a. Build a report with the fields from two different tables.

b. Include Report Sec8ons: Report Header, Page Header, Details and a page footer

c. Group them by different fields.

d. Add a sub report.

e. Create a Summary report.

f. Have two different page layouts.

11. Finally!! Analyze rela8onships, Evaluate tables and make sure you have Improved your fields