Total Training - Ms Access 2010 Essential Training
English | AVC 365 Kbps, 960x540, 30 fps | wmav2 48 Kbps | 787.83 MB
Genre: eLearning

Chapter 1: GETTING TO KNOW ACCESS 2010
1. Relational Database Overview
2. Access Components
3. Planning a Database
4. Creating Our Database Plan
5. Naming Conventions
6. Creating a Database File

Chapter 2: CREATING ACCESS TABLES
1. Leveraging Application Parts
2. Building a Table in Design View & Data Types Explained
3. Applying Field Properties
4. Relationship Concepts
5. Establishing Relationships
6. Creating Lookup Fields
7. Entering Table Records
8. Using the Ribbon to Edit Records
9. Managing Subdatasheets

Chapter 3: HARNESSING THE POWER OF QUERIES
1. Creating a Basic Query
2. Filtering with Criteria
3. Working with Expressions
4. Working with Totals
5. Concatenating Text
6. Changing Joins in Queries
7. Creating a Price List Query
8. Creating a Class Schedule Query Using Expression Builder
9. Creating Action Queries
10. Creating Special Select Queries with Wizards

Chapter 4: CREATING FUNCTIONAL FORMS & REPORTS
1. Creating Forms Automatically & with the Forms Wizard
2. Creating Reports with the Report Wizard
3. The Design of Forms & Reports
4. Working with Data in Forms
5. Filtering & Sorting Records in Forms
6. Customizing Report Controls & Page Setup
7. Credits