BAB220 – Access Project

Project description
As mentioned in class, you now need to start thinking about the Access Assignment.
The end result will be an Access application that will solve a problem. This could solve a real or imagined problem. It should be a manageable task, not one that will

necessarily revolutionize the company, although you never know. You should plan on using two related tables. You could also use other tables as sources for lookup

information. To be fully functional, it will probably require at least two queries, forms for input and update, and reports based on the queries.

As mentioned in class, you now need to start thinking about the Access Assignment.
The end result will be an Access application that will solve a problem. This could solve a real or imagined problem.  It should be a manageable task, not one that will

necessarily revolutionize the company, although you never know.  You should plan on using two related tables.  You could also use other tables as sources for lookup

information.  To be fully functional, it will probably require at least two queries, forms for input and update, and reports based on the queries.
You may use your own idea, or you may use an idea from the list below.
Proposal
The first step of the assignment will be to summarize your intentions on paper and discuss it with me.  This typed document should contain your data dictionaries for

your application.  You should describe the general purpose of the application and the type of information it will handle, what data it will require, and what

information it will supply.  A data dictionary lists the tables used, fields and data types in those tables, and the relationship between the tables.
Final Submission
1.    Your final submission should contain both your Access file, and a Word file that explains how your application works, i.e. a one or two page user manual

describing the purpose of each of your Queries, Forms and Reports.  Send your final Access and Word file to senecafiles@gmail.com by the due date. Real Estate Listing.
2.    Training Records – HR.
3.    Daycare Payments received.
4.    Parking Ticket Management.
5.    Special Orders – Retail Stores.
6.    Repair – Maintenance Log.
7.    Expense reporting system.
8.    Lost & Found.

Jeff Shnier
Some topics, or choose your own;

9.    Employee Personnel.
10.    Resumes received.
11.    Employee Training Records.
12.    Dining Room Reservations.
13.    Your own ideas…