Access 2016 Introduction

Access 2016 Introduction

09:28 23 July in

Length

1 Day

Course Content

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

Introduction to E-Mailing Database Information

  • E-Mailing Database Information

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

Working with Tables

  • Pasting Records
  • Sorting the Table
  • Deleting a Table
  • Table Layout Changes
  • Find
  • Replace
  • Wizards
August 3, 2021 8:00 am - 10:00 am Register Now
September 14, 2021 8:00 am Register Now
October 12, 2021 8:00 am Register Now
October 27, 2021 8:00 am Register Now

Comprehensive training and customized learning programs for your organization