Creating Forms & Queries in Access 2019 for Windows

Access 2019 (Windows)    |    Intermediate
  • 8 videos | 33m 35s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)
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

  • 5m 45s
    Forms are designed to help you visualize records and create new data entries more easily. Access features a tool that will walk you through each step of the form creation process, from selecting the fields to naming the form. You can even use forms to fill out fields and records in completely different tables. FREE ACCESS
  • 4m 21s
    As well as creating a standard form, you can also create forms which will appear alongside your datasheet view. FREE ACCESS
  • Locked
    3.  Creating a form from scratch in Access 2019 for Windows
    4m 9s
    If you want greater control over how your data form is organized, which fields it contains, and even its appearance, you can build it from scratch in Access 2019. FREE ACCESS
  • Locked
    4.  Editing form elements in Access 2019 for Windows
    4m 11s
    A form that you have created in Access can be customized and edited in different ways. This is particularly useful if you want to include additional information. For example, you can add design elements such as a title or labels. You can also choose to add or edit fields in your form. FREE ACCESS
  • Locked
    5.  Creating a simple query in Access 2019 for Windows
    4m 43s
    A query is used to combine into one datasheet values taken from a variety of different sources. If you have created linked data tables in your Access database, you can use these relationships to extract correlating records and values. Once you have created a query, you can apply filters to focus on particular records or fields. FREE ACCESS
  • Locked
    6.  Creating a crosstab query in Access 2019 for Windows
    2m 59s
    A crosstab query allows you to cross reference data that you have extracted from your Access database. The query - which is similar to a pivot table - allows you to analyze your data and check for correlations in your values. You can also summarize your data using different calculations, including sum, minimum, maximum and average. FREE ACCESS
  • Locked
    7.  Performing a simple calculation in Access 2019 for Windows
    3m 58s
    You Access query can also be used to perform simple calculations with the data that you have extracted. For example, you can apply sum, maximum, minimum and average formulae to analyze the information that you have inserted into your query. FREE ACCESS
  • Locked
    8.  Creating a calculated field in Access 2019 for Windows
    3m 29s
    Another extremely useful feature that you can add when creating a query in Access is the calculated field. The calculated field allows you to obtain the product or result of two or more fields in your data table. This can be particularly useful if for example your query includes a sales tax rate and a product's purchase price and you want to find out the total price to pay in a third column. In Access, you can use square brackets and mathematical symbols to create your calculated field. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.6 of 72 users Rating 4.6 of 72 users (72)
Rating 4.5 of 482 users Rating 4.5 of 482 users (482)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 15 users Rating 4.5 of 15 users (15)
Rating 4.1 of 218 users Rating 4.1 of 218 users (218)
Rating 4.1 of 52 users Rating 4.1 of 52 users (52)