Learn to organize, analyze, and present data like never before with Access 2010. Jason Pearson demonstrates how with step-by-step training videos that cut right to the task. Discover the latest features for building tables, queries, easy-to-navigate forms and reports with emphasis on concepts, planning and best practices. Sample database files included.
- 40 Access 2010 training videos
- Review format and licensing Options
- Ideal for SharePoint, Intranet or LMS deployment
- Included with "Office 2010 Beyond the Basics Professional"
| Title | Description | Duration |
| Getting Started | ||
| What's New in Access 2010 | Overview of the changes and new features found in Access 2010 | 2:40 |
| Backstage View and Interface | Open up the Backstage view to find common file management functions | 3:09 |
| The Improved Ribbon | Review the Ribbon's options and customize it to display your favorites | 4:15 |
| Creating a New Database | Learn more about Access format options and compatibility issues | 3:25 |
| Concepts and Terminology | Brush up on database tables, queries, forms, reports, modules and more | 5:34 |
| Working with Tables | ||
| Planning the Database | Review this essential information before creating your first database | 5:20 |
| Creating a New Table | Take advantage of available options to easily create and customize tables | 3:36 |
| Introducing Application Parts | Learn how this new feature can be used to quickly build a database | 3:16 |
| Using Quick Start Fields | Automate repetitive table design with new, pre-designed Quick Start fields | 2:25 |
| Adding Calculated Fields | Add simple calculations at the table level with new Calculated Fields | 2:21 |
| Identifier Keys | Learn the importance of primary, foreign and composite keys | 3:23 |
| Understanding Fields | ||
| Examining Data Types | Get familiar with the various data types including text, number and hyperlink | 2:58 |
| Working with Field Sizes | Limit and optimize field sizes to reduce the overall size of your database | 2:52 |
| Setting Field Properties | Manage formatting, default values, and captions with field properties | 4:07 |
| Adding Validation Rules | Restrict the type of information that can be entered with error alerts | 3:05 |
| Building Input Masks | Control how phone numbers and other data is entered with Input Masks | 3:14 |
| Making Drop-Down Lists | Create time-saving drop-down lists for fast and consistent data input | 3:23 |
| Relational Database Techniques | ||
| Understanding Relationships | A comprehensive look at how Access uses relationships to connect tables | 3:24 |
| Enforcing Referential Integrity | All about referential relationships - what they are and how they work | 2:59 |
| Using Queries | ||
| The Query Wizard | Explore the Simple, Crosstab, Find Duplicates, & Find Unmatched wizards | 4:10 |
| Customizing in Design View | Design and save queries to display exactly the way you want | 4:25 |
| Performing Expressions | How expressions can calculate, concatenate, or add functions to a query | 5:01 |
| Using Parameters | Build a query that automatically changes based on user input | 4:19 |
| Applying Update Queries | Create a query that updates many records instantly based on your criteria | 3:26 |
| Append and Delete Queries | Build queries to instantly copy, add and remove records in the database | 4:08 |
| Designing Forms and Reports | ||
| Improved Form Layout | Check out form options in the Form Wizard and Autoform (Form) tools | 4:40 |
| Comparing Form Views | Review the advantages and differences of the Design and Layout Views | 4:06 |
| Tab Control and Subforms | Make a form easier to navigate by adding a Tab Control and Subform | 4:25 |
| Organizing Reports | Investigate options to generate reports faster and easier in Layout View | 4:13 |
| Adding Totals to a Report | A step-by-step guide to adding and formatting totals on a report | 4:16 |
| Working with Macros | ||
| Creating Button Macros | Use the Command Button Wizard to design macros for automating tasks | 3:24 |
| Auto Execute Macros | Create a macro to automatically execute any number of other macros | 4:25 |
| Conditional Macros | Customize macros that are activated based on specific conditions or criteria | 3:33 |
| Data Validation | Control what is entered into a form by adding data validation to a macro | 2:36 |
| Creating Navigation Forms | ||
| Introducing Navigation Forms | Easily switch between various forms and reports with this new feature | 2:46 |
| Adding Customization | Start from scratch to design a powerful and stylish navigation form | 3:44 |
| Control from the Start | Modify the database start page to limit the items available to others | 2:18 |
| Integrating with External Data | ||
| Importing Data into Access | Steps to importing data from other sources including Excel and SharePoint | 2:23 |
| Collecting thru Outlook | Explore the fastest way to collect data using an HTML form sent via Outlook | 3:08 |
| Using Access Services | Create and publish a web database to integrate with SharePoint lists | 2:38 |