Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data Files needed for this Case Problem: Instruction.accdb (cont. from previous module), Support_AC_12_Allen.txt, and Support_AC_12_RoomOptions.accdb Great Giraffe Jeremiah asks you to complete your work with

image text in transcribedimage text in transcribed Data Files needed for this Case Problem: Instruction.accdb (cont. from previous module), Support_AC_12_Allen.txt, and Support_AC_12_RoomOptions.accdb Great Giraffe Jeremiah asks you to complete your work with the user interface for the Instruction database. To meet his request, complete the following steps: 1. Open the Instruction database you worked with in the previous three modules. 2. Open the tblStudent table datasheet, use an AutoFilter to filter records using the City field for values of Englewood and Littleton, and then save and close the table. 3. Use Filter By Form with the qryStudentData query to select all records in which the Last Name is Bailey or Brown. Apply the filter, save the filter as a query named qryBaileyBrownFilter, and then close the query. 4. Create a query named qry 40HoursSubquerythatselectstheInstanceIDfieldfromthetblCourse table for all records that have a value of 40 for HoursPerWeek. (Hint: Do not show the HoursPerWeek field.) Switch to SQL view, copy the SQL code, and then save and close the qry 40 HoursSubquery query. 5. Create a new query in SQL view. Paste the SQL code you copied in the previous step from qry 40 HoursSubquery, add code that uses the current code as a subquery and selects all fields from the tblRegistration table where the InstanceID is in the tblRegistration table, and then run the query. Save the query as qry40HoursSubquerySignupID, and then save and close the query. 6. Add an Attachment field named StudentAttachment to the end of the tbIStudent table, using a Caption property setting of Student Attachment. Cody Allen, one of the students at Great Giraffe, has written a note thanking them for their excellent instruction. The document is stored in the Support_AC_12_Allen.txt text file and is located in the Access3 > Case1 folder. Attach the document to the StudentAttachment field for record 2 (Cody Allen record) in the tblStudent table, resize the Student Attachment column to its best fit, and then save and close the table. 7. Add an AutoNumber field named PlanNum to the beginning of the tblCityPaymentPlan table, using a Caption property setting of Plan Num and a New Values property setting of Random. Specify the PlanNum field as the primary key. Resize the Plan Num column to its best fit in the datasheet, and then save and close the table. 8. Use the Performance Analyzer to analyze the entire Instruction database, but do not implement any of the analysis results. How many analysis results of the Recommendation type did the Performance Analyzer find? Of the Suggestion type? Of the Idea type? If requested, record the answers in a Word document, and submit it to your instructor. Close the Performance Analyzer dialog box. Data Files needed for this Case Problem: Instruction.accdb (cont. from previous module), Support_AC_12_Allen.txt, and Support_AC_12_RoomOptions.accdb Great Giraffe Jeremiah asks you to complete your work with the user interface for the Instruction database. To meet his request, complete the following steps: 1. Open the Instruction database you worked with in the previous three modules. 2. Open the tblStudent table datasheet, use an AutoFilter to filter records using the City field for values of Englewood and Littleton, and then save and close the table. 3. Use Filter By Form with the qryStudentData query to select all records in which the Last Name is Bailey or Brown. Apply the filter, save the filter as a query named qryBaileyBrownFilter, and then close the query. 4. Create a query named qry 40HoursSubquerythatselectstheInstanceIDfieldfromthetblCourse table for all records that have a value of 40 for HoursPerWeek. (Hint: Do not show the HoursPerWeek field.) Switch to SQL view, copy the SQL code, and then save and close the qry 40 HoursSubquery query. 5. Create a new query in SQL view. Paste the SQL code you copied in the previous step from qry 40 HoursSubquery, add code that uses the current code as a subquery and selects all fields from the tblRegistration table where the InstanceID is in the tblRegistration table, and then run the query. Save the query as qry40HoursSubquerySignupID, and then save and close the query. 6. Add an Attachment field named StudentAttachment to the end of the tbIStudent table, using a Caption property setting of Student Attachment. Cody Allen, one of the students at Great Giraffe, has written a note thanking them for their excellent instruction. The document is stored in the Support_AC_12_Allen.txt text file and is located in the Access3 > Case1 folder. Attach the document to the StudentAttachment field for record 2 (Cody Allen record) in the tblStudent table, resize the Student Attachment column to its best fit, and then save and close the table. 7. Add an AutoNumber field named PlanNum to the beginning of the tblCityPaymentPlan table, using a Caption property setting of Plan Num and a New Values property setting of Random. Specify the PlanNum field as the primary key. Resize the Plan Num column to its best fit in the datasheet, and then save and close the table. 8. Use the Performance Analyzer to analyze the entire Instruction database, but do not implement any of the analysis results. How many analysis results of the Recommendation type did the Performance Analyzer find? Of the Suggestion type? Of the Idea type? If requested, record the answers in a Word document, and submit it to your instructor. Close the Performance Analyzer dialog box

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Tips For The New Auditor

Authors: Marty Sturino

1st Edition

1733097813, 978-1733097819

More Books

Students also viewed these Accounting questions

Question

11. Identify the stage of beyond duality in Gone With the Wind.

Answered: 1 week ago