Question: Create a database using Microsoft Access that contains data commonly used by a College Bookstore. The database should contain data about Books, Courses, and track

Create a database using Microsoft Access that contains data commonly used by a College Bookstore. The database should contain data about Books, Courses, and track which Book is used by which Course. Think about the concept of breaking up/arranging your data elements into 'themes' or related/linked tables. Your database should include the following fields at a minimum: BookId, BookName, PublisherName, CourseID, CourseName, a field noting what Department offers the Course, and a field tracking which Book is used by which Course. Define the tables and keys. Enter 3 to 5 rows of sample data into each of your tables, to represent 3 to 5 hypothetical college courses, and the related Books. Create an Access Form for each table that allows you to view and enter data. Create an Access Report that displays a listing of your data from one of your tables. Note: I am giving some specifics above, but I am also expecting you to come up with the structure of the tables/themes, and I am letting you decide how your form and report will look. (Please do in MS Access 2013 or 2016 or 2019)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!