Creating Forms & Queries

Access 2019 (Windows)    |    Intermediate
  • 8 Videos | 33m 35s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 13 Likes 13
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.

WHAT YOU WILL LEARN

  • create a form using the wizard
    create different types of forms
    create a form from scratch
    edit form elements
  • create a simple query
    create a crosstab query
    perform a simple calculation
    create a calculated field

IN THIS COURSE

  • Playable
    1. 
    Creating a form using the wizard
    5m 45s
    UP NEXT
  • Playable
    2. 
    Using different form types
    4m 21s
  • Locked
    3. 
    Creating a form from scratch
    4m 9s
  • Locked
    4. 
    Editing form elements
    4m 11s
  • Locked
    5. 
    Creating a simple query
    4m 43s
  • Locked
    6. 
    Creating a crosstab query
    2m 59s
  • Locked
    7. 
    Performing a simple calculation
    3m 58s
  • Locked
    8. 
    Creating a calculated field
    3m 29s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 16 Likes 16  
Likes 97 Likes 97  
Likes 17 Likes 17