Microsoft Access: 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

• Collecting and displaying 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 Red30 Tech database
• Create a form with the form wizard
• Create a form with subforms
• Refine the form design in layout view

2. Form Design Basics: Creating an Employee Directory

• Organize the form design
• Format objects and the Format Painter tool
• Anchor controls
• Modify form properties
• Combine text boxes
• Add a form header

3. Form and Report Controls

• Label control
• Lines and rectangles
• Organize screen space with tabs
• Button controls
• Linking to external content
• Add data with a text box
• Select data with a combo box
• Edit the display of a combo box
• Control input with option groups
• Add images to a form
• Edit the tab stop sequence
• Embed a subform control
• Display a chart

4. Getting Around the Database

• Create a main menu
• Refine button macros
• Create a data entry form

5. Report Layout

• Organize records with group and sort
• Understand report structure
• Add a section header to the report
• Build a report with the wizard
• Edit the report's data source
• Build a report from a query
• Format the report in design view
• Apply conditional formatting rules
• Create calculation fields
• Add a report header

6. Linking Forms and Reports: Creating a Profit Summary

• Build the query
• Create the report structure
• Style the report for legibility
• Design the form controls
• Connect the query
• Add line numbers to the report
• Launch Main Menu form at startup

Conclusion

• Next steps