Posted: November 9th, 2015

Access database

Access database

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
o Consider 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:
o Require that a field that is not a primary key be populated (Access automatically requires primary keys be populated.)
o Impose limits on the value that can be entered into a number or currency field
o Establish 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:
o Data from multiple tables
o An aggregate total in the datasheet view
o A sort
o Complex selection criteria (uses And or Or logic)
• Create 1 report
• Create 1 form with a subform

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET A GOOD DISCOUNT 🙂