Access 2007 training videos

Collect, organize and start putting your data to work with Access 2007. Microsoft training expert Jason Pearson breaks it down with easy-to-follow videos that demonstrate how to build a relational database. Learn the latest tools for designing tables, powerful queries, easy-to-navigate forms and stylish reports. Sample database files included.

Access 2007 training videos
  • 32 Access 2007 training videos
  • Review format and licensing Options
  • Ideal for SharePoint, Intranet or LMS deployment
  • Included with "Office 2007 Beyond the Basics Professional"
Title Description Duration
Getting Started
Concepts and Terminology Overview of Access 2007 concepts and database terminology 5:32
Create and Open a Database Creating, opening and managing compatibility with Access databases 3:33
Access 2007 Interface Get up to speed on the updated Access 2007 Ribbon interface 3:16
Planning the Database The importance of organzing and planning your database 5:13
Working with Tables
Creating Tables Options for creating tables, using templates and the Table Design tool 3:17
Understanding Data Types Review of the Access data types including the new Attachment type 3:03
Looking at Field Sizes Limit field sizes to optimize the size of your database 2:34
Using Identifier Keys Learn why every table needs a primary key or unique identifier 2:46
Looking at Fields
Setting Field Properties Manage formatting, default values, and captions with field properties 3:46
Adding Validation Rules Restrict the type of information that can be entered with error alerts 2:45
Applying Input Masks Control how phone numbers and other data is entered with Input Masks 3:32
Creating Drop-Down Lists Create time-saving drop down lists for fast and consistent data input 5:12
Relational Database Techniques
Understanding Relationships A comprehensive look at how Access uses relationships to connect tables 3:21
Enforcing Referential Integrity A look at referential relationships - what they are and how they're enforced 3:01
Understanding Queries
Using the Query Wizard Create a query fast using the options in the Query Wizard 4:31
Customizing the Query Create and customize queries with the Query Design tool 4:18
Performing Expressions How expressions can calculate, concatenate, or add formulas to a query 4:45
Using Parameters Build a query that automatically changes based on user input 3:57
Using Update Queries How to create a query that updates records based on your criteria 3:29
Append and Delete Queries Build queries to instantly append or delete records in the database 4:11
Forms and Reports
Options for Fast Form Creation Create and customize forms with Form Wizard, AutoForm and Layout View 4:11
Customizing the Form Customize a form using both the Design View and Layout View 3:54
Adding Tab Control & Subforms Make a form easier to use by adding a Tab Control and Subform 4:48
Using the Report Wizard Look at the options to make report creation faster and easier 3:41
Adding Totals to a Report A step-by-step guide to adding and formatting totals on a report 4:37
Working with External Data
Importing Data into Access Steps to importing data into Access from other sources including Excel 2007 2:31
Collecting Data via Outlook The fastest way to collect data using an HTML form sent via Outlook 3:33
Integrating with SharePoint Learn how to create and synchronize SharePoint lists with Access tables 3:43
Automating with Macros
Creating Button Macros Automate tasks with button macros using the Command Button Wizard 3:25
Applying Conditional Macros Create macros that are activated based on specific conditions 3:36
Using Data Validation Control what is entered into a form by adding data validation to a macro 3:01
Auto-Execute Macros Create a macro to automatically execute any number of other macros 4:16