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

LinkedIn Learning

Access 2007 Essential Training

via LinkedIn Learning


Covers each aspect of using Access 2007 to create and modify databases for custom business purposes.

From using predefined Access 2007 database applications to building them from scratch, Access 2007 Essential Training covers each step of understanding, creating, and modifying databases for custom business purposes. Instructor David Rivers shows even the most database-challenged how to utilize this powerful software for creating reports and charts, as well as for business record keeping and analysis. Exercise files accompany the tutorials.


  • Welcome
1. Getting Started with Access
  • Database concepts and terminology
  • Starting Access
  • The Getting Started window
  • The Quick Access toolbar
  • Opening an existing Access database
  • The work environment
  • Customizing the Access environment
2. Creating Databases and Tables
  • Planning and designing databases
  • Working with fields
  • Choosing keys
  • Creating tables
  • Creating fields
  • Working with records
  • Working with data
  • Checking spelling
3. Working with Fields and Records
  • Modifying table design
  • Finding and editing records
  • Organizing and sorting records
4. Creating Data Entry Rules
  • Setting field properties
  • Using input masks
  • Setting validation rules
5. Relational Database Techniques
  • Creating key fields
  • Creating table relationships
  • Enforcing referential integrity
  • Using subdatasheets
6. Working with Queries
  • Creating a query using the wizard
  • Creating a query from scratch
  • Modifying a query in Design view
  • Performing calculations on a group of records
  • Creating flexible queries
7. Working with Forms
  • Introduction to forms
  • Creating forms with the Form wizard
  • Creating forms from the Design view
  • Modifying a form's design
  • Creating subforms
  • Adding command buttons to a form
  • Sorting and filtering with forms
  • Switchboards vs. the Navigation pane
8. Working with Reports
  • Using the Report wizard
  • Modifying reports in Design view
  • Adding custom calculated fields to a report
  • Formatting reports
  • Summarizing report information
  • Creating a mailing label report
  • Printing reports
9. Working with Macros
  • Creating macros
  • Attaching macros
  • Automating data entry with macros
  • Validating data with macros
  • Creating auto-executing macros
10. Sharing Data with Word and Excel
  • Importing data into Access
  • Using Package and Sign
  • Sharing via email
  • Exporting data to Excel
11. Working with Charts
  • Working with charts
  • Working with pivot charts

Taught by

David Rivers


Start your review of Access 2007 Essential Training

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.