Question Details

(Solved) Office 2016 - myitlab:grader - Instructions Exploring - Access Chapter 4: Homework Project 1 EX16_AC_CH04_GRADER_CAP_HW - National Conference Project...


Looking For Some Help With This Assignment.

EX16_AC_CH04_GRADER_CAP_HW - National 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 form with a stacked layout.

12

3

Change the title in the form header to Enter/Edit Speakers. Reduce the width of the text box controls to approximately half of their original size.

5

4

Delete the Sessions subform control from the form. 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.

8

5

Open the Room Information form in Layout view. Select all controls in the form, and apply the Stacked Layout. Switch to Form view, and then save and close the form.

9

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 proceed through the wizard steps:

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

Accept the Stepped and Portrait options. Save the report as Speaker Schedule.

20

7

Switch to Layout view and apply the Organic theme to this report only. Save and close the report.

6

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.

10

9

Click the Speaker and Room Schedule query. Activate 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 and FirstName fields as the grouping levels. Use Date as the primary sort field, in ascending order. Use StartingTime as the secondary sort field in ascending order.

Accept the Stepped and Portrait options. Name the report Speaker Schedule Revised.

20

10

Switch to Layout view, and apply the Facet theme to this report only.

6

11

Adjust the widths of the columns and other controls so that all the data is visible and fits across the page. Switch to Report view to ensure that the adjustments were appropriate. Return to Layout view, and make any required changes. Add spaces to the column heading labels so that all values display as two words where appropriate. For example, change RoomID to Room ID, etc. Save and close the report.

4

12

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

0

Total Points

100

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $18

Solution~000200218358.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now