For Allen

Access Practical Exam (2013 Edition)

1. Begin by creating a new blank database, save it to your PC, and name it Annual Celebrity Auction 2013 Last Name . Make sure it is an Access 2010 database file type (.accdb).

2. You will create a new table inside this database as shown below and name it Donated Celebrity Items . Set all fields as text data type. Set Item ID as the primary key field.

Item ID	Donated Item	Celebrity	Description
07-AT 1	Photo	Clooney	8X10 Glossy Photo
07-AT 2	Movie poster	Eastwood	1973 High Plains Drifter Poster
07-AT 3	Golf cap	Murray	Caddyshack Bushwood Golf Cap
07-CM 1	Classic model car	Leno	Classic Model 1965 Corvette
07-CM 2	Coffee mug	Letterman	Late Show Coffee Mug
07-SP 1	Basketball jersey	Anthony	Denver Nuggets Adult Jersey
07-SP 2	Baseball bat	Bonds	Rawlings Big Stick
07-SP 4	Football	Elway	Official NFL Leather Football

3. You will create another new table inside this database as shown below and name it Celebrity Auction Items . Set all fields as text data type. Set Item ID as the primary key field in this table also.

Celebrity Auction Items
Item ID	Celebrity Last Name	First Name	Profession	Donated Item	Starting Bid
07-SP 1	Anthony	Carmelo	Athlete	Basketball jersey	$39.99
07-SP 2	Bonds	Barry	Athlete	Baseball bat	$750.00
07-AT 1	Clooney	George	Actor	Photo	$15.00
07-AT 2	Eastwood	Clint	Actor	Movie poster	$99.95
07-SP 4	Elway	John	Athlete	Football	$250.00
07-MU 3	Wolfe	Howling	Singer	Guitar	$175.00
07-CM 1	Leno	Jay	Comedian	Classic model car	$ 85.00
07-CM 2	Letterman	David	Comedian	Coffee mug	$15.00
07-AT 3	Murray	Bill	Actor	Golf Cap	$ 23.00
07-SP 3	Carter	Chris	Athlete	Football jersey	$ 150.00

4. Delete the record 07-MU 3, Wolfe, Howling from the Celebrity Auction Items table.

5. Add a record to the Donated Celebrity Items table:

Item ID	Donated Item	Celebrity	Description
07-SP 3	Jersey	Carter	Autographed Minnesota Vikings Adult Jersey Photo

6. Create a simple form using the Celebrity Auction Items table and name it Celebrity Auction Items Form.

7. Create a query using Simple Query Wizard and using the Celebrity Auction Items table with the fields: Item ID, First Name, Celebrity Last Name, Profession, and Donated Item in this order. Name query Celebrity Auction Items Query .

8. Using this query find all records that have the profession as “Actor” by using the Criteria row in Design view. Save query as Celebrity Auction Items Actor Query .

9. Create a report of the Donated Celebrity Items table. Your report will have only the three fields, Donated Item, Celebrity, and Description. All records will be listed. Use Landscape orientation. Name the report Donated Celebrity Items List.

10. Close the database. Submit an electronic copy of your database file through the Access Practical Exam link in ppccConnect (D2L).

1

2013 (201330)