Creating Forms & Queries in Access 2016 for Windows

Access 2016 (Windows)    |    Intermediate
  • 16 videos | 1h 16m 5s
  • Includes Assessment
  • Earns a Badge
Rating 4.9 of 14 users Rating 4.9 of 14 users (14)
Forms in Access 2016 are designed to help you visualize records and create new data entries more easily. Discover different ways to create and customize forms, and create and work with queries.

WHAT YOU WILL LEARN

  • Creating a data entry form using the wizard
    Using different form types
    Creating a data entry form from scratch
    Inserting text in a form
    Inserting data entry fields in a form
    Inserting a list box in a form
    Inserting check boxes in a form
    Inserting buttons in a form
  • Reorganizing your form
    Adding information to your form
    Customizing the appearance of your form
    Editing your form's properties
    Creating a simple query
    Creating a crosstab query
    Performing a simple calculation
    Creating a calculated field

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

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.9 of 8 users Rating 4.9 of 8 users (8)
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 77 users Rating 4.4 of 77 users (77)
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)