Perform the following tasks: Step Instructions Points Possible

Start Access. Open the downloaded Access file named a04ws08_grader_a1.accdb.

Save the file with the name a04ws08Putts_LastFirst, replacing LastFirst with your name.

Enable content, if necessary. 

Create a Make Table query based on tblParticipant and tblOrder of all participants who have placed an order with the Putts for Paws Charity.

Include ParticipantID, FirstName, LastName, and ContactPhoneNumber from tblParticipant, and AmountPaid and OrderDate from tblOrder, in that order.

Name the table the query will create tblParticipantOrders.

Run the query, and then save your query as qryParticipantOrderTable.

Close the query. 

Open tblParticipantOrders in Design view. Move the first field, ParticipantID, to be the last field in the table.

Create a new first field named PartOrderID with a data type of AutoNumber and make it the primary key. Add the following custom format: "PO0"0 (that's "POzero"zero) to PartOrderID.

Enter Participant Order ID (primary key) as the description.

For the FirstName field, add First Name as the caption. Enter Participant first name as the description.

For the LastName field, add Last Name as the caption.

Enter Participant last name as the description.

 Continue making the following changes to the tblParticipantOrders table.

For the ContactPhoneNumber field, add the default Phone Number format Input Mask.

Add Phone as the caption. Enter Contact phone number as the description.

For the AmountPaid field, add Amount Paid as the caption.

Enter Amount paid as the description.

For the OrderDate field, add the Short Date format Input Mask.

Add Order Date as the caption.

Enter Order date as the description.

For the ParticipantID field, enter Participant ID (foreign key) as the description.

Save and close the table.

Create a relationship between ParticipantID in tblParticipant and ParticipantID in tblParticipantOrders.

Enforce referential integrity. Save and close the Relationships window.

 Create an Append query that will append the participants in the tblNewParticipants table to the tblParticipant table.

Include all fields in their existing order. Run the query, and then save it as qryAppendNewParticipants. Close the query.

 Create an Update query that will update all address fields and the contact phone for the participants in the tblParticipant table from the data that is in the tblUpdatedParticipantInfo table where the ParticipantID fields match.

Maintain the existing order of the added fields.

Run the query, and then save it as qryUpdateParticipantInfo. Close the query.

 Participant Ian McShane, ParticipantID 3, had notified Putts for Paws that he has to withdraw himself from the event. You have been asked to remove him from the tables in the database.

Update the relationship between tblParticipant and tblOrder to cascade delete related records.

Update the relationship between tblParticipant and tblParticipantOrders to cascade delete related records.

Create a Delete query that will remove ParticipantID 3 from the tblParticipant table.

Run the query, and then save it as qryDeleteParticipant. Close the query.

Create an outer join query that lists all participants and participant orders, even if a participant does not have an order.

Include ParticipantID, FirstName, and LastName, in that order, from tblParticipant, and then include AmountPaid and OrderDate from tblParticipantOrders.

Run the query, and then save your query as qryParticipantOrders.

Close the query. 10 Create an outer join query that lists all participants and participant roles, even if a participant does not have a role.

Include ParticipantID, FirstName, and LastName, in that order, from tblParticipant, and then include CorporateID and Role, in that order, from tblParticipantRole.

Run the query, and then save your query as qryParticipantRoles.

Close the query.  

Create a Find Unmatched query that displays all the participants who do not have an order.

Use tblParticipant as the table you want to see in your results, and tblParticipantOrders as the table that contains the related records.

Include ParticipantID, FirstName, and LastName, in that order.

Save the query as qryUnmatchedPartOrders. Close the query. 

 Create an inner join query that includes Company Name from tblCorporate and Role from tblParticipantRole.

Run the query, and then save it as qryCompanyRoles. Close the query.

Close all database objects.

Close the database and then exit Access. Submit the database as directed. 

Answer rating: 100% (QA)

2 CREATE Table tblMenu MenuID AutoNumber RecipeID INT NOT NULL Index Season Text255 ... View the full answer