Introduction+to+databases

A - ACCESS Databases ** Open Microsoft ACCESS


 * 1) Pages AC 24 – AC 63 Save As: **JSP Recruiters Database**
 * 2) Pages AC 64 – AC 65 Save and Open: [[file:The Bike Delivers.accdb]]
 * 3) Pages AC 65 – AC 66 Save and Open:[[file:Camden Scott College.accdb]]
 * 4) Pages AC 66 – AC 67 Save and Open:[[file:SciFi Scene.accdb]]
 * 5) Pages AC 71, #1 Save and Open: [[file:Case 1-1 Second-Hand Goods.docx]]
 * 6) Pages AC 71, #2 Save and Open: [[file:Case 1-2 BeachCondo Rentals.xlsx]]


 * OLD Example Database Work**

** Assignment 4 - Database queries ** The queries are listed at the end of the workbook:
 * **A4-1 - Bravant Marine Database** - Follow instructions and complete **queries 1-14.**
 * **A4-2 - School Connection Database** - Follow instructions and complete **queries 2-16.**
 * **A4-3 - City Area Bus Company Database** - Follow instructions and complete **queries 2-14.**
 * **A4-4 - Resort Rentals Database** - Follow instructions and complete **queries 2-14.**

** Assignment 3 - Learning the MS ACCESS Database Software - 100pts ** Get the ACCESS database worksheet from me and follow the instructions. Do not print anything when asked. When you are finished with the worksheet you will have created the following databases and tables: 1. **Bavant Marine Services Database (25 pts.)** 2. **School Connection Database (25 pts.)** 3. **City Area Bus Company Database (25 pts.)** 4. **Resort Rental Database (25 pts.)**
 * Marina Table & Data
 * Technician Table & Data
 * Item Table & Data
 * Vendor Table
 * Advertiser Table & Data
 * Sales Rep Table & Data
 * Rental Unit Table & Data
 * Owner Table & Data


 * FRIDAY, May 20 DO NOW**
 * Download and Complete:**

__**Thurday, May 19 DO NOW**__
 * Download and Complete:**


 * Download and READ:**