Microsoft Office/Access Basic Exam

Vocabulary
http://www.yacapaca.com Go to the web page and take the Access Basics Test.

Project 1

 * 1) Open the Database found at this web site: Bob's Bike Rental
 * 2) Save As the database to your drive so you can edit it
 * 3) Create a Form for entering a new Client
 * 4) Enter yourself into the database as a client
 * 5) Create a new table called RENTALS that contains the following fields
 * 6) *Employee ID - DataType: Text - Size 4
 * 7) *Client ID - DataType: Text - Size 4
 * 8) *Bike ID - DataType : Text - Size 4
 * 9) *Time Out - DataType: Date/Time
 * 10) *Time In - DataType: Date/Time
 * 11) Add 4 records to the Rentals table - check for IDs from the other tables
 * 12) Create a Simple Query on the Clients Table
 * 13) *Pick all the fields in the table for the query
 * 14) *Run a query to find all Client IDs that have an A in them.
 * 15) *Print the Query
 * 16) Create a Simple Query on the Rentals Table
 * 17) *Run an AND query to find all the clients who left after 10:00 AM and came back before 12:00 PM
 * 18) *Change or add a record that fits this query so it is not empty
 * 19) *Print the Query
 * 20) Create a Joined Table Query called RENTAL INVOICE QUERY that includes:
 * 21) *Employee ID from the Rental Table
 * 22) *Employee Last Name from the Employee Table
 * 23) *Client ID from the Rental Table
 * 24) *Client First Name from the Client Table
 * 25) *Client Last Name from the Client Table
 * 26) *Client Phone Number from the Client Table
 * 27) *Bike ID from the Rental Table
 * 28) *Bike Description from the Bike Table
 * 29) *Bike Rental Cost from the Bike Table
 * 30) *Time out from the Rental Table
 * 31) *Time In from the Rental Table
 * 32) *Compute the amount of time the bike was rented - Total Time:([Time In]-[Time Out])*24
 * 33) *Compute the total amount due for the rental - Total Cost:[Total Time]*[Bike Rental Cost]
 * 34) Create an invoice Report from the Joined Table Query
 * 35) *Print the Report
 * 36) *For Extra Credit Make the Report Look Better - columns wider to fit the data and other changes that make it look better
 * 37) *For Extra Credit Make the Report Group by Client