by | Released October 2010 | ISBN: 9780132611237

For anyone who wants to master Microsoft Access 2010 fast—from novices to experienced power users!Microsoft Access 2010 LiveLessonsteaches the most sophisticated features and techniques visually: just watch! You'll master high-powered Microsoft Access 2010 skills at your own pace—and get specific answers and solutions immediately, whenever you need them!These practical videos simplify core Access features such as tables, queries, forms, reports, indexes, and macros… advanced features like one-to-many forms, calculated fields, and conditional formatting, and control properties… sorting and grouping… essential database administration, security, and integrity… data sharing on the Web and with other applications, and plenty more! Show and hide more

1. Introduction
   • Introduction 00:03:15
2. Section 1: Office Access 2010 Introduced
   • Learning Objectives 00:00:52
   • Starting Microsoft Access 00:01:00
   • Opening an Existing Database 00:00:50
   • The Access Desktop 00:02:27
   • The Navigation Pane 00:05:24
   • A Preview of the Database Components 00:07:44
   • Closing an Access Database 00:01:28
3. Section 2: Tables Introduced
   • Learning Objectives 00:00:28
   • Viewing and Navigating Table Data 00:04:01
   • Editing Table Data 00:02:23
   • Adding Records to a Table 00:01:57
   • Selecting and Deleting Records 00:01:41
   • Finding and Replacing Records 00:03:47
   • Filtering Table Data 00:01:58
4. Section 3: Queries Introduced
   • Learning Objectives 00:00:31
   • Opening a Query in Datasheet View 00:02:10
   • Opening a Query in Design View 00:02:42
   • Selecting Fields 00:03:33
   • Ordering the Query Result 00:03:21
   • Refining Queries with Criteria 00:03:42
   • Modifying the Datasheet View 00:02:28
   • Saving and Closing a Query 00:03:00
5. Section 4: Forms Introduced
   • Learning Objectives 00:00:27
   • Opening a Form 00:01:26
   • Working with Data in a Form 00:06:12
   • Sorting Form Data 00:01:43
   • Filtering the Data Underlying a Form 00:03:53
   • Viewing the Design of a Form 00:02:46
   • Using the AutoForm Feature 00:01:44
   • Using a Form Wizard 00:02:44
   • Taking Advantage of Conditional Formatting 00:03:49
6. Section 5: Reports Introduced
   • Learning Objectives 00:00:27
   • Opening and Viewing a Report 00:02:31
   • Printing Report Data 00:02:24
   • AutoReports and the Report Wizard 00:03:42
   • Viewing the Design of a Report 00:02:38
7. Section 6: Creating Your Own Databases and Tables
   • Learning Objectives 00:00:28
   • Creating a New Database 00:01:30
   • Building a New Table 00:05:39
   • Selecting the Appropriate Field Type 00:03:26
   • Creating Indexes 00:02:30
   • The All-Important Primary Key 00:02:28
8. Section 7: Creating Relationships
   • Learning Objectives 00:00:25
   • Introduction to Relational Database Design 00:06:10
   • Establishing Relationships in Access 00:03:08
   • Establishing Referential Integrity 00:04:50
9. Section 8: Creating Queries
   • Learning Objectives 00:00:38
   • Advanced Criteria Techniques 00:05:08
   • Updating Query Results 00:01:34
   • Building Queries Based on Multiple Tables 00:02:03
   • Creating Calculated Fields with the Expression Builder 00:03:59
   • Creating Parameter Queries 00:03:20
10. Section 9: Creating Forms
    • Learning Objectives 00:00:25
    • Working with Controls 00:08:07
    • Form Properties 00:05:53
    • Working with Combo Boxes 00:05:07
    • The Command Button Wizard: Programming without Typing 00:05:46
    • Creating One-To-Many Forms Using the Form Wizard 00:03:12
    • Creating One-To-Many Forms Using the SubForm Wizard 00:05:04
11. Section 10: Creating Reports
    • Learning Objectives 00:00:31
    • Working with Report Bands 00:01:15
    • Working with Controls 00:02:53
    • Basing Reports on Multiple Tables 00:06:32
    • Adding Sorting and Grouping 00:09:06
    • Working with Report Properties 00:03:04
    • Working with Subreports 00:03:48
    • Basing Reports on Stored Queries 00:04:04
12. Section 11: Creating Macros
    • Learning Objectives 00:00:31
    • The Basics of Creating a Macro 00:08:28
    • Running an Access Macro 00:06:09
    • Modifying an Existing Macro 00:02:56
    • Creating an Embedded Macro 00:03:00
    • Creating Data Macros 00:05:48
    • Creating a Drillthrough Macro 00:03:11
    • Debugging a Macro 00:02:46
    • Converting a Macro to VBA Code 00:03:27
    • Creating an AutoExec Macro 00:02:02
13. Section 12: Power Table Techniques
    • Learning Objectives 00:00:29
    • Working with Field Properties 00:06:28
    • Working with Table Properties 00:02:18
14. Section 13: Power Query Techniques
    • Learning Objectives 00:00:28
    • Creating and Running Action Queries 00:05:49
    • Using Aggregate Functions to Summarize Numeric Data 00:04:51
    • Working with Outer Joins and Self Joins 00:06:18
    • Refining Queries with Field, Field List, and Query Properties 00:05:01
15. Section 14: Power Form Techniques
    • Learning Objectives 00:00:27
    • Control Properties and Why to Use Them 00:05:20
    • Bound, Unbound, and Calculated Controls 00:03:42
16. Section 15: Power Report Techniques
    • Learning Objectives 00:00:30
    • Control Properties and Why to Use Them 00:03:54
    • Inserting Page Breaks 00:02:32
    • Bound, Unbound, and Calculated Controls 00:01:44
17. Section 16: Sharing Data With Other Applications
    • Learning Objectives 00:00:30
    • Exporting to Another Access Database 00:02:12
    • Exporting to an Excel Spreadsheet 00:03:09
    • Exporting to Text 00:04:14
    • Importing from Another Access Database 00:01:46
    • Importing Spreadsheet Data 00:03:13
    • Importing Text Data 00:03:34
    • Linking to Tables in Another Access Database 00:02:04
    • Linking to Another Type of Database 00:02:07
    • Linking to SQL Server Databases 00:04:20
    • The Linked Table Manager 00:02:28
18. Section 17: Access and the Internet
    • Learning Objectives 00:00:27
    • Creating Web Databases 00:02:16
    • Using Application Parts 00:03:14
    • Creating Publishable Objects 00:03:38
    • Publishing Your Database to Access Services 00:01:33
    • Saving Database Objects as HTML 00:02:41
    • Linking to HTML Files 00:02:53
    • Importing HTML Files 00:02:59
    • Exporting Data to XML 00:03:46
    • Importing XML Data into Access 00:02:05
19. Section 18: Database Administration
    • Learning Objectives 00:00:32
    • Compacting and Repairing a Database 00:01:08
    • Encrypting and Decrypting a Database 00:02:11
    • Converting a Database to Another Version 00:02:49
    • Creating an MDE File 00:04:06
    • Using the Database Splitter 00:02:55
Show and hide more