Homework: Queries & SQL
In this homework, you are given a complete database file (located in the homework following this page) which sets the stage for the following list of queries. After you create and test your query, then save it under the name given as a part of the instructions for each query. Note that the file referenced below is located in the homework submission folder that immediately follows this page.
I. Download the Module4.accdb database. (Located in the homework submission folder located after this page.)
II. Get to know the tables.
III. Review the Relationship across all the tables. This will help you when you work on a multi-table query.
IV. Create a query to list all the data from the Customers table ordered in the ascending order of the State field. Save the query as Q1
V. Create a query to list the Company name, address and balance of the customers who have a balance over $0. Save it as Q2.
VI. Create a query to list the names of the customers who purchase a GMC Pickup (ID 59) or Ford Convertible (ID 15). This is a multi-table type of query. Save it as Q3.
VII. Create a parameter query of your choice. Use any table and criteria you choose. Save it as Q4.
VIII. Create a multi-table query of your choice using an ‘AND' operator. Save it as Q5.
Format your homework according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.
Attachment:- Module-Table.rar