Design project -- 2
This project received 9 bids from talented freelancers with an average bid price of $26 USD.Get free quotes for a project like this
Project Budget$10 - $30 USD
This is an individualized project.
2. Create a database in Microsoft Access 2013.
3. Your project description page should have your name and email address the topic of your database.
4. You must have a topic for your database. A database should serve a purpose and address specific database problem.
5. Create an Entity-Relationship diagram for your database, use the CHEN model.
6. The database should have at least 5 tables; additional tables can enrich your design and improve your database functionality. The each table should have at least 15-25 records (more is acceptable).
7. The content must be relevant to the database fields.
8. The database must be normalized.
9. You should use data and table validation rules and data validation text for each table
10. Each table must have either a single field primary key or a composite one.
11. You must have foreign keys to build relationships between your tables.
12. Your database must have input masks for all the fields that accepted inputs masks (such as Social Security Number, phone number, zip code, password, etc).
13. Your database must have relationships and referential integrity established between the tables.
14. Your database must have at 10 none trivial queries with criteria. Each query should be stated in English in the project description document then answered in Access GUI interface.
15. 4 queries should pull data from at least two tables.
16. Implement Combo Box and Option Group in your forms. At least one implementation of each feature should be part of your forms. Two Combo Box and Two Option Groups
17. A switchport should be created to control access to your database objects such as form and reports. Each form should have a Control button
18. Your database must include 4 working forms. Each form adds data to each of the tables in the database..
19. Your database forms may have pictures related to the database entries [optional].
20. Your database must include 4 reports --- 2 reports based on tables and 2 reports based on queries.
21. Check spelling and grammar in your database.
22. Using Word, type a detailed document explaining what your database is about and its architecture, design on how it works. Include explanation of the data in the tables, queries, forms, reports. Why you chose this specific topic, what type of problems or challenges have you encountered? How much did you learn from this project in relation to the class concept and how much did you learn MS Access as a database application. What do you think of access as a tool for teaching this class
23. Deliverables: In one zipped file includes the following files: (1) Your database file, (2) Your database description document including database design in ERD
Browse Related Skills
Other things people do on Freelancer
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online