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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1.  Creating a data entry form using the wizard in Access 2013 for Windows
    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… FREE ACCESS
  • Playable
    2.  Creating a data entry form from scratch in Access 2013 for Windows
    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… 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… 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… 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… 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… 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… 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… 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… 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… 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… 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… 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… 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.… 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