Creating Forms & Queries in Access 2019 for Windows

IN THIS COURSE

• 1.  Creating a form using the wizard in Access 2019 for Windows
  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
• 2.  Using different form types in Access 2019 for Windows
  4m 21s
  As well as creating a standard form, you can also create forms which will appear alongside your datasheet view. FREE ACCESS
• 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
• 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
• 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
• 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
• 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
• 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