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-Intro
Browse
Tab 1 of 3.
Page
Tab 2 of 3.
Publish
Tab 3 of 3.
Sign In
Tech Tools @ Mason
Access-Intro
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 - Intro
A. Introducing Access 2007
Starting Access and creating a desktop shortcut
Using the Getting Started screen
Opening an existing database or recently used database
Exploring the Microsoft Office button
Using and customizing the Quick Access toolbar
Understanding the Ribbon
Using the Navigation pane and Shutter bar to display and manage database objects
Closing a database and exiting Access
Using the Access Help window
Searching for a topic in Access Help
Creating a PDF
B. Understanding Content Security
Temporarily enabling a database that is not trusted
Viewing and understanding the Trust Center
Defining trusted locations
C. Creating a Database
Beginning a new database
Creating a new database based on an existing database
Create a database from a template
Finding database templates online
D. Database Design
Creating a table in Design view
Creating a table by typing
Creating a table using a Table template
Adding fields to a table from the Field Template task pane
Assigning a Primary key
Assigning a Primary key to more than one field
Inserting and deleting a field
Navigating a table
E. Working with Tables
Finding data in a table
Replacing data in a table
Entering data using AutoCorrect
Adding your own AutoCorrect values
Using spell check
Hiding and unhiding columns
Freezing and unfreezing columns
Renaming a field
Copying a field
Changing row height and column width
Filtering records in a table
Filtering records by form
F. Working with Forms
Creating a simple form
Working in Layout view pt. 1
Working in Layout view pt. 2
Creating a form using the Form wizard
Creating a form from scratch
Adding a field to a form
Working in Design view
Using a form to add, modify, and delete records
Displaying a form and its Data Sheet simultaneously
G. Working with Queries
Creating a Detail query
Creating a Summary query
Creating a query in Design view
Creating a Multiple Table query
Adding criteria to a query
Using logical operators in queries
Sorting query results
Finding the top values in a query
H. Working with Reports
Creating a report using the Report wizard
Creating a one-click report
Modifying a report in Layout view
Creating a report in Design view
Adding a page header and footer
Adding a report header and footer
false,false,1
