Access 2010: Forms and Reports

Shows how to manage data entry and reporting tasks using Access 2010.

Discover how to manage data entry and reporting tasks more efficiently using Access 2010. Author Adam Wilbert presents lessons on designing forms, organizing and displaying data with form controls, creating flexible queries, and building a form-based navigation system. The course also shows how to build reports from wizards and queries, highlight important data with conditional formatting, and automate reporting processes with macros.

Introduction

• Welcome
• Using the exercise files

1. Introduction to Forms

• Introducing forms
• Designing for the end user
• Exploring the database
• Creating a form with the Form Wizard
• Refining the form in Layout view

2. Form-Design Basics: Creating a Directory

• Organizing the form elements
• Formatting
• Modifying the form through its properties
• Adding a header and some polish

3. Form and Report Controls

• Introducing form controls
• Using lines and rectangles
• Organizing screen space with tabs
• Adding buttons
• Linking to external content
• Entering and selecting data
• Controlling input with option groups
• Attaching documents
• Attaching images
• Understanding the subform control
• Adding charts
• Linking controls

4. Getting around the Database

• Creating the main menu
• Adding a splash screen with startup options
• Creating a customer form

5. Report Layout

• Grouping and sorting data
• Understanding report structure
• Building reports from wizards
• Building reports from queries
• Formatting conditionally
• Calculating fields
• Adding the finishing touches
• Populating pre-printed documents

6. Printing, Tweaking, and Automating

• Printing reports
• Tweaking the design
• Automating the workflow with macros

Conclusion

• Next steps