Database Solution

You will be creating a database using MS Access that could be used to organize something. But first, you will use SimNet to refresh your memory about MS Access.

 

The minimum elements it should contain follow:

•Create at least 3 tables, 2 primary tables and a related table

oConsider using a concatenated key for the primary key in the related table

•Impose appropriate field types and lengths on all fields

•Ensure the database is in 2NF (second normal form)

•Insert the 3 data integrity (data validation) checks / controls listed below:

oRequire that a field that is not a primary key be populated (Access automatically requires primary keys be populated.)

oImpose limits on the value that can be entered into a number or currency field

oEstablish a list of valid values that can be used in a field

•Force referential integrity between your tables

•Add 1 index on a field other than a primary key (Again, Access automatically indexes primary keys.)

•Create 2 queries that include this functionality, work and make sense:

oData from multiple tables

oAn aggregate total in the datasheet view

oA sort

oComplex selection criteria (uses And or Or logic)

•Create 1 report

•Create 1 form with a subform

 

In addition to uploading the database, you should upload a Word file where you:

1. Describe your database and what is being tracked in it.

2. Note which are primary and which are related tables.

3. 4. Note the field you indexed and describe the reason for indexing the field you chose.

6. List the fields that are primary and foreign keys in each table.

7. Explain the type of relationship (one-to-one, one-to-many, many-to-many) that exists between your tables.