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 RubricStandards 1 Points2 Points3 Points4 Points5 PointsCreate a FormNeeds teacher assistance to create a formCan create a form but is missing three key elementsCan create a form independently but is missing two key elementsCan Create a form independently but is missing one key elementCan Create Form completely on their own for entering a new client. Add a Record to a TableNeeds 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 tablesCan create records into a table but the data does not fit with another tableCan create records into a table that fit with the other tables completelyCreate a TableCan 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 QueryIs missing four or more elements, or needed teacher assistance to create the queryIs missing three elementsIs missing two elementsIs missing one elementCan create a simple query on one table of a database with all fields in the query. Limit a Query with CriteriaNeeds teacher assistance to limit the query by a criteriaCan independently limit a queryCan independently limit a query to return valuesCan independently limit a query to return the desired valuesCan accurately and independently limit a query to return the desired valuesRun a Query with AND CriteriaNeeds teacher assistance to limit the query by a criteriaCan independently limit a query with AND logicCan independently limit a query to return values with AND logicCan independently limit a query to return the desired values with AND logicCan accurately and independently limit a query to return the desired values with AND logicCreate Joined Table QueryTeacher assisted creating the joined table queryJoined Table query is missing three elementsJoined Table query is missing two elementsJoined Table query is either missing one field, or it is from the wrong tableJoined Table Query includes all of the fields from the correct tableCreate Calculations in a QueryTeacher gives assistance to create calculationsIndependently creates the calculationIndependently creates the calculation accuratelyIndependently creates the calculation accurately and it returns valuesIndependently creates the calculation accurately and it returns the correct valuesCreate a Report from a QueryReport is missing four or more elementsReport is missing three elementsReport is missing two elementsReport is missing one elementReport is created from the joined table query, prints to one page, and includes all information.