Course details

Access 2019: Creating Forms & Queries

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. You can create forms quickly with the form wizard tool. If you don't find the type of form you would like to create, you can always create a form from scratch and add the data values you need most. Once you have created a form you can format and customize the text within your form.

Access 2019 also allows to perform queries of your data values. You can create a simple query or a more comprehensive query with the crosstab query tool. If you want to go further with your query you can create a calculated field to better analyze you data values. In this course you will see how to create forms and queries with Access 2019.



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