COMPUTER + SOFTWARE TRAINING
[Databases]

Corporate and NYS discounts do not apply for this course.

This course is appropriate for individuals who will use Access regularly and require a more thorough understanding of the program. The four main topics: Tables, Forms, Queries, and Reports are covered in approximately 4 hours each, and can be registered for as individual courses.

The course provides similar content to that included in Access Intermediate Essentials with a more comprehensive overview of each topic, focusing on creating a database from start to finish.

Includes:
Four, laminated 8-page quick reference guides covering each of the main course topics
Access to participant data files
Follow-up support by email or phone for an unlimited period

Tables

Lesson 1: Database Design

• Database Design Recommendations
• Working with Table Relationships
• Creating a Database

Lesson 2: Creating Tables

• Design View vs. Datasheet View
• Using Primary Keys
• Assigning Data Types
• Creating Lookup Fields

Lesson 3: Creating Relationships

• Creating One-to-Many Relationships
• Querying Related Tables
• Using Junction Tables
• Implementing Referential Integrity
• Using Subdatasheets

Lesson 4: Ensuring Valid Data Entry

• Advanced Field Properties
• Using Input Masks
• Lookup Field Properties

Forms

Lesson 5: Creating Data Entry Forms

• Instant Forms
• Split Forms
• Multiple Items Forms
• Using the Form Wizard
• Blank Forms

Lesson 6: Form Enhancements

• Changing Fonts and Text Styles
• Using Conditional Formatting
• Formatting Numbers, Gridlines, and Other Special Elements
• Adding Fields from Related Tables

Lesson 7: Design View Elements

• Working with Controls and Control Properties
• Creating Calculated Fields
• Using Control Layouts

Lesson 8: Applying Advanced Controls

• Tab Controls
• Combo Boxes
• Subforms
• Option Groups

Queries

Lesson 9: Revisiting Table Relationships

• Using Relational Databases
• Understanding Join Types
• Understanding Referential Integrity

Lesson 10: Creating Select Queries

• Querying from Related Tables
• Finding Unmatched Records
• Using Criteria
• Using Subqueries

Lesson 11: Using Calculations in Queries

• Creating Calculated Fields
• Using the Expression Builder
• Adding Grouping and Totals
• Concatenating Fields

Lesson 12: Additional Query Topics

• Using PivotTable Queries
• Using Parameter Queries
• Displaying Top Values

Reports

Lesson 13: Using Layout View

• Creating Reports in Layout View
• Changing Fonts and Text Styles
• Using Conditional Formatting
• Formatting Reports
• Adding and Arranging Fields
• Reporting from Related Tables
• Adding Grouping, Subtotals, and Grand Totals

Lesson 14: Using Design View

• Creating Reports in Design View
• Creating Custom Headers/Footers
• Creating Calculations and Unbound Objects
• Arranging, Aligning, and Sizing Controls

Lesson 15: Adjusting Page Layout and Printing

• Page Setup And Margins
• Changing Custom Group Properties
• Printing Reports
• Exporting Reports to Word
• Creating Mailing Labels

Lesson 16: Using Queries for Effective Reports

• Using Queries as a Record Source
• Filtering Reports Using Parameter Values