Question: Instructions use the Database Management System software, Access, for information management. You are required to create tables, build relationships between the tables, and extract useful
- Instructions use the Database Management System software, Access, for information management. You are required to create tables, build relationships between the tables, and extract useful information from the table with Access. Below are the requirements. First Create Products, Categories, and Suppliers table in Access. You may refer to Table2 file for the detailed information about the field names, data types, validation rules, values, etc. You need to create the exact same tables in Access as the ones shown in Table2 file. (Hint: you may use the External Data tab to import those tables in the excel file, which is faster but you need make slight modification about the relation structure afterwards.) 20 Points. Build relationships between three tables. The SupplierID field in Suppliers table and the SupplierID field in Products table has 1:many relationship. The CategoryID in Categories table and the Category ID in Products table has 1:many relationship. (Hint: You may use Database Tools tab -> Relationships function to build a relationship between tables.) 20 Points. Create the following queries and save your query results: (Hint: Use Query Design under Create tab) Query1: List the products whose unit price is greater than $20. (20 Points) Query2: List the products whose unit price is greater than $30 or less than $20. Sort the results by unit price in ascending order. (20 Points) Query3: List the suppliers who provide the product "Chang". (20 Points) In summary, your finished assignment should have six objects: Products table, Categories table, Suppliers table, Query 1, Query 2, and Query 3. The query tables should look like the following.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
