Mastering Access Made Easy DELUXE Self-Study Training Course

Product Details:

Product Name: Mastering Access Made Easy
Manufacturer: TeachUcomp, Inc.
Versions Covered: 2016 & 2013
Course Length: 6 Hours
Video Lessons: 105
Instruction Manuals: 3 (PDF)
Practice Exam: Included
FinalExam: Included
Certificate of Completion: Included
Quick Reference Guide: 2 Pages, Laminated, 25 Topics
Product Type: DELUXE

Learn Microsoft Access with this Deluxe training package from TeachUcomp, Inc. 

Mastering Access Made Easy Deluxe features 105 video lessons with over 6 hours of introductory through advanced instruction on both DVD-ROM to play on your PC or Mac and via online for one year (with enclosed Online Key Code) to view the course on your computer or mobile device. In addition, you’ll get our Access 2016 Quick Reference Guide- a two-page printed, laminated guide with step-by-step instructions in the most critical functions. Pop in the DVD-ROM or launch the online version to watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals in PDF (Introductory, Intermediate, and Advanced), additional images and practice exercises.

This package also includes an optional practice exam with evaluative feedback, an optional final exam and a Certificate of Completion when you pass the final exam. Test your knowledge after completing the course and demonstrate your proficiency.  

Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Note: A copy of the software is not included with this purchase. This is a tutorial only.

Topics Covered:

Getting Acquainted with Access

1. Creating a New Database

2. Overview of a Database

3. The Access Interface

4. Touch Mode

5. Viewing Database Objects in the Navigation Pane

6. Opening and Closing Databases

Creating Relational Database Tables

1. The "Flat File" Method of Data Storage

2. The Relational Model of Data Storage

3. Tips for Creating a Relational Database

4. Creating Relational Database Tables

5. Assigning a Primary Key to a Table

Using Tables

1. Using Datasheet View

2. Navigating in Datasheet View

3. Adding Records in Database View

4. Editing and Deleting Records in Datasheet View

5. Inserting New Fields

6. Renaming Fields

7. Deleting Fields

Field Properties

1. Setting Field Properties

2. The 'Field Size' Property

3. The 'Format' Property for Date/Time Fields

4. The 'Format' Property for Logical Fields

5. Setting Default Values for Fields

6. Setting Input Masks

7. Setting Up Validation Rules and Responses

8. Requiring Field Input

9. Allowing Zero Length Entries

Joining Tables in a Database

1. The Relationships Window

2. Enforcing Referential Integrity

3. Creating Lookup Fields

Indexing Tables

1. Indexes

2. Creating Indexes

3. Deleting Indexes

Queries

1. Using the Simple Query Wizard

2. Designing Queries

3. Joining Tables in a Query

4. Adding Criteria to the QBE Grid

5. Running A Query

6. How is Using the QBE Grid Writing SQL Code?

7. Sorting Query Results

8. Hiding Fields in a Query

9. Using Comparison Operators

10. Using 'AND' and 'OR' Conditions

Advanced Queries

1. Using the 'BETWEEN...AND' Condition

2. Using Wildcard Characters in Criteria

3. Creating a Calculated Field

4. Creating 'Top Value' Queries

5. Function Queries

6. Parameter Queries

Advanced Query Types

1. Make-Table Queries

2. Update Queries

3. Append Queries

4. Delete Queries

5. Crosstab Queries

6. The 'Find Duplicates' Query

7. The 'Find Unmatched' Query

Creating Forms

1. Forms Overview

2. The Form Wizard

3. Creating AutoForms

4. Using Forms

5. Form and Report Layout View

6. Form and Report Design View

7. Viewing the Ruler and Gridlines

8. The 'Snap to Grid' Feature

9. Creating a Form in Design View

10. Modifying Form Sections in Design View

Form & Report Controls

1. Selecting Controls

2. Deleting Controls

3. Moving and Resizing Controls

4. Sizing Controls 'To Fit'

5. 'Nudging' Controls

6. Aligning, Spacing and Sizing Controls

7. Formatting Controls

8. Viewing Control Properties

Using Controls

1. The Controls Group

2. Adding Label Controls

3. Adding Logos and Image Controls

4. Adding Line and Rectangle Controls

5. Adding Combo Box Controls

6. Adding List Box Controls

7. Setting Tab Order

Subforms

1. Creating Subforms

2. Using the Subform/Subreport Control

Reports

1. Using the Report Wizard

2. Using Basic Reports

3. Creating a Report in Design View

4. Sorting and Grouping Data in Reports

5. Creating Calculated Fields

Subreports

1. Creating Subreports

Charting Data

1. Using Charts

Macros

1. Creating a Standalone Macro

2. Assigning Macros to a Command Button

3. Using Program Flow with Macros

4. Creating Autoexec Macros

5. Creating Data Macros

6. Editing Named Data Macros

7. Renaming and Deleting Named Data Macros

Switchboard and Navigation Forms

1. Creating a Switchboard Form

2. Creating a Navigation Form

3. Controlling Startup Behavior

Advanced Features

1. Getting External Data

2. Exporting Data

3. Setting a Database Password

Helping Yourself

1. Using Access Help

2. The Tell Me Bar- 2016 Only

Minimum System Requirements:

1 GHz Intel Pentium Processor or equivalent

Windows or MAC

1 GB RAM

256 color SVGA capable of 1024x768 resolution

Speakers or headphones

DVD-ROM Drive