CIS 110 Access 3 Assignment

 

Maintaining a Database Using the Design and Update Features of Access

 Key Concepts
  •  Add, change and delete records
  •  Search for records
  •  Filter records
  •  Update a table design
  •  Format a datasheet
  •  Use queries to update records
  •  Specify validation rules, default values & format
  •  Create and use a Lookup field
  •  Specify referential integrity
  •  Use a subdatasheet
  •  Sort records
  •  Create indexes

 

Videos

What to do

1.      Create a copy of the database used on the previous project.

Create copies of the databases as follows:

Ashton James College 2.mdb  -->  Ashton James College 3.mdb

City Guide 2.mdb  -->  City Guide 3 .mdb

 

 Videos

o                                Copy a database using Windows Explorer - (1:48 - 378KB)

o                                Copy a database using Access Backup feature - (1:11 - 320KB)

 

3.      Complete SAM training and test for Access 3

4.      Pages AC 114 to 164 - Ashton James College; this assignment is not graded or submitted

 Requirements

 Deleted, Added & Modified Records

 Modified Client Table - Name Field size

 Added Validation - Design, Table

 Added Combo Box Lookup - Design, Table

 Added Referential Integrity

 Total possible for uploading Ashton James College 3.mdb

 

2.      Pages AC 170 - #3 Maintaining the City Guide Database , start by opening City Guide 3 .mdb
 Upload the completed database as City Guide 3 .mdb

Part 1:

Points

 Name

4

 Added Validation - Design, Table

4

 Added Combo Box Lookup - Design, Table

Part 2:

Points

 Name

4

 Added, Updated records

Part 3:

Points

 Name

4

 Added Referential Integrity

4

 Changed number for ad rep 26 to 21

20

Total possible for uploading City Guide 3.mdb

Drop Box - Upload Your Assignments to the Digital Drop Box

Downloads - Student files from publisher