AIMS2710-Access Project

Applied information managent systems

You have recently been hired by Sharbaf and Associates, a small sized firm that offers consulting IT innovative services for the various industries. Your job is to create a database. The database should contain the following criteria information:

At least three tables (primary key for each table)(20 points).

At least 6 attributes (field) for the table 1, at least 5 attributes (field) for the table 2, and 3(10 points)

Each table should have at least 10 records (10 points).

Establish Entity Relationship Diagram (ERD) for the tables(1:1, 1:M, and M:M)(20 points)

Create forms for the tables.(10 points)

Create a query for the tables (establish your criteria for each table)( 20 points).

Create a report for the tables (10 points).