Question
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,
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started