Yawn-proof software training

The Basics

The course begins with a look at how to get started with Access, create and save a database, and open an existing database. Then, participants will learn how to sign into Office with a Microsoft account. The module also includes information on database terminology.

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

Your First Database

This module discusses how to search for objects along with how to open various database objects. Participants will also learn how to change object views and how to manage objects. Also included is information on security warnings and data relationships.

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

Working with Tables and Records

Here, we take a look at tables and records. Participants will learn to create a table, add and edit database records, search and browse records, and delete and print records. How to make the most of different table views is covered here as well.

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

Formatting Tables

Delving deeper into tables is the focus of this module. In it, participants will learn to select data, change the size of rows and columns, apply text formatting and fill color, apply gridlines, and perform a spell check.

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

Creating Forms

Forms are the topic discussed here. Begin with the steps to create forms from an object, then  proceed to looking at creating forms using the wizard. Participants will also learn to create forms from scratch and how to use form views.

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

Formatting Forms

The look at forms continues in this module. Participants will start the module by learning how to change the theme of a form. Also covered is how to use the Format Painter, add fields to a form, and add controls and images to a form.

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

Creating Reports

Reports are the focus here. First, participants are shown how to create a report from an object and by using the wizard. Participants will also learn how to create a report from scratch, use report views, and print reports.

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

Formatting Reports

Information on reports is continued here with a look at how to change the theme of reports, use the Format Painter, and group and sort data in reports. The module also covers adding controls, images, logos, page numbers, headers, and footers to reports.

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

Creating Basic Queries

This module allows participants to develop skills on queries. They will learn how to create a query with the wizard, run a query, sort and filter a query, and use and apply query views. Participants will also learn about the types of queries that are available.

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

Creating Advanced Queries

Getting a more in-depth look at queries is the goal of this module. Participants will learn how to use parameter queries, multiple table queries, crosstab queries, make-table queries, append queries, delete queries, and update 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

Managing Your Database

In this module, participants will learn to compact and repair a database and encrypt a database using a password. Participants are also shown how to back up a database, export a database and database objects, and print database objects.

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

Customizing the Interface

This final module looks at the interface and tips for customizing it. Participants are shown how to collapse and pin the ribbon, customize the Quick Access toolbar, hide and show ribbon tabs, create custom tabs, and reset changes made to the interface.

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

Download Full Course Details as a PDF

Share this printable PDF with others in the office.

Download Now

Corporate Training

Who says improving employee software skills can’t be fun? We’ll take the time to understand staff challenges and engage them in learning. We'd love to hear from you:

Public Courses

There are no upcoming events.