Access Bundle

Access Bundle

870.00
Date:
Delivery Method:
Module:
Quantity:
Purchase Now

GSA Checkout → GSA

Course ID: A1100a

Duration: 3 Days | 6 Modules (9:00 am - 4:00 pm PST)

Location: In-Person (San Francisco) or Live Online | Click here to schedule private course.

Overview:

In our Access training courses students will learn how to take control of your data with software training at Learn iT!. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learn iT! offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Microsoft Access courses at Learn iT! will teach you how to:

  • Create and design Access databases

  • Work with Access tables, relationships, keys and constraints

  • Query data

  • Manage and design interfaces with Access Forms

  • Create basic to advanced reports

  • Automate tasks with Macros and VBA

+ Who Should Attend

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access!

+ Course Outline

Module 1

Lesson 1: Getting Started with Access

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data

  • Modify Table Data
  • Sort and Filter Records

Lesson 3: Querying a Database

  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Module 2

Lesson 4: Using Forms

  • Create Basic Access Forms
  • Work with Data on Access Forms

Lesson 5: Generating Reports

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports
  •  

Module 3

Lesson 1: Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Lesson 2: Joining Tables

  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets

Lesson 3: Using Data Validation

  • Use Field Validation
  • Use Form and Record Validation

Module 4

Lesson 4: Creating Advanced Queries

  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries

Lesson 5: Organizing a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Lesson 6: Using Advanced Reporting Techniques

  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Module 5

Lesson 1: Implementing Advanced Form Design

  • Add Controls to Forms
  • Enhance Navigation and Organization of Forms
  • Apply Conditional Formatting

Lesson 2: Sharing Data Across Applications

  • Import Data into Access
  • Export Access Data
  • Link Tables to External Data Sources
  • Create a Mail Merge

Lesson 3: Using Macros to Improve User Interface Design

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro

Lesson 4: Using VBA

  • Getting Started with VBA
  • Enhance Access Using VBA

Module 6

Lesson 5: Using Advanced Database Management

  • Manage a Database
  • Determine Object Dependency
  • Document a Database

Lesson 6: Distributing and Securing a Database

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Lesson 7: Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

+ Prerequisites

There are no prerequisites for this course.

+ Certifications

N/A