View the step-by-step solution to:

Access Minicase Purpose: Excel is often used to create spreadsheets and graphs and is also useful for calculations through formulas which use...

please check the attachment of my question. thanks

Access Minicase Purpose: The purpose of this assignment is to recreate this database using Microsoft Access. Excel is often used to create spreadsheets and graphs and is also useful for calculations through formulas which use reverenced cells to automatically calculate an outcome depending on the variables in the cells. On the other hand, an Access database, like many other types of databases, is used to store and organize large amounts of data into tables. The database is essentially a series of linked tables containing their respective data. The database structure reduces redundant data which can be present in large spreadsheets, stores all data in one central location, increases data accuracy, and increases overall efficiency among other things. A database also allows one to query the data to produce detailed reports. A query allows one to determine, for example, “All the students who got B+ or greater in Desc 200 in the Fall 2008 semester” or “What is the best selling book on eBay in July 2009?”. As well as providing information via Queries, Access can be used to create Forms and Reports among many other things. Please see the attached Access file containing the above database for some example of what can be done using Access.
Background image of page 1
Requirements: 1. Recreate the above database using Microsoft Access. a. Create the tables as shown above b. Create the relationships between the tables as shown above. Remember to include the many-to-one symbols as well. c. Enter approximately 3 rows of fake (make it up) data in each table. 2 . Prepare a Word document (1 to 2 pages) “selling” your database solution. One suggestion would be to describe the problems/disadvantages that one could have with the old system of manual filing or using a spreadsheet to store and query large amounts of data. You could then briefly explain your database and why it is a good solution, and then describe the advantages to your solution. 3 . Create a PowerPoint presentation (5 to 6 slides) summarizing the key points in your Word document.
Background image of page 2
Sign up to view the entire interaction

Top Answer

Dear Student, Thank you for... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online