Microsoft Access Course Overview

Part 1: Microsoft Office Access Essentials
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: Microsoft Office Access Advanced
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: 3 Days
Registration Open Now!

Video Learning

Duration: 3 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

In this course, you will examine the basic database concepts, and create and modify databases and their various object using the Microsoft Office Access relational database application.
This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities and to understand the advantages that using a relational database application can bring to their business processes.


COURSE OUTLINE

LESSON 1: The Basics

  • Getting Started
  • Signing In
  • Creating a Database
  • Database Terminology
  • Saving a Database
  • Opening a Database

LESSON 2:Your First Database

  •  About Security
  • Warnings
  • About Relationships
  • Searching for Objects
  • Opening Database Objects
  • Changing the Object View
  • Understanding the Types of Views Available

LESSON 3: Working with Tables and Records

  • Creating a Table
  • Understanding Table Views
  • Adding and Editing Records
  • Searching and Browsing Records
  • Deleting Records
  • Printing Records

LESSON 4: Formatting Tables

  • Selecting Data
  • Changing Column and Row Width and Height
  • Applying Text Formatting
  • Applying Gridlines
  • Changing Fill Colors
  • Checking Your Spelling

LESSON 5: Creating Forms

  • Creating a Form from an Object
  • Creating a Form with the Wizard
  • Creating a Form from Scratch
  • Understanding Form Views
  • Using a Form

LESSON 6: Formatting Forms

  • Understanding Bound and Unbound Controls
  • Changing the Theme
  • Using the Format Painter
  • Adding Fields
  • Adding Controls
  • Adding Images and Logos
  • Review Questions

LESSON 7: Creating Reports

  •  Creating a Report from an Object
  • Creating a Report with the Wizard
  • Creating a Report from Scratch
  • Understanding Report Views
  • Printing Reports

LESSON 8: Formatting Reports

  • Changing the Theme
  • Using the Format Painter
  • Grouping and Sorting Data
  • Adding Controls
  • Adding Images and Logos
  • Adding Page Numbers, Headers, and Footers

LESSON 9: Creating Basic Queries

  • Types of Queries
  • Creating a Query with the Wizard
  • Running a Query
  • Understanding Query Views
  • Sorting and Filtering a Query

LESSON 10: Creating Advanced Queries

  •  Creating and Using Parameter Queries
  • Creating and Using Crosstab Queries
  • Creating and Using Make-Table Queries
  • Creating and Using Multiple Table Queries
  •  Creating and Using Append Queries
  • Creating and Using Delete Queries
  • Creating and Using Update Queries

LESSON 11: Managing Your Database

  • Compacting and Repairing a Database
  • Encrypting a Database with a Password
  • Backing Up Your Database
  • Exporting a Database and Database Objects
  • Printing Database Objects

LESSON 12. Customizing the Interface

  • Collapsing and Pinning the Ribbon
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database.
This course is for individuals whose job responsibilities include working with related tables, creating advanced queries, forms and reports, writing macros to automate common tasks and performing general database maintenance.


COURSE OUTLINE

LESSON 1: SQL and Microsoft Access

  • Importing Information
  • Exporting Information
  • Copying o and from Other Office Programs

LESSON 2: Using the SELECT Statement

  • Selecting All Data
  •  Selecting Specific Data
  •  Selecting Conditional Data
  •  Using the ORDER BY Statement

LESSON 3: Using SQL Joins

  • Creating Simple Joins
  •  Using an Alias
  •  Sorting Joins
  •  Creating Outer Joins

LESSON 4: Using Subqueries

  • What is a Subquery?
  •  Creating a Subquery
  •  Subqueries with Aggregate Functions and Nested Subqueries
  •  Using the IN Keyword with Subqueries

LESSON 5: Advanced Form Tasks, Part One

  • Limiting User Access to a Form
  •  Creating Checkboxes and Command Buttons
  •  Building Command Button Events
  •  Creating Event Procedures

LESSON 6: Advanced Form Tasks, Part Two

  • Using Hyperlinks in a Form
  • Adding Links to Other Database Objects
  • Inserting a Mailto Link in a Form
  • Adding a Browser Control to a Form
  • Performing Calculations in a Form

LESSON 7: Advanced Form Tasks, Part Three

  • Exporting Your Form to XML
  • Exporting a Form as a Word Document
  • Exporting a Form as HTML
  • Sending a Form as an E-mail Attachment
  • Exporting a Form to Other Formats

LESSON 8: Creating Split Forms

  • Creating a Split Form
  • Splitting an Existing Form
  • Using a Split Form
  • Fixing the Form Separator

LESSON 9: Using Digital Signatures

  • What is a Digital Signature?
  • Obtaining a Digital Signature
  • Attaching Your Signature to a Database
  • Extract and Use a Signed Database

LESSON 10: Using the Trust Center

  • Opening the Trust Center
  • Trusting a Database
  • Configuring Macro Security
  • Customizing the Message Bar

LESSON 11: Managing COM Add-ins

  • Viewing Add-ins
  • Opening the Add-in Manager
  • Installing Add-ins
  • Disabling All Add-ins
  • Uninstalling Add-ins

LESSON 12: Customizing Access

  • Changing User Information
  • Changing the Office Background and Theme
  • Setting the Default Database Type and Location

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

Become Part of MasterGrade IT to Further Your Career.

Contact Us