Creating Forms & Queries in Access 2016 for Windows

IN THIS COURSE

• 1.  Creating a data entry form using the wizard in Access 2016 for Windows
  4m 23s
  Forms are designed to help you visualize records and create new data entries more easily. Access 2016 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 2016 for Windows
  4m 3s
  As well as creating a standard form, you can also create forms which will appear alongside your datasheet view or which contain multiple entries. FREE ACCESS
• 3.  Creating a data entry form from scratch in Access 2016 for Windows
  2m 35s
  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 2016, there are a number of different ways of creating a new form. FREE ACCESS
• 4.  Inserting text in a form in Access 2016 for Windows
  5m 25s
  A form that you have created in Access 2016 can be customized by adding titles and text zones. This is particularly useful if you want to include additional information that can help the user to complete your form. These titles and text zones can also be formatted in the exactly the same way as other text elements in your database. FREE ACCESS
• 5.  Inserting data entry fields in a form in Access 2016 for Windows
  4m 21s
  Data entry fields are extremely useful for adding values to your data tables in Access 2016. If you want to use these data entry fields to speed up data entry in your database, you will need to know how to insert and arrange them within your form. FREE ACCESS
• 6.  Inserting a list box in a form in Access 2016 (Windows)
  5m 24s
  List boxes can be used to limit the values that can be inserted into a form. In Access 2016, these list boxes come in a variety of different forms and are very useful for guiding the user's answers, speeding up data entry, and minimizing typing errors. FREE ACCESS
• 7.  Inserting check boxes in a form in Access 2016 for Windows
  6m 24s
  Check boxes can be used to simplify some of the questions or fields in your Access 2016 form. Users filling out your form are given a number of preset options from which they can choose. These controls can be very useful if for example you want users to evaluate their satisfaction with a particular product. FREE ACCESS
• 8.  Inserting buttons in a form in Access 2016 for Windows
  4m 52s
  Buttons are used to give users greater control over their Access 2016 data entry forms. These buttons are extremely useful for performing certain operations actions, such as creating a new entry or opening the next record in the table. FREE ACCESS
• 9.  Reorganizing your form in Access 2016 for Windows
  6m 45s
  You can make your Access 2016 form easier to use by reorganizing the different elements and controls that you have created. Putting each field, command and text zone in the right place will help your users to understand your form's structure and purpose. To do this, you can use the form's body, header and footer. FREE ACCESS
• 10.  Adding information to your form in Access 2016 for Windows
  4m 16s
  In Access 2016, you can improve your form by adding insert additional information, such as a title, logo, time or date. When inserting this data, it is important to make sure that it is clear to read and correctly placed within your form. Your form's header and footer are particularly useful for this. FREE ACCESS
• 11.  Customizing the appearance of your form in Access 2016 for Windows
  4m 23s
  Access 2016 features a number of different tools that can be used to adjust the appearance of your form. You can, for example, change the overall theme, select a new color set, and even change the font schemes that are used to format your text. You can also change the background settings by adding your own image. FREE ACCESS
• 12.  Editing your form's properties in Access 2016 for Windows
  4m 25s
  Every Access 2016 form features a list of properties that can be used to adjust everything from the form's layout and margins to how it opens in your database. You can even hide your form's scrollbars… FREE ACCESS
• 13.  Creating a simple query in Access 2016 for Windows
  5m 1s
  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 2016 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
• 14.  Creating a crosstab query in Access 2016 for Windows
  4m 20s
  A crosstab query allows you to cross reference data that you have extracted from your Access 2016 database. The query - which is similar to a PivotTable - 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
• 15.  Performing a simple calculation in Access 2016 for Windows
  4m 41s
  You Access 2016 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
• 16.  Creating a calculated field in Access 2016 for Windows
  4m 47s
  Another extremely useful feature that you can add when creating a query in Access 2016 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 2016, you can use square brackets and mathematical symbols to create your calculated field. FREE ACCESS