Access Assignment #1

First Problem: Create a database and a table that contains both text and numeric fields. Since you will be using this table to test queries, be sure to include appropriate data for a variety of tests. Take pictures of the design and the data and include them in your submitted assignment.

Second Problem: Do the following queries. Submit pictures of the design and copy and paste or take pictures of the results.

Download/print http://w3.one.net/~jhoffman/sqltut.htm - it is a good tutorial on SQL and you will find it very helpful in doing this assignment. Also, my notes on SQL are out on the Web (they were written for Ingres, not Access, so there may be some slight variations).

Third Problem: Do the following queries using SQL. Submit pictures of the SQL and paste or take pictures of the results.