Access 2019: Creating Forms & Queries


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Forms in Access 2019 are designed to help you visualize records and create new data entries more easily. In this 8-video course, "Access 2019: Creating Forms and Queries," learners discover how to create forms quickly using the form wizard tool, add data values, create queries, and perform calculations. Begin by learning how to create a data entry form with the wizard tool, before exploring the use of different form types. Discover how to create a data entry form from scratch, and edit form elements by inserting text in a form. You will then observe how to create a simple query, as well as a crosstab query, which allows you to cross reference data that you have extracted from your Access database. The course continues by demonstrating how to perform a simple calculation, with which, for example, you can apply sum, maximum, and average formulas to analyze the information inserted into a query, and concludes by showing learners how to create a calculated field.



Expected Duration (hours)
0.6

Lesson Objectives

Access 2019: Creating Forms & Queries

  • create a data entry form using the wizard
  • Using different form types
  • Creating a data entry form from scratch
  • Inserting text in a form
  • Creating a simple query
  • Creating a crosstab query
  • Performing a simple calculation
  • Creating a calculated field
  • Course Number:
    ds_msac2019_06_enus

    Expertise Level
    Intermediate