CPT 172 (MICROSOFT ACCESS) FINAL PROJECT Effective: 7/18/2017 DUE DATE: BE SURE

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, 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

Explanation / Answer

I.TABLES (Enter data in your tables)

step1: First open MS Access from start menu in windows and click on Blank database. It will create blank database. You can also change your database name.

step2:click on create menu from menu bar that is displayed above. From that menu tab click on table Design.Then put all the field that you needed and corresponding datatype.To give primary key to a field click on Design tab from menu bar and select on primery key.Then click on save in Quick access bar, give the table name and save.It will create table in the database.

step3:Repeat step 2 untill u created all the table.

step4:You can set validation rule for each field/column in the table.There is a field properties avaliable in below for each field you can set the validation rule from there.

step5:Lookup is a set of values that will easy your data input process in the field by giving a certain set of values.In the field properties click on lookup tab to create lookup for any field.

II. FORMS

step1:Form is the tool that let you to input the data to your table at a time and subform is the sorm which is created if the main table is related to any other table.To create form for a table click on create then click on form. It will create the form and sub form.

step2:To insert title and picture in a form select the form for which you want to insert title and picture.Then click on Design in menu bar.Then select the Picture aand lebel icon to insert picture and ltitle to a form.

step3:To create custom form select the table for which you want to create a custom form.Then click on blank form and select combo box and input value accordingly.

III.QUERIES

step1:Select Create from menu bar then go to Query wizard and select table for which you want to create Query.Then create Query.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.