Microsoft access Course overview

Part 1:
In this course, students will learn how to use Access to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Part 2:
In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Apply Today

Instructor Led Learning

Duration: 2 Days
Registration Open Now!

Video Learning

Duration: 2 Days
Registration Open Now!

What you will learn

Part 1 (Basic)

  • Lesson 1Getting Started with Access
  • Lesson 2Working with Table Data
  • Lesson 3 Querying a Database
  • Lesson 4Creating Advanced Queries & Using forms
  • Lesson 5 Generating Reports
  • Lesson 6 Customizing the Access Environment
  • Lesson 7 Designing a Relational Database

Part 2  (Intermediate)

  • Lesson 1 Designing a Relational Database
  • Lesson 2Joining Tables
  • Lesson 3 Organizing a Database for Efficiency
  • Lesson 4 Joining Tables
  • Lesson 5 Organizing a Database for Efficiency
  • Lesson 6 Sharing Data Across Applications

Part 3   (Advanced)

  • Lesson 1 Implementing Advanced Form Design
  • Lesson 2Using Data Validation
  • Lesson 3 Using Macros to Improve User Interface Design
  • Lesson 4 Using Advanced Database Management
  • Lesson 5 Distributing and Securing a Database
  • Lesson 6 Managing Switchboards

Basic computer skills

Computers made easy course

Introduction to Microsoft Office course

Microsoft Excel Level 1-3

FULL COURSE OUTLINE

Lesson 1: Getting Started with Access

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

Lesson 2: Working with Table Data

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

Lesson 3: Querying a Database

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

Lesson 4: Creating Advanced Queries & Using Forms

  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data
  • Create Basic 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

Lesson 6: Customizing the Access Environment

  • The Access Options Dialog Box

Lesson 7: Designing a Relational Database

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

Lesson 1: Designing a Relational Database

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

Lesson 2: Joining Tables

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Create Subqueries

Lesson 3: Organizing a Database for Efficiency

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

Lesson 4: Joining Tables

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheet
  • Create Subqueries

Lesson 5: Organizing a Database for Efficiency

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

Lesson 6: Sharing Data Across Applications

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Lesson 1: Implementing Advanced Form Design

  • Add Controls to Forms
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation of Forms
  • Apply Conditional Formatting
  • Set form controls

Lesson 2: Using Data Validation

  • Field and Record Validation
  • Form Validation

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
  • Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyse the Performance of a Database

Lesson 5: Distributing and Securing a Database

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

Lesson 6: Managing Switchboards

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

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.