CPT 172 (MICROSOFT ACCESS) FINAL PROJECT Effective: 7/18/2017

DUE DATE:

BE SURE TO USE THE CORRECT PREFIX FOR EACH OBJECT CREATED (tbl, frm, qry, mcr, rpt)

I.TABLES 15 points (Enter data in your tables)

Create at least three tables

Include at least five to seven fields on each table that includes a Description of the Primary Key and Captions

FIELD TYPES should include: DATE, YES/NO, Short Text, etc.

Set Field Validation rules if needed

Create a Look-up for a field on one of the tables

II. FORMS - 10 points

Forms for each table to include one Subform

One Form should include a title and a picture

One custom form design using a combo box to view a selection list

III.QUERIES 40 points

Three queries built from each table created in section I that includes criteria below. Just be sure A I is included.

One query built THAT INCLUDES ONLY 3 FIELDS FROM EACH OF THE TABLES

One query built using more than one table

Perform a sort on one of the queries

Create a query using a Selection Criteria on a field of your choice

Change the Alternate Row Color in one of the queries

Create a query that calculates the LowestCost, HighestCost, AverageCost Set the caption property to include a space. Run the query and resize all columns in datasheet to best fit. Save and name the query.

Create a new Calculated Field using Expression Builder

Create a Parameter Query Create the query so that data appears even though there are no values in the field

Create one Action Query

IV.REPORTS 15 points

ONE REPORT FROM EACH TABLE

INCLUDE TOTALS on a field of your choice

Include A PICTURE of your choice

Apply Conditional Formatting to a field of your choice

Create one Custom Report of your choice

V. EMBEDDING A FILE 5 points

(Word document) Describing the purpose of your database and description of the design (contents of tables, primary keys, location of macros, what events are macros performing) and whatever additional information you want to include. Place in the first table

VI. MACROS 5 points

Include macro/macros with an attached command button of your choice in one of the objects. Notify instructor in Word document in first table where located.

VII. DATABASE 10 points

DEFINE A DATABASE RELATIONSHIP WITH AT LEAST two OF THE TABLES (a Primary and related table/tables) 5 points

Enforce referential integrity and then Cascades Updates option for this Relationship 2 points

Create and save a Database Relationship report 1 point

Backup, compact and repair the database 2 points