Creating Forms & Queries in Access 2019 for Windows

Access 2019 (Windows)    |    Intermediate
  • 8 Videos | 33m 35s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 28 Likes 28
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 in Access 2019 for Windows
    5m 45s
    UP NEXT
  • Playable
    2. 
    Using different form types in Access 2019 for Windows
    4m 21s
  • Locked
    3. 
    Creating a form from scratch in Access 2019 for Windows
    4m 9s
  • Locked
    4. 
    Editing form elements in Access 2019 for Windows
    4m 11s
  • Locked
    5. 
    Creating a simple query in Access 2019 for Windows
    4m 43s
  • Locked
    6. 
    Creating a crosstab query in Access 2019 for Windows
    2m 59s
  • Locked
    7. 
    Performing a simple calculation in Access 2019 for Windows
    3m 58s
  • Locked
    8. 
    Creating a calculated field in Access 2019 for Windows
    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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE