National Residence Life Conference

National Residence Life Conference

Project Description:
Your boss asked you to prepare a schedule for each speaker for the national conference being hosted next year on your campus. She wants to mail the schedules to the speakers so that they can provide feedback on the schedule prior to its publication. You assure her that you can accomplish this task with Access.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step    Instructions    Points Possible
1    Start Access. Open the file named exploring_a04_grader_h1.accdb. Save the database as exploring_a04_grader_h1_LastFirst.    0
2    Select the Speakers table as the record source for a form. Use the Form tool to create a new stacked form.
Hint: With the table selected in the Navigation Pane, on the CREATE tab, in the Forms group, click Form.    15
3    Change the title to Enter/Edit Speakers. Reduce the width of the text box controls to approximately half of their original size.
Hint: To change the widths of the fields, drag the right edge of any field to the left.    5
4    Delete the Sessions subform. View the form and data in Form view. Sort the records by LastName in Ascending order. Save the form as Edit Speakers. Close the form.
Hint: To sort the records, right-click the LastName field, and then click Sort A to Z.    5
5    Open the Room Information form in Layout view. The form does not have a Form Layout. Select all controls and apply the Stacked Layout. Save and close the form.
Hint: On the ARRANGE tab, in the Table group, click Stacked.    10
6    Select the Speaker and Room Schedule query as the record source for a report. Activate the Report Wizard and use the following options as you go through the Wizard.

Select all of the available fields for the report. View the data by Speakers. Verify that LastName and FirstName will provide grouping levels. Use Date as the primary sort field, in Ascending order.

Accept the Stepped and Portrait options. Save the report as Speaker Schedule.
Hint: With the query selected, on the CREATE tab, in the Reports group, click Report Wizard.    20
7    Switch to Layout view and apply the Organic theme to only this report. Save and close the report.
Hint: On the DESIGN tab, in the Themes group, click Themes, right-click Organic, and then click Apply Theme to This Object Only.    5
8    Open the Speaker and Room Schedule query in Design view. Add the StartingTime field in the Sessions table to the design grid, after the Date field. Run the query. Save and close the query.
Hint: To add the specified field, drag the field to the query design grid, and then release the mouse button.    10
9    Click the Speaker and Room Schedule query. Start the Report Wizard again and use the following options. Select all of the available fields for the report. View the data by Speakers.

Use the LastName, FirstName fields as the primary grouping level. Use Date as the primary sort field, in Ascending order. Use StartingTime as the secondary sort field in Ascending order.

Select the Stepped and Landscape options. Name the report Speaker Schedule Revised.
Hint: With the query selected, on the CREATE tab, in the Reports group, click Report Wizard.    20
10    Switch to Layout view, and then apply the Facet theme to only this report.
Hint: On the DESIGN tab, in the Themes group, click Themes, right-click Facet, and then click Apply Theme to This Object Only.    5
11    Add a space to the column heading labels as needed. For example, change RoomID to Room ID. Save and close the report.    5
12    Close the database, and submit based on your instructor’s directions.    0
Total Points    100