Access 2019: Forms and Reports

Make the most of forms and reports in Access 365. Learn how to control the display of your data, create data entry points and menus for your users, and publish reports.

Introduction

• Collect and display data in Access
• Trust the exercise files

1. Making the Most of Forms in Access

• The benefit of well-designed forms
• Design for the end user
• Get to know the H+ Sport database
• Create a form with the Form Wizard
• Create a form with subforms
• Refine the form in Layout view

2. Form Design Basics: Creating an Employee Directory

• Organize the form elements
• Format objects and the Format Painter
• Object alignment
• Anchor controls
• Modify form properties
• Additional form properties
• Combine textboxes
• Add a form header

3. Form and Report Controls

• Label control
• Lines and rectangles
• Organize screen space with tabs
• Button controls
• Button properties
• Link to external content
• Add data with a text box
• Select data with a combo box
• Edit the display of a combo box
• Form controls for Yes/No data types
• Control input with option groups
• Place images into the form backgrounds
• Additional image properties
• Embed a subform control
• Prepare a query for charting
• Display a chart
• Link form controls
• Connect a query to a combo box
• Edit the Tab Stop sequence

4. Getting Around the Database

• Create a main menu
• Refine button macros
• Create a data entry form
• Finalize the customer form

5. Report Layout

• Organize records with group and sort
• Understand report structure
• Build a report with the Wizard
• Explore the report wizard output
• Build a report from a query
• Format the report in Design view
• Apply conditional formatting rules
• Advanced conditional formatting
• Create calculation fields
• Add a report header
• Segment dates into groups
• Format date header sections

6. Linking Forms and Reports: Creating a Profit Summary

• Build the query
• Create the report structure
• Add data to the report, part 1
• Add data to the report, part 2
• Connect the form
• Connect the query
• Add line numbers to the report
• Launch Main Menu form at startup

Conclusion

• Next steps