You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Site Actions
This page location is:
Home
Tech Tools @ Mason
Access-Intermediate
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Sign In
Tech Tools @ Mason
Access-Intermediate
team site for students, parents, and staff
Top Link Bar
Tech Tools @ Mason
PC Maintenance & Security
Digital Citizenship
Digital Citizenship links
Access
Intro
Intermediate
Advanced
Outlook
Office 2010
Sound Recording
Audacity PC
Audacity Mac
What does sound look like?
Video tools
Premier Pro CS4
Windows Movie Maker
Recently Modified
Home
Premier Pro CS4
Movie Maker
Audacity Project
Audacity PC
Quick Launch
Team Discussion
Word
Getting Started
Intro
Intermediate
Advanced
Newsletter Workshop
Mail Merge Workshop
WordTips
PowerPoint
Getting Started
Intro
Intermediate
Advanced
Excel
Intro
Intermediate
Advanced
Charting Workshop
Pivot Tables
Statistical Analysis
All Site Content
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
false,false,1
