Microsoft Access (365 / 2019 / 2016 Level 1)

Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.

Objectives

To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.

Prerequisites

• Familiarity with personal computers, keyboards, and mice

• Basic Microsoft Windows Skills

• Knowledge of Excel data management (Optional)

Outline

• Introduction to Databases

  • Database concepts

  • Database Layout

  • Launching Access

  • The Access Menu System

  • Dialog Boxes

  • Getting Help

  • Creating A New Database

  • Creating an Access Web App

  • Closing A Database (Vs Exit Access)

  • Opening A Database

• Tables

  • Database Design

  • Creating Tables Using The Table Wizard

  • Creating Tables In The Datasheet View

  • Creating Tables In The Design View

  • Data Types

  • Field Properties

  • Data Display Format Vs Input Mask

  • The Input Mask

  • Data Entry Problems

  • Moving And Copying Records

• Working with Tables

  • Pasting Records

  • Sorting The Table

  • Deleting A Table

  • Table Layout Changes

  • Find

  • Replace

  • Wildcards

• Queries

  • The Simple Query Wizard

  • The Design View

  • Modifying The Query

  • Using Basic Criteria

  • Additional Criteria

  • Parameters

  • Multiple Object Queries

  • Custom Calculations In A Query

  • Calculating Fields Continued

  • Grouping Fields

• Introduction to Reports

  • Reports

  • The Report Wizard

• Introduction to E-mailing database information

  • E-Mailing Database Information