1. Create a database with four tables on page
304 of the text book,
Capron, Computers, Fifth Edition,
The Benjamin/Cummings Publishing Company, 1998..
2. Create a query to show only three fields LNAME, FNAME and PHONE for table one.Open Microsoft Access Program. Choose Blank Database. Click O.K. Give a file name (Choose H: folder or A: drive first). Click Create. Choose Table. Click NEW. Click Design View. Type in field names and field types. Choose a key field before save this table. Go to Database View. Type in data and save table. Close the first table and click new table to do the second table.
3. Create a query to find which company order more than 12 in QTY.
4. Create a query to link table one and table two and find the first name and last name of the sale representive for each company.
5. Create a query to find total quantity of ordering for each item. (You need to use "BY GROUP")
6. Create a report for each table and each query that you have created.