Generate Direct Linking HTML

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

Access 2007 - Intermediate
- A. Using Access and Tables
- - Searching for objects in the Navigation pane
  - Viewing a sample database
  - Create a custom Field template pt. 1
  - Create a custom Field template pt. 2
  - Displaying the sub data sheet for a table
  - Advanced filtering and sorting on a table
- B. Field Types and Properties
- - Adding an input mask to 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 a hyperlink field
  - Adding a field caption
  - Changing the field size
  - Choosing number formats
  - Choosing date/time formats
  - Choosing a yes/no format
- C. Queries
- - Using a query to calculate a value
  - Prompting for a value in a query
  - Summarizing data with the Totals row
  - Creating a Make-Table query
  - Creating an Update query
  - Creating an Append query
  - Creating a Delete query
  - Finding duplicate records
  - Finding unmatched records
- D. 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 one control layout into two layouts
  - Changing the Control tab order
- E. Reports
- - Adding current 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. Beautifying Forms and Reports
- - Applying an AutoFormat
  - Applying AutoFormat elements
  - Creating a new AutoFormat
  - Customizing an AutoFormat
  - 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
  - Tiling a picture

Access 2007 - Intermediate

Platform: PC

Microsoft^® Access 2007 is an easy-to-use database software that helps you track and report information with ease. It features a results-oriented user interface that's context-sensitive and optimized for efficiency and flexibility. Take your knowledge of Access 2007 to the next level with this intermediate tutorial series.

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 and Tables

		Key #	Length
1.	Searching for objects in the Navigation pane	35733	1:19
2.	Viewing a sample database	35734	1:56
3.	Create a custom Field template pt. 1	35735	1:41
4.	Create a custom Field template pt. 2	35736	2:49
5.	Displaying the sub data sheet for a table	35737	2:45
6.	Advanced filtering and sorting on a table	35738	2:18

B. Field Types and Properties

		Key #	Length
1.	Adding an input mask to a field	35739	3:21
2.	Making a field required	35740	1:47
3.	Formatting field contents	35741	3:24
4.	Assigning a default value to a field	35742	1:33
5.	Adding fields from an existing table	35743	2:34
6.	Using hyperlink fields	35744	1:22
7.	Editing a hyperlink field	35745	1:23
8.	Adding a field caption	35746	1:27
9.	Changing the field size	35747	3:18
10.	Choosing number formats	35748	2:18
11.	Choosing date/time formats	35749	2:15
12.	Choosing a yes/no format	35750	2:14

C. Queries

		Key #	Length
1.	Using a query to calculate a value	35751	2:52
2.	Prompting for a value in a query	35752	1:10
3.	Summarizing data with the Totals row	35753	1:52
4.	Creating a Make-Table query	35754	1:36
5.	Creating an Update query	35755	2:27
6.	Creating an Append query	35756	2:36
7.	Creating a Delete query	35757	2:53
8.	Finding duplicate records	35758	1:49
9.	Finding unmatched records	35759	2:12

D. Forms

		Key #	Length
1.	Adding a Date-Picker control	35760	2:14
2.	Adding a Combo box	35761	3:30
3.	Adding a List box	35762	2:23
4.	Editing values in a List box	35763	2:03
5.	Creating a Command button	35764	2:28
6.	Creating an Option group	35765	3:00
7.	Using a Toggle button, Option button, and Check box control	35766	2:18
8.	Creating a Multiple Items form	35767	2:14
9.	Splitting one control layout into two layouts	35768	2:34
10.	Changing the Control tab order	35769	2:11

E. Reports

		Key #	Length
1.	Adding current date and time to a report	35770	2:28
2.	Creating a report in Layout view	35771	2:27
3.	Inserting a page break	35772	1:39
4.	Sorting a report	35773	2:56
5.	Grouping a report	35774	2:41
6.	Adding a group footer containing summary information	35775	2:05
7.	Keeping a group together on one page	35776	1:45
8.	Forcing a new group onto a separate page	35777	1:31
9.	Creating a summary report without record details	35778	1:45
10.	Creating a calculated field in a report	35779	1:50
11.	Creating mailing labels	35780	3:12

F. Beautifying Forms and Reports

		Key #	Length
1.	Applying an AutoFormat	35781	1:05
2.	Applying AutoFormat elements	35782	1:15
3.	Creating a new AutoFormat	35783	1:25
4.	Customizing an AutoFormat	35784	1:21
5.	Applying a conditional format	35785	2:18
6.	Changing control color	35786	2:18
7.	Adding special effects to controls	35787	1:51
8.	Aligning controls	35788	1:30
9.	Spacing the controls horizontally and vertically	35789	1:34
10.	Adding gridlines to a control layout	35790	1:19
11.	Changing the gridline appearance	35791	1:06
12.	Adding a rectangle and line control	35792	2:32
13.	Adding a picture in Design view	35793	1:25
14.	Setting the Size Mode property of an image	35794	1:52
15.	Tiling a picture	35795	1:05

Tutorial series by Sarah DePriest

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.