For courseworkhero.co.uk

Access homework

Access Practical Exam (20

1

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

Item ID

Donated Item

07-SP 1

Anthony

Basketball jersey

07-SP 2

Bonds

Athlete

Baseball bat

07-AT 1

Clooney

Photo

07-AT 2

Eastwood

Actor

Movie poster

07-SP 4

Elway

Athlete

Football

07-CM 1

Leno

Classic model car

07-CM 2

Letterman

Comedian

Coffee mug

07-AT 3

Murray

Actor

Athlete

Celebrity Auction Items
Celebrity Last Name	First Name	Profession	Starting Bid
Carmelo				Athlete	$39.99
Barry	$750.00
George			Actor	$15.00
Clint	$99.95
John	$250.00
07-MU 3	Wolfe	Howling	Singer	Guitar	$175.00
Jay		Comedian	$ 85.00
David	$15.00
Bill	Golf Cap	$ 23.00
	07-SP 3		Carter	Chris	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

Carter

Jersey

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)

Last Name

Athlete

Actor

Athlete

Comedian

¤ 15.00

Actor

Athlete

	Item ID		Celebrity	First Name	Profession		Donated Item	Starting Bid
	07-AT 1		Anthony	Carmello				Athlete		Basketball jersey	¤ 39.99
	07-AT 2		Bonds	Berry		Baseball bat	¤ 750.00
	07-AT 3		Clooney	George			Actor		Photo		¤ 15.00
	07-CM 1		Eastwood	Clint		Movie poster	¤ 99.95
	07-CM 2		Elway	John		Football	¤ 250.00
	07-SP 1		Leno	Jay		Comedian		Classic model car	¤ 85.00
	07-SP 2		Letterman	David		Coffee mug
	07-SP 3	Cater	Bill	Golf Cap	¤ 23.00
	07-SP 4		Murray	Chris	Football jersey	¤ 150.00

Item ID Donated Item Celebrity

07-AT 1 Photo Clooney

07-AT 2 Movie poster Eastwood

07-AT 3

Murray

07-CM 1 Classic model car Leno

07-CM 2 Coffee mug Letterman

07-SP 1 Basketball jersey Anthony

07-SP 2 Baseball bat Bonds

07-SP 3

07-SP 4 Football Elway

Description
8X10 Glossy Photo
1973 High Plains Drifter Poster
Golf cap	Caddyshack Bushwood Gold Cap
Classic Model 1965 Corvette
Late Show Coffee Mug
Denver Nuggets Adult jersey
Rawlings Big Stick
Jersey	Carter	Autographed Minnesota Vikings Adult Jersey Photo
Official NFL Leather Football

SELECT DISTINCTROW *
FROM [Celebrity Auction Items];
SELECT DISTINCTROW *
FROM [Donated Celebrity Items];
SELECT [Celebrity Auction Items].[Item ID], [Celebrity Auction Items].[First Name], [Celebrity Auction Items].[Celebrity Last Name], [Celebrity Auction Items].[Profession], [Celebrity Auction Items].[Donated Item]
FROM [Celebrity Auction Items];