Creating Forms & Queries in Access 2010 for Windows

IN THIS COURSE

• 1.  Creating a data entry form using the wizard in Access 2010 for Windows
  6m 4s
  A form is a different interface which can be used to insert data into multiple fields from multiple tables via a single screen. This video tutorial will show you how to create your own form using the Form wizard, and also how to insert records into your table using the form. FREE ACCESS
• 2.  Creating a data entry form from scratch in Access 2010 for Windows
  5m 17s
  In Access 2010, you can also manually create a form. This added level of flexibility is extremely important if you want to maintain full control over how your form will function and look. In this video tutorial, you will find out how to create your own form from scratch. FREE ACCESS
• 3.  Inserting text in a form in Access 2010 for Windows
  6m 30s
  A form is used to facilitate data entry in your database. It is therefore important to know how to insert text boxes in order to help the individual using the form to insert the necessary data. This video tutorial will show you how to create text boxes in your form. FREE ACCESS
• 4.  Inserting data entry fields in Access 2010 for Windows
  6m 27s
  The form is an interface for inserting data into your table. In order to transfer that data from your form to the table, you are going to need data entry fields. In this video tutorial, you will find out how to create data entry fields. FREE ACCESS
• 5.  Inserting a list box in Access 2010 for Windows
  5m 29s
  A list box allows the user to choose between different data values that have been defined by the form's creator. This element is highly customizable. This video tutorial will show you how to create a list box. FREE ACCESS
• 6.  Inserting check boxes in Access 2010 for Windows
  3m 53s
  Check boxes allow the user to quickly and easily choose between different data values. In this video tutorial, you will find out how to create these data entry tools. FREE ACCESS
• 7.  Inserting buttons in Access 2010 for Windows
  5m 54s
  Buttons are important if the user is going to be able to navigate within the form. This video tutorial will show you how to insert different types of button, including ones that will allow the user to save their data entry, close the form, and move onto a new record. FREE ACCESS
• 8.  Reorganizing your form in Access 2010 for Windows
  5m 54s
  Once you have completed your form, you may find that the different elements that you have created are not in the right place. It is entirely possible to reorganize these elements, in order to ensure that your form is as user-friendly and easy to complete as possible. In this video tutorial, you will find out how to adjust the placement of your form's different components. FREE ACCESS
• 9.  Adding information to your form in Access 2010 for Windows
  4m 26s
  It is also possible to insert explanatory information boxes to your form. As well as a title, you can also insert a logo and even a date. This video tutorial will show you how… FREE ACCESS
• 10.  Customizing the appearance of your form in Access 2010 for Windows
  3m 12s
  If you are unhappy with your form's appearance, you can change it. In Access 2010, you can apply predefined themes which can change how your form looks. FREE ACCESS
• 11.  Editing your form's properties in Access 2010 for Windows
  3m 41s
  The properties of your newly-created form can also be customized: aspects such as the form's background and dimensions can all be changed. FREE ACCESS
• 12.  Creating a simple query in Access 2010 for Windows
  6m 11s
  In order to combine different data fields and records into a single screen, you can create a query. This video tutorial will show you how to set up your query and how to adjust its settings. FREE ACCESS
• 13.  Creating a crosstab query in Access 2010 for Windows
  4m 39s
  A crosstab query allows you to extract and organize very specific data elements taken from your database tables. In this tutorial, you will find out how to how to create a crosstab query. FREE ACCESS
• 14.  Creating a calculated field in Access 2010 for Windows
  2m 48s
  Calculated fields allow you to create entries that are automatically inserted. Similar to functions and formulae in a spreadsheet program, calculations can be constructed from a combination of mathematical symbols and field data. This video tutorial will show you how to create a basic calculation in your table. FREE ACCESS