Generate Direct Linking HTML

Select the tutorials you would like to include in the Direct Linking HTML, then click the "Preview" button.

Access 2010 - Intermediate Training
- A. Using Access 2010 and Tables
- - Searching for objects in the Navigation pane
  - Viewing a sample database
  - Creating a custom field template pt. 1
  - Creating a custom field template pt. 2
  - Displaying the sub data sheet for a table
- B. Working with Field Types and Properties
- - Using advanced filtering and sorting on a table
  - Adding an Input Mask on a field
  - Making a field required
  - Formatting field contents
  - Assigning a default value to a field
  - Adding fields from an existing table
  - Using hyperlink fields
  - Editing hyperlink fields
  - Adding a field caption
  - Changing the field size
  - Choosing number formats
  - Choosing date/time formats
  - Choosing a yes/no format
- C. Querying for Information
- - Using a query for calculating a value
  - Prompting for a value in a query
  - Summarizing data with totals
  - Creating a Make-Table query
  - Creating an Update query
  - Creating an Append query
  - Creating a Delete query
  - Finding duplicate records
  - Finding unmatched records
- D. Working with Forms
- - Adding a Date Picker control
  - Adding a combo box
  - Adding a list box
  - Editing values in a list box
  - Creating a Command button
  - Creating an Option Group
  - Using a Toggle button, Option button, and Check Box control
  - Creating a multiple items form
  - Splitting a control layout into two layouts
  - Changing the control tab order
- E. Generating Reports
- - Adding the date and time to a report
  - Creating a report in Layout View
  - Inserting a page break
  - Sorting a report
  - Grouping a report
  - Adding a group footer containing summary information
  - Keeping a group together on one page
  - Forcing a new group onto a separate page
  - Creating a summary report without record details
  - Creating a calculated field in a report
  - Creating mailing labels
- F. Making Forms and Reports Look Better
- - Applying a theme to a report or form
  - Applying a theme to a section of a report or form
  - Creating your own theme
  - Customizing a theme you've created
  - Applying a conditional format
  - Changing control color
  - Adding special effects to controls
  - Aligning controls
  - Spacing the controls horizontally and vertically
  - Adding gridlines to a control layout
  - Changing the gridline appearance
  - Adding a rectangle and line control
  - Adding a picture in Design view
  - Setting the Size Mode property of an image
  - Making a picture into a hyperlink

Access 2010 - Intermediate Training

Platform: PC

In this online tutorial series, take your working knowledge of tables, queries, reports and forms to the next level. What's more, learn how to dress up your Access^® 2010 forms and reports to better communicate your information.

Click here to learn about subscribing to this collection!

Click any of the highlighted titles to view free sample tutorial movies. Atomic Training subscribers to this collection have access to all of the following movies, plus thousands of tutorials on other applications.

Expand all / Collapse all

A. Using Access 2010 and Tables

		Key #	Length
1.	Searching for objects in the Navigation pane	86751	1:02
2.	Viewing a sample database	86752	1:11
3.	Creating a custom field template pt. 1	86753	1:23
4.	Creating a custom field template pt. 2	86754	1:39
5.	Displaying the sub data sheet for a table	86755	2:22

B. Working with Field Types and Properties

		Key #	Length
1.	Using advanced filtering and sorting on a table	86756	1:41
2.	Adding an Input Mask on a field	86757	1:59
3.	Making a field required	86758	1:15
4.	Formatting field contents	86759	1:57
5.	Assigning a default value to a field	86760	1:11
6.	Adding fields from an existing table	86761	1:13
7.	Using hyperlink fields	86762	1:04
8.	Editing hyperlink fields	86763	0:38
9.	Adding a field caption	86764	0:59
10.	Changing the field size	86765	1:04
11.	Choosing number formats	86766	1:01
12.	Choosing date/time formats	86767	1:39
13.	Choosing a yes/no format	86768	1:33

C. Querying for Information

		Key #	Length
1.	Using a query for calculating a value	86769	2:04
2.	Prompting for a value in a query	86770	1:22
3.	Summarizing data with totals	86771	1:40
4.	Creating a Make-Table query	86772	1:32
5.	Creating an Update query	86773	2:22
6.	Creating an Append query	86774	2:11
7.	Creating a Delete query	86775	1:25
8.	Finding duplicate records	86776	1:33
9.	Finding unmatched records	86777	1:49

D. Working with Forms

		Key #	Length
1.	Adding a Date Picker control	86778	1:47
2.	Adding a combo box	86779	1:50
3.	Adding a list box	86780	1:48
4.	Editing values in a list box	86781	1:56
5.	Creating a Command button	86782	1:43
6.	Creating an Option Group	86783	2:02
7.	Using a Toggle button, Option button, and Check Box control	86784	1:36
8.	Creating a multiple items form	86785	1:51
9.	Splitting a control layout into two layouts	86786	1:34
10.	Changing the control tab order	86787	1:26

E. Generating Reports

		Key #	Length
1.	Adding the date and time to a report	86788	1:10
2.	Creating a report in Layout View	86789	1:31
3.	Inserting a page break	86790	1:21
4.	Sorting a report	86791	1:06
5.	Grouping a report	86792	1:24
6.	Adding a group footer containing summary information	86793	1:07
7.	Keeping a group together on one page	86794	1:17
8.	Forcing a new group onto a separate page	86795	0:56
9.	Creating a summary report without record details	86796	0:47
10.	Creating a calculated field in a report	86797	1:35
11.	Creating mailing labels	86798	1:48

F. Making Forms and Reports Look Better

		Key #	Length
1.	Applying a theme to a report or form	86799	0:43
2.	Applying a theme to a section of a report or form	86800	0:59
3.	Creating your own theme	86801	1:00
4.	Customizing a theme you've created	86802	0:57
5.	Applying a conditional format	86803	1:34
6.	Changing control color	86804	0:57
7.	Adding special effects to controls	86805	0:55
8.	Aligning controls	86806	1:01
9.	Spacing the controls horizontally and vertically	86807	0:41
10.	Adding gridlines to a control layout	86808	0:38
11.	Changing the gridline appearance	86809	0:46
12.	Adding a rectangle and line control	86810	1:56
13.	Adding a picture in Design view	86811	0:57
14.	Setting the Size Mode property of an image	86812	1:25
15.	Making a picture into a hyperlink	86813	1:09

Tutorial series by Cindy Rybaczyk

Box shot reprinted by permission from Microsoft Corporation. Microsoft is either a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.