I need help on MS Access Project.

timer Asked: Nov 25th, 2017
account_balance_wallet $40

Question Description

I have a project for database class. it is a database MS access project. I attached the project instruction below. I want it to be done before Tuseday November 28.

Unformatted Attachment Preview

Northern Virginia Community College ITD 256--Advanced Database Management MS Access Project Instructions: Due in Blackboard by 11/30/2017 @ 11:59PM This project represents 12% of your final grade. Here are the outlines and requirements of the project. 1. This is an individualized project. 2. Create a database in Microsoft Access 2013 or 2016. 3. You must have a topic for your database. 4. As part of database description document, create an Entity-Relationship diagram for your database, use the CHEN model. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. The database must have least 4 tables; additional tables are permitted. Each table should have at least 5 columns and 15 records. The database must be normalized with no unnecessary redundancy. You should use data and table validation rules and data validation text for each table. Each table must have either a single field primary key or a composite primary key. Implement foreign key in the tables build relationships with other tables. Implement input masks for all the fields that accepted inputs masks (such as Social Security Number, phone number, zip code, password, etc). At least one of the four tables must have numbers and/or currency data type and use them in calculated fields in one of the queries. Your database must have relationships and referential integrity established between the tables. 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 as a database query.. At least two queries should pull data from at least two tables. Implement Combo Box and Option Group in your forms. At least one implementation of each feature should be part of your forms. A switchport interface should be created to control access to your database form and reports. Each form should have Control buttons to navigate back and forth to the switchboard. Your database must include 4 working forms, one from each table. Your database forms may have pictures related to the database entries [optional]. Your database must include 4 reports. One from each table. Check spelling and grammar in your database. 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 Microsoft Access a tool for teaching this class Deliverables: In one zipped file includes the following files: (1) Access database file, (2) database description document. 1 ...
Purchase answer to see full attachment

Tutor Answer

School: UIUC

Hey buddy,in case you need any clarification, do not hesitate to contact me buddy.All the best

Databese Documentation
My database is a garage management system that keeps track of cars being repaired or serviced and the
parts used on these cars. The database also tracks the number of stocked parts in store and their
movement. It also shows all the transactions that have taken place, cost of e...

flag Report DMCA

Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors