Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Access 2007: Forms and Reports

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Shows how to manage data entry and reporting tasks using Access 2007.

Discover how to manage data entry and reporting tasks more efficiently with Access 2007. Author Adam Wilbert presents lessons 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.

Syllabus

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 wizard
  • Refining the form in Layout view
2. Form Design Basics: Creating a Directory
  • Organizing the form elements
  • Formatting the form
  • 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. The User Experience
  • Printing reports
  • Tweaking the design
  • Automating the workflow with macros
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

Start your review of Access 2007: Forms and Reports

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.