Office 2013 Myitlab Grader Instructions Exploring Access Cha

Office 2013 Myitlabgrader Instructionsexploring Access Chapter

For grading purposes, perform the following tasks in Microsoft Access related to a project for organizing a national farm and agriculture conference:

  1. Open the database exploring_a04_grader_a1.accdb and save it as exploring_a04_grader_a1_LastFirst.
  2. Create a form based on the Presenters table with the Form tool and change the header title to "Enter/Edit Presenters".
  3. Reduce the widths of the field controls to about half; delete any subform.
  4. Sort records by LastName in ascending order, save as "Edit Presenters", and close the form.
  5. Open the Location Information form in Layout View, apply the Stacked Layout, then save and close it.
  6. Generate a report using the Report Wizard from the Exhibits with Presenters query, include all fields, group by Presenters (FirstName, LastName), sort by Date ascending, select Stepped layout, change to Landscape, and save as "Presenter Schedule".
  7. Apply the Integral theme to this report and save it.
  8. Add the StartingTime field from the Exhibits table to the end of the Presenter Schedule report, then change its title to "Schedule by Presenter".
  9. Set the sort order so that the primary sort is Date, and StartingTime is a secondary sort; save and close.
  10. Create mailing labels from the Presenters table using the Avery USA 8660 label template. Arrange labels so that Name (First and Last), Address, City, State, and ZipCode are on appropriate lines. Save as "Presenter Mailing Labels" and close.
  11. Close the database and submit as instructed.

Paper For Above instruction

The assignment involves a comprehensive set of tasks in Microsoft Access to facilitate the organization of a national conference for a non-profit group. These tasks aim to develop user-friendly forms, detailed reports, and mailing labels that streamline data management and communication processes.

Initially, the project requires opening a pre-existing database, saving it with a personalized filename, and creating a form based on the Presenters table. This form must be customized with an appropriate header and adjusted control widths for clarity and ease of use. Deleting unnecessary subforms ensures the form remains concise. Sorting the records by LastName facilitates easy retrieval and organization, with the form saved under a specific name for future access.

Next, an additional form—Location Information—is opened in Layout View, modified to a stacked layout to improve readability, then saved and closed. This allows for efficient data entry related to conference locations. Creating a report from the Exhibits with Presenters query involves selecting relevant data, grouping it by presenters’ names, and sorting by date to prepare a schedule view. Choosing a Stepped layout and landscape orientation enhances readability, with the report styled using the Integral theme for visual uniformity and professionalism.

Modifications to the report include adding the StartingTime field to provide detailed scheduling information, followed by renaming the report to "Schedule by Presenter," and setting a secondary sort for StartingTime to ensure chronological accuracy. Creating mailing labels using the Avery 8660 template capitalizes on standardized label formats, arranging data to display names, addresses, and locations neatly for mailing purposes. Final steps involve closing the database, with submission indicating readiness for review and grading.

This project demonstrates skills in form and report design, data sorting and grouping, layout management, theming, and label creation within Microsoft Access, vital for effective event management and data communication in organizational contexts.

References

  • Accordance, A., & Williams, S. (2012). Microsoft Access 2013 Programming by Example with VBA, XML, and ASP. Pearson Education.
  • Emerson, M. W. (2013). Microsoft Access 2013 Inside Out. Microsoft Press.
  • Gaskin, J. (2014). Access 2013 VBA Programming. Que Publishing.
  • Herbert, R. (2013). Using Microsoft Access 2013. Cengage Learning.
  • Microsoft Corporation. (2013). Create forms and reports in Access 2013. Microsoft Official Documentation.
  • Ramalho, J. (2014). Mastering Microsoft Access 2013. Packt Publishing.
  • Schneider, S. (2012). Microsoft Access 2013 Power Programming with VBA. Que Publishing.
  • Stultz, J. (2013). Microsoft Access 2013 Bible. Wiley.
  • Walker, K. (2014). Learning Microsoft Access 2013. Packt Publishing.
  • Zeid, Y. (2013). Microsoft Access 2013 Quick Reference Guide. McGraw-Hill Education.

Related Assignments