Access Intermediate Training

Overview

Rating:
Duration:
( - Eastern)
Cost:
$285.00
Access Intermediate Logo

This course builds on the skills and concepts taught in the Introduction course. Students will learn relational database concepts and techniques, advanced queries, advanced form and report building, and how to create charts. This course will help students prepare for the Microsoft Office Specialist exam. For comprehensive certification training, students should complete the Introduction, Intermediate, and Advanced courses for Access.

If you need customized content or another version of this course please contact us.

Live Online Schedule

  • Oct 18
  • Nov 11
  • Dec 13

Prerequisites

Microsoft Access Introduction or equivalent knowledge.

Requirements

You will need the following software/setup for this class:

Microsoft Office 2013 or higher (2013, 2016, 2019, or Office 365)

Topics

Access Intermediate (2013, 2016, 2019, Office 365)

  • Modifying Tables
    • Inserting a Column in a Table
    • Changing a Column Name
    • Deleting a Column
    • Inserting a Lookup Column
    • Inserting a Hyperlink Column
    • Creating a Many-to-Many Relationship
  • Using Operators in Queries
    • Using Comparison Operators
    • Using the And Condition
    • Using the Or Condition
    • Using the Between And Operator
    • Using a Wildcard Character
  • Designing Advanced Queries
    • Setting Top Values in a Query
    • Creating a Calculated Field
    • Creating a Function Query
    • Creating a Parameter Query
    • Creating a Concatenation in a Query
    • Using Multiple Tables in a Query
    • Filtering a Query
  • Creating Action Queries
    • Creating a Make-Table Query
    • Creating an Update Query
    • Creating an Append Query
    • Creating a Delete Query
  • Using Advanced Query Wizards
    • Using the Crosstab Query Wizard
    • Using the Find Duplicates Query Wizard
    • Using the Find Unmatched Query Wizard
  • Using Advanced Database Features
    • Printing a Relationship Document
    • Linking Data to an Access Table
    • Importing Data
    • Setting a Database Password
    • Compacting a Database
    • Backing up a Database
  • Manipulating Controls
    • Using Controls
    • Selecting Non-Adjacent Controls
    • Deleting Controls
    • Sizing a Control by Dragging
    • Selecting Adjacent Controls
    • Moving Selected Controls
    • Sizing Controls Automatically
  • Using Design View
    • Hiding the Ruler
    • Disabling the Snap to Grid Feature
    • Displaying the Field List
    • Adding a Field
    • Moving Part of a Paired Control
    • Spacing Controls
    • Aligning Controls
    • Using the Toolbox
    • Adding Text
    • Adding an Image
    • Adding a Rectangle
    • Adding a Line
    • Editing an Unbound Control
  • Using Advanced Form Design
    • Using Forms in Design View
    • Creating a Combo Box
    • Creating a List Box
    • Creating an Option Group
    • Setting the Tab Order Automatically
    • Setting the Tab Order Manually
    • Adding a Form Header and Footer
    • Creating a Blank Form
  • Using Advanced Report Design
    • Using Reports in Design View
    • Creating a Calculated Control
    • Grouping Data in a Report
    • Creating a Header for Each Group
    • Creating a Running Summary
    • Inserting a Date/Time Control
    • Inserting a Page Break
    • Changing the Report Margins
    • Using the Label Wizard
    • Creating a Blank Report
  • Using Editing Tools
    • Selecting a Font Name
    • Selecting a Font Size
    • Selecting a Font Style
    • Using the Format Painter
    • Selecting Objects with the Toolbar
    • Using AutoFormat
    • Running the Spell Checker
    • Setting AutoCorrect Options
    • Adding AutoCorrect Entries
    • Deleting AutoCorrect Entries