| 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 |
