Creating Forms & Queries in Access 2013 for Windows

IN THIS COURSE

• 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 the form. You can even use forms to fill out fields and records in completely different tables. FREE ACCESS
• 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 form. FREE ACCESS
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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