Quick Source Learning Guides Access 2010 Quick Source Guide

Microsoft®

QUICK
Source

Access 2010

Getting Started

Opening an Existing Database

1. Click on the File tab.
2. Select Open in the left pane.
3. In the Open dialog box, locate and select the file you want to

The Access Window
u
v
w

open.

4. Click the Open button.

Note: To open a recently opened database, click on the File tab,
select Recent in the left pane, and click the title of the database
you want to open.

x

Creating a New Blank Database

1. Click on the File tab.
2. Select New in the left pane.
3. Do one of the following under Available Templates:
• To create a new blank database, click on Blank Database.
• To create a new blank web database, click on Blank web

y
{

4.
5.
6.
7.
8.

z

u
v
w
x
y
z
{

Quick Access Toolbar – contains shortcuts for the most
commonly used tools.
Backstage View – contains tools to work with workbook files
and manage Word settings.
Ribbon – contains groups of tools for use with Word 2010.
Objects – display tabs for open database objects.
Navigation Pane – allows you to work with all database
objects.
Status Bar – contains object information and shortcuts,
including View buttons.
Object Window – displays the currently open database object.

database.
Enter a file name in the File Name box.
Click the Browse button for a location to put your database.
Select a location to save the database
Click the OK button.
Click the Create button.

Creating a Database from a Template

When you create a database
based on a template,
preformatted tables, queries,
forms, and reports are
included with the database.
1. Click on the File tab.
2. Select New in the left
pane.
3. Do one of the following:
• To use a recently used template, select Recent templates.
• To use a sample template, select Sample templates.
• To use a template that you have created, select My
templates.
4. Select the template you want to use.
5. Click the Create button.
Note: Click the Home button to return to the Available Templates
pane.

Customizing the Ribbon

Click on the File tab.
Select Options in the left pane.
Select Customize Ribbon.
Click the arrow on the Customize the Ribbon box and select
the tab group you want to customize from the resulting menu.
5. Do any of the following:
• To hide or display a tab, check or clear the box next to the
group name in the box on the right.
• To rename a tab or group, select the current name and click
the Rename button. Enter a new name in the Display name
box and click the OK button.
• To rearrange tabs and groups, select the tab or group name
and click the Move Up
or Move Down
button.
6. Click the OK button when you are finished.
1.
2.
3.
4.

Creating a Database Based on an
Office.com Template
1.
2.
3.
4.
5.

Using the Backstage View

The Backstage view replaces and expands on the File menu in
Access 2003 and the Microsoft Office button in Access 2007. The
Backstage view allows you to quickly manage Access settings, such
as Add-Ins, Properties, and Options. It also allows you to save a
file, open a file, or print the current file. To access the Backstage
view, click on the File tab on the Tab Bar. Make selections in
the Left pane. Click on a tab (including the File tab) to exit the
Backstage view.

Click on the File tab.
Select New in the left pane.
Select a template category in the Office.com Templates section.
Select the template you want to use.
Click the Download button.

Saving a Database
1.
2.
3.
4.
5.
6.

1

Close all open objects in the database.
Click on the File tab.
Select Save Database As in the left pane.
Select a location to save the database.
Enter a name for the database in the File name box.
Click the Save button.

Copyright © 2010 by QUICK Source