Download Microsoft Access 2013 Cheat Sheet and more Cheat Sheet Microsoft Access Skills in PDF only on Docsity!
Microsoft
®
Access 2013 Cheat Sheet
Create a Database:
- Click a template category in the
list and click the template you
want to use and click Create
-Click Blank Database button
Open Existing Database:
- Click a database in the Open
Recent Database list or click More
and browse for it
Program Layout
Getting Started Window
File Tab
Quick Access Toolbar
Title Bar
Minimize
Maximize
Close
Ribbon
Status
Bar
Navigation
Pane
Object Tabs
Record
Navigator
Table in
Datasheet View
Customize the Quick Access
Toolbar to hold comm and s
such as Save, Print, Undo,
Redo, Copy and Paste.
File Tab & Backstage View:
Holds the o ptio n s to st art
a new database, open a
saved f ile, save, prin t,
pr e pa re for dis tribution,
publish the database,
close the progra m an d
sho w recent ly viewed
databases
Views
Create New Database:
Click File Tab, select New
Open Existing Database:
Click File Tab, select Open
Save a Database:
Click File Tab, select Save
Save with a different name:
Click File Tab, select Save As
Print Preview:
Click File Tab, select Print Preview
Print:
Click File Tab, select Print
Navigation Keyboard Shortcuts:
Tab : Move to next f ield
Shift + Tab : Move to previous f ield
F 11: Toggle the Navigation Pane
Keys to Remember:
Backspace: Erases back one space
Delete: Erases forward one space
Num Lock: Controls the 10-key pad
Choose Template Category
Open
Existing
Database
Create
Blank
Database
Select a
Template
Program Basics
Database Objects
Create Tab
Tables Group Forms Group Reports Group Macros & Code Group
Table Form
Report
Query
Tables:
Add New Blank Table:
Click the Table icon in the Tables Group
Add New Table from a Template:
Click the Application Parts icon in the Templates
Group and choose a template from the list
Edit Table Design:
Click the Table Design icon in the Tables Group
and you will be taken to Design View
Forms:
Add New Form:
Click the Form icon in the Forms Group
Add Split Form:
Click the More Forms icon in the Forms Group
Add Blank Form:
Click the Blank Form icon in the Forms Group
Edit Form Design:
Click the Form Design icon in the Forms Group
Forms: Are custom screens that provide an easier
way to enter and view data
Reports: Present data from a table or query in a
printed format
Query:
Create New Query:
Click the Query Wizard icon in the Query Group
Edit Query Design:
Click the Query Design icon in the Query Group
Reports:
Add New Report:
Click the Report icon in the Reports Group
Add Blank Report:
Click the Blank Report icon in the Reports Group
Edit Report Design:
Click the Report Design icon in the Reports Group
Open Report Wizard:
Click the Report Wizard icon in the Reports Group
Using Database Objects:
Open an object:
Double-click the object in the Navigation Pane
Modify an Object:
Open the object, click the Format tab on the
Ribbon, click the View button in the Views group
and choose Design or Layout view
Delete an Object:
Select the object and press Delete and click Yes
Rename an Object:
Right-click the object, select rename, enter new
name and press Enter
Import & Export Data:
Use the External Data tab on the Ribbon
Tables: Store related data in records (rows) and
f ields (columns)
Queries: View, f ilter, calculate, change, sort and
examine data in a table
Queries Group Templates Group
Your Notes...
