Access 2019: Forms and 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