Access Basic

Access Basic​​​​

Objective​

This class covers basic concepts in Microsoft Access and teaching the foundational skills for designing and building a database. Students will come from this class feeling confident in designing a simple Access database or making changes to an existing one.

Prerequisite

Intermediate computer skills and experience with Microsoft Excel and other Microsoft Office programs.

Outline

Database Concepts

Design vs. Datasheet View

Database wizard

Creating blank databases

Creating tables

Working with Fields

Adding fields

Identifying primary key fields

Adding records

Changing table designs

Modifying field names

Deleting and inserting fields

Records

Finding and editing records

Sorting and filtering records

Setting field properties

Input Masks

Validation Rules

Indexes

Queries

Creating Queries

Filtering Queries

Modifying query results

Operations in Queries

Using Calculators

Average and Count functions

Creating forms to enter data

formatting and customizing forms

Using forms to find, sort, and filter records

Creating reports through the report wizard

Field properties

Recommended Classes:

Learn how to read and understand the financial reports for your nonprofit. Use the results of past management decisions, as reflected in the reports, to make better decisions in the future.... Read More