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.
It should go without saying, but this database needs to be original - one you created on your own, for this class, at this time, and for this assignment. You cannot use the database model created during the Database Down & Dirty day. Submitting a database created by someone else, or for another class, will not be accepted