# Microsoft Office/Access Basic Exam
## Vocabulary

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

## Project 1

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

## Project 1 Rubric

Bike Rental Rubric :
| Standards | 1 Points | 2 Points | 3 Points | 4 Points | 5 Points |
| Create a Form | Needs teacher assistance to create a form | Can create a form but is missing three key elements | Can create a form independently but is missing two key elements | Can Create a form independently but is missing one key element | Can Create Form completely on their own for entering a new client. |
| Add a Record to a Table | Needs teacher assistance to create records into the table. | Has some troubles in creating records into a table. | Can create records into a table but much of the data does not fit with other tables | Can create records into a table but the data does not fit with another table | Can create records into a table that fit with the other tables completely |
| Create a Table | Can create a table that meets the criteria of the database, but is missing four of the elements for the field definitions. | Can create a table that meets the criteria of the database, but is missing three of the elements for the field definitions. | Can create a table that meets the criteria of the database, but is missing two of the elements for the field definitions. | Can create a table that meets the criteria of the database, but is missing one of the elements for the field definitions. | Can create a table that meets the criteria given for the database. All field names, DataTypes and field sizes are accurate. |
| Create a Query | Is missing four or more elements, or needed teacher assistance to create the query | Is missing three elements | Is missing two elements | Is missing one element | Can create a simple query on one table of a database with all fields in the query. |
| Limit a Query with Criteria | Needs teacher assistance to limit the query by a criteria | Can independently limit a query | Can independently limit a query to return values | Can independently limit a query to return the desired values | Can accurately and independently limit a query to return the desired values |
| Run a Query with AND Criteria | Needs teacher assistance to limit the query by a criteria | Can independently limit a query with AND logic | Can independently limit a query to return values with AND logic | Can independently limit a query to return the desired values with AND logic | Can accurately and independently limit a query to return the desired values with AND logic |
| Create Joined Table Query | Teacher assisted creating the joined table query | Joined Table query is missing three elements | Joined Table query is missing two elements | Joined Table query is either missing one field, or it is from the wrong table | Joined Table Query includes all of the fields from the correct table |
| Create Calculations in a Query | Teacher gives assistance to create calculations | Independently creates the calculation | Independently creates the calculation accurately | Independently creates the calculation accurately and it returns values | Independently creates the calculation accurately and it returns the correct values |
| Create a Report from a Query | Report is missing four or more elements | Report is missing three elements | Report is missing two elements | Report is missing one element | Report is created from the joined table query, prints to one page, and includes all information. |