Office 2013 – MyITLab Grader Instructions Go! - Access Chart

Office 2013 – myitlab:grader – Instructions GO! - Access Chapter 3

Use a database to track publishers and book titles that assist students in finding employment. Create forms, add and delete records using a form, filter records, modify a form in Layout view and Design view, create reports, modify reports in Layout and Design views, group data in reports, and ensure grouped data stay together in printed reports.

Paper For Above instruction

The task involves developing a comprehensive Access database centered on publishers and career books aimed at assisting students with employment opportunities. The project's core objectives include designing and manipulating forms and reports to facilitate data management and presentation effectively. This academic exercise emphasizes practical skills in database management, including establishing relationships, creating and editing forms, applying filters, formatting reports, and ensuring data grouping for clear, professional printing.

First, the student is instructed to start Microsoft Access, open the provided database file, and enable content. The student must examine the relationships between the Publishers table and the Career Books table, specifically noting the one-to-many relationship since one publisher can publish many books. Once identified, the relationship window should be closed.

Next, the student must create a form based on the Career Books table using the Form tool, saving it as "Career Book Form" and switching to Form view. From this form, a new record should be added for a book titled "Effective Networking" with specific details, and an existing record with a particular Title ID ("T-19") should be located and deleted. The record for "T-25" must then be found, and the print column layout adjusted to a width of 7.5 inches via the Print dialog box, then the form saved.

The student should then filter the form records to display only those with categories "Interviewing Strategies" or "Resumes" using the Filter By Form tool. After verifying that ten records match, the filter should be toggled off, and the form saved and closed.

A second form must be created using the Form Wizard based on the Publishers table, selecting specific fields in order, applying a columnar layout, and naming it "Publisher Form." The form is then to be opened in Layout view, where the layout is changed to a stacked layout for all controls, themed with the "Integral" theme. The title font size should be increased to 16, bolded, and colored Dark Teal.

Using Layout view, additional modifications include adding the Publisher ID field above the Company Name, repositioning control alignments, altering widths, and applying background and font colors to specific controls, including changing font sizes and heights for consistency. In Design view, adjustments to the Form Footer height and adding a label in the footer that displays "Texas Lakes Southwest Campus" are required, with specific font color, bolding, and positioning.

Next, a new record must be added to the Publishers table, entering details for Publisher ID "PUB-111." A report based on the "Resume or Interview Books" query should be generated, applying the "Retrospect" theme, removing certain fields, adjusting control widths, sorting, and renaming the report title to "Resume or Interview Books Report." Layout view modifications include adding a record count control adjacent to the Title, altering font size, and repositioning controls for clarity.

Another report must be created via the Report Wizard based on the Career Books table, including specified fields, grouping by category, sorting by Title, and summarizing total value. After finishing, the report should be styled with the "Ion Boardroom" theme, with title formatting, control deletions, and control size adjustments to optimize presentation.

Design view adjustments focus on aligning total controls in the report’s footer, and setting groupings for the report to keep each category's records together across pages. This is verified in Print Preview. The report is then saved and closed, and all objects are then properly closed for submission.

References

• Allen, R. B., & Reid, D. S. (2013). Access 2013 Bible. Wiley.
• Gaskin, R. (2014). Microsoft Access 2013 Step by Step. Microsoft Press.
• O'Connell, H. (2014). Learn Microsoft Access 2013 Programming. Packt Publishing.
• Stanek, W. (2013). Microsoft Access 2013 Programming by Example. Packt Publishing.
• Libby, R. (2013). Mastering Microsoft Access 2013. Sybex.
• Groh, K. (2014). Microsoft Access 2013: Illustrated. Cengage Learning.
• Seaby, S., & Williams, M. (2014). Access 2013: The Missing Manual. O'Reilly Media.
• Cheshire, S. (2014). Building Microsoft Access Projects. Microsoft Press.
• Worsley, D. (2013). Microsoft Access 2013 Programming: For Beginners. Packt Publishing.
• Heard, A. (2014). The Practical SQL Guide. CRC Press.