sales@dynamicsedge.com
202-410-6400
SKU: 100001 Categories: ,

Access 2019 Level 1 - Introduction. Versions 2013, 2016 Office 365, & Online are available.

In this course, you will create and manage an Access 2019 database.

Access 2019 Level 1 - Introduction.

Access 2019 Level 1 - Introduction

Versions 2013, 2016, 2019, Office 365, & Online are also available. In this course, you will create and manage an Access 2019 database.

Course Outline

Lesson 1 – Access Basics

  • Understanding Databases
  • Using Database Templates
  • Open an Existing Database
  • the Access Environment
  • a Look at Tables
  • a Look at Forms
  • Look at Queries
  • a Look at Reports
  • Creating a Blank Database
  • Setting Access Options
  • Using Help
  • Using Tell Me to Obtain Help

Lesson 2 - Working with Tables

  • Creating a Table Using Application Parts
  • Entering Data into a Table
  • Adding New Fields to a Table
  • Creating a Table from Scratch
  • Setting a Primary Key
  • Changing Column Width and Row Height
  • Rearranging Fields
  • Inserting and Deleting Fields
  • Changing Field Properties
  • Designing in Datasheet View

Lesson 3 - Working with Data

  • Editing Data
  • Formatting Table Data
  • Importing Excel Data into an Existing Table
  • Importing a Text File into a New Table
  • Selecting and Deleting Records
  • Sorting Records
  • Finding and Replacing Data
  • Filtering Data by Selection
  • Filtering Data by Form
  • Using Common Filters
  • Hiding/Unhiding Columns
  • Freezing Columns
  • Rearranging Columns
  • Displaying Column Totals in a Datasheet

Lesson 4 - Working with Queries

  • Working in Query Design View
  • Creating a Query in Design View
  • Adding Fields to a Query
  • Removing Fields from a Query
  • Saving a Query
  • Running a Query
  • Adding Criteria to a Query
  • Specifying Multiple Criteria
  • Sorting Data in a Query
  • Moving Columns in a Query
  • Using the Query Wizard

Lesson 5 - Creating Forms

  • Using the Form Wizard
  • Entering Data into a Form
  • a Look at Design View
  • Adding a Field to a Form
  • Changing Control Properties
  • Using Layout View
  • Finding Records in a Form

Lesson 6 - Creating Reports

  • Creating a Basic Report
  • Applying a Theme to a Report
  • Using the Report Wizard
  • Report View and Layout View
  • a Look at Design View
  • Modifying Report Setup
  • Printing Reports
  • Using the Label Wizard

 

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Access 2019 Level 1 - Introduction.

Need help picking the right course?

Give us a call!
408-684-5250 or 
800-453-596 (Toll Free) 

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Register Now

Price:

    Print

    Print this product
    202 S.E. Church Street, Suite 203 Leesburg, VA 20175
    https://www.dynamicsedge.com/
    sales@dynamicsedge.com
    Solutions
    Company
    202 Church Street S.E. , Suite 203 Leesburg, VA 20175
    202-410-6400
    800-453-596 (Toll Free)
    sales@dynamicsedge.com