Creating Forms & Queries in Access 2013 for Windows

Access 2013 (Windows)    |    Intermediate
  • 15 videos | 1h 28m 57s
  • Earns a Badge
Likes 13 Likes 13
In Access 2013, forms can simplify the process of data entry and queries allowing you to return information based on specified criteria. Learn about creating and customizing forms, as well as creating queries and calculations.


  • Creating a data entry form using the wizard
    Creating a data entry form from scratch
    Inserting text in a form
    Inserting data entry fields
    Inserting a list box
    Inserting check boxes
    Inserting buttons
    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


  • 5m 8s
    Forms are designed to help you visualize records and create new data entries more easily. Access 2013 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
  • 7m 51s
    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 2013, there are a number of different ways of creating a new form. FREE ACCESS
  • Locked
    3.  Inserting text in a form in Access 2013 for Windows
    5m 27s
    A form that you have created in Access 2013 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
    4.  Inserting data entry fields in Access 2013 for Windows
    7m 8s
    Data entry fields are extremely useful for adding values to your data tables in Access 2013. 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
    5.  Inserting a list box in Access 2013 for Windows
    6m 41s
    List boxes can be used to limit the values that can be inserted into a form. In Access 2013, 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
    6.  Inserting check boxes in Access 2013 for Windows
    6m 8s
    Check boxes can be used to simplify some of the questions or fields in your Access 2013 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
    7.  Inserting buttons in Access 2013 for Windows
    5m 39s
    Buttons are used to give users greater control over their Access 2013 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
    8.  Reorganizing your form in Access 2013 for Windows
    7m 18s
    You can make your Access 2013 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
    9.  Adding information to your form in Access 2013 for Windows
    5m 14s
    In Access 2013, 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
    10.  Customizing the appearance of your form in Access 2013 for Windows
    5m 43s
    Access 2013 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
    11.  Editing your form's properties in Access 2013 for Windows
    6m 4s
    Every Access 2013 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
    12.  Creating a simple query in Access 2013 for Windows
    6m 6s
    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 2013 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
    13.  Creating a crosstab query in Access 2013 for Windows
    4m 24s
    A crosstab query allows you to cross reference data that you have extracted from your Access 2013 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
    14.  Performing a simple calculation in Access 2013 for Windows
    4m 50s
    You Access 2013 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
    15.  Creating a calculated field in Access 2013 for Windows
    5m 17s
    Another extremely useful feature that you can add when creating a query in Access 2013 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 2013, you can use square brackets and mathematical symbols to create your calculated field. FREE ACCESS


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.