CIS 225 Project Guidelines

Based on your Client Request Worksheet, create an Access database that follows the guidelines listed for each of the following areas.

Database Table Design

Create your database tables using the methods that were discussed over the course of this semester. Remember, Access is a Relational Database Managements System, make sure to create valid relationships between tables, each containing the necessary primary and foreign keys. Design your database to the Third Normal Form. Consider all the field properties while designing your database tables.

Data Entry

Create all the necessary forms and sub-forms to allow a user to enter new customer and/or product information. Be sure to implement all the necessary data validation features to reduce errors and ensure high quality data is being entered into the database. Be sure to design forms that are appealing to the eye and not the default form layout provided in Access.

Custom Queries and Reports

Your Client Request outlines three custom reports and queries that are necessary for the company to operate efficiently. When creating these reports, do not use the default report designs. Customize them and make them look appealing to the user.

Switchboard

Once you have created your database and are able to enter all the necessary data and run reports and queries, create a switchboard to make it easy for any user to quickly navigate to necessary functions and reports.