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
   • 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
6. Add 4 records to the Rentals table - check for IDs from the other tables
7. 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
8. 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
9. 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]
10. 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.