Lynda.com Access 2010 Essential Training

Author: Alicia Katz Pollock
Duration (hr:min): 03:30
Released on: 6/10/2010
Exercise files: Yes
Software works on: Windows only

In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.

Topics include:

• Understanding database concepts and terminology
• Building tables with Application Parts
• Defining field properties
• Creating relationships between fields and tables
• Sorting and filtering
• Creating forms with the Form Wizard
• Analyzing data with the Query Designer
• Automating with macros
• Formatting reports with Layout Tools'

Content:

Introduction - 01:25

    Welcome - 0:51 - 5.9 MB
    Using the exercise files - 0:34 - 0.5 MB

1. Access Basics - 19:08

    Database concepts and terminology - 5:35 - 5.1 MB
    Starting Access - 0:55 - 1.0 MB
    Creating a new file - 1:10 - 1.1 MB
    Trusting a file - 0:56 - 0.9 MB
    The Quick Access toolbar - 1:08 - 1.3 MB
    Backstage view - 2:45 - 3.1 MB
    Exploring ribbons - 2:59 - 3.8 MB
    Using the Navigation pane - 2:11 - 2.6 MB
    Getting help - 1:29 - 2.4 MB

2. Creating a First Database and Using the Tools - 23:33

    Planning and designing your database - 1:33 - 1.6 MB
    Creating tables using Application Parts - 6:48 - 6.8 MB
    Creating tables in Layout view with Quick Start - 3:59 - 4.0 MB
    Creating and editing tables in Design view - 2:41 - 2.8 MB
    Setting a primary key - 1:20 - 1.5 MB
    Creating a lookup field - 3:59 - 4.3 MB
    Creating multi-value fields - 2:19 - 2.6 MB
    Using calculated fields - 0:54 - 1.0 MB

3. Setting Up the Data - 13:08

    Setting field properties - 7:34 - 8.0 MB
    Setting input masks - 2:03 - 2.3 MB
    Setting validation rules - 3:31 - 3.6 MB

4. Building Structure - 05:32

    Creating relationships and enforcing referential integrity - 4:44 - 4.8 MB
    Viewing subdatasheets - 0:48 - 1.2 MB

5. Formatting and Appearance - 19:52

    Entering data into your tables - 9:44 - 9.5 MB
    Formatting tables - 4:02 - 6.1 MB
    Finding, sorting, and filtering records - 6:06 - 8.2 MB

6. Forms - 29:57

    Creating data-entry forms - 2:31 - 2.9 MB
    Using the Form Wizard - 1:38 - 1.7 MB
    Modifying a form in Layout view - 7:01 - 8.8 MB
    Using Design view - 12:41 - 18.2 MB
    Setting tab stops - 1:26 - 2.1 MB
    Adding buttons to a form - 1:49 - 2.4 MB
    Using navigation forms - 2:51 - 4.3 MB

7. Queries - 26:49

    Introduction to queries - 1:09 - 1.4 MB
    Using the Query Wizard - 1:52 - 2.4 MB
    Creating a query in Design view with criteria - 4:18 - 4.6 MB
    Creating wildcard queries - 1:24 - 1.5 MB
    Creating reusable parameter queries - 1:29 - 1.7 MB
    Creating yes/no queries - 1:12 - 1.6 MB
    Creating "and" and "or" queries - 3:07 - 3.3 MB
    Building calculation queries - 2:44 - 3.0 MB
    Creating statistical queries - 3:01 - 3.2 MB
    Using update queries - 2:56 - 3.3 MB
    Using delete queries - 1:31 - 2.1 MB
    Creating crosstab queries - 2:06 - 2.4 MB

8. Reports - 26:43

    Introduction to reports - 1:28 - 2.2 MB
    Using the Report Wizard - 2:00 - 2.4 MB
    Formatting reports in Layout view - 5:16 - 7.0 MB
    Identifying report structure in Design view - 2:30 - 3.1 MB
    Adding group and sort capabilities to a report - 2:43 - 3.5 MB
    Adding existing fields from other tables - 1:59 - 2.6 MB
    Adding totals and subtotals to a report - 2:58 - 4.2 MB
    Adding conditional formatting and data bars to a report - 2:38 - 3.3 MB
    Creating multi-table reports - 1:46 - 1.9 MB
    Creating mailing labels - 2:16 - 2.8 MB
    Printing reports - 1:09 - 1.6 MB

9. Putting Data to Work - 04:32

    PivotTables - 2:29 - 2.9 MB
    PivotCharts - 2:03 - 2.5 MB

10. Automating with Macros - 07:35

    Creating macros - 2:53 - 3.2 MB
    Attaching macros to objects - 2:26 - 2.7 MB
    Using data macros - 2:16 - 2.6 MB

11. Using Other Applications with Access - 17:10

    Importing Excel and text data - 3:39 - 4.6 MB
    Exporting data into Excel - 1:00 - 1.6 MB
    Exporting to PDF - 0:53 - 1.2 MB
    Exporting into a Word Mail Merge - 1:03 - 1.1 MB
    Publishing to a web browser in HTML or XML - 1:51 - 3.1 MB
    Sharing via email - 0:58 - 1.1 MB
    Collecting data over email - 2:42 - 3.5 MB
    Using Package and Sign - 1:14 - 1.7 MB
    Publishing to SharePoint - 2:59 - 3.4 MB
    Importing and exporting with SharePoint - 0:51 - 0.9 MB

12. Advanced Tools in the Database - 06:41

    Compacting and repairing a database - 0:48 - 1.2 MB
    Using data analysis tools - 1:04 - 1.4 MB
    Encrypting a database and setting a password - 2:22 - 2.9 MB
    Splitting a database - 2:27 - 2.8 MB

13. Customization - 08:19

    Customizing the ribbons - 1:16 - 1.7 MB
    Setting Access options - 7:03 - 8.0 MB

Conclusion - 00:14

    Goodbye - 0:14 - 0.2 MB