BAB220 – Access Project
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 th e tables.
Final Submission
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
[email protected] by the due date.
Jeff Shnier
Some topics, or choose your own;
1. Employee Personnel.
2. Resumes received.
3. Employee Training Records.
4. Dining Room Reservations.
5. Real Estate Listing.
6. Training Records – HR.
7. Daycare Payments received.
8. Parking Ticket Management.
9. Special Orders – Retail Stores.
10. Repair – Maintenance Log.
11. Expense reporting system.
12. Lost & Found.
13. Your own ideas…