Database Middle East College Database University Book Store Database HW University Book Store has planned to create a database to manage its data. You are

Database Middle East College Database University Book Store Database HW University Book Store has planned to create a database to manage its data. You are required to create a system using MS Access to store the required information. Save the database as University Book Store Database.

Ø Section I – Tables

1. University Book Store database may include tables like Author, Books, Publisher, orders, order Details. You are required to do the followings:

A. Include these tables (Author, Books, Publisher, orders, order Details.) in your database, the names and the data types of all columns should be correct & appropriate. You may add other tables if you find them necessary.

Note: all the table should at least include 5 Field except the junction tables.

B. Use [Field size, Default Value, validation Rule and text, calculated field (Division, Multiplication and others), if statement, look up wizard, table formatting].

C. Assign Primary Key for each table.

D. Identify the foreign key and create the relationship between the tables.

Ø Section II – Queries

Note: Use only 4 Main Tables to create Query, Forms & Reports

1. Create Author Books query to know totals of how many books each author wrote. Include the required fields.

2. Create a parameter query to show the details of the books and their orders. By adding required fields. Use the parameter to ask the end user to enter the Book Title. Save the query as Book orders.

3. Create a query to show the books and their authors and which publisher has published. Include the required fields and add any criteria used for text and any criteria used for number. Save query as Book Details.

4. Create Details of Orders to show the details of University store orders. Include the required fields and use date and number criteria’s in this nquery. Sort the query by Order ID in Ascending order.

Ø Section III – FORMS

1. Create one multi-table Form using from wizard and one table form using blank form. Ensure that data in all fields are readable.

2. These forms should include the following:

A. Tile and Date & Time in form Header.

B. At least two Buttons in form Footer.

C. At least other controls in form Details (such as Combo Box, tab control, hyperlinks or others).

D. Make the following change to the label and data field border for the both Form. Change the Label font color to Dark Green color and make it bold and change the data field border to Dark Red color and thickness to 2pt.

Ø Section IV – REPORTS

1. The database should include two multi-table reports created using report wizard and blank report mentioned along with the Name of the company. Ensure that data in all fields are readable.

2. The Reports should include the followings:

A. Date & Time and in Report Footer.

B. Add Page Number in Page Footer.

C. Change the format of Reports:

 Set Report Background Color to Light Orange

 Add Company Logo at the right Corner

 Set Report Orientation to Portrait

 Set Page Header Font to Aril Black.

 Set All the Field data and Field Header alignment as Center

*** Use MS Access for this assignment.