Microsoft Office/Access Basic Exam

Vocabulary

edit

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

Project 1

edit
  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

edit
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.