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