Creating Forms & Queries in Access 2019 for Windows

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.