Microsoft Office Access 2010 Foundation

Course Description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2010 relational database application.
1 Day
Contact us for pricing
Contact us for dates
Contact us for dates

Prerequisites

To effectively understand this course, we recommend that you take the Microsoft Office Windows XP, Vista or Windows 7 Introduction course or have equivalent knowledge.

Starting Out

What is Microsoft Access?
What’s New in Access 2010?
Basic Database Terminology
Opening and Closing Access

Interface Basics

Understanding Backstage View (File Menu)
Interface Overview
Using the Standard Tabs
Using Contextual Tabs

Database Security

Warnings You May See when Opening a Database
Enabling Content
About Digital Signatures
About Trusted Locations
Opening the Trust Center
Assigning a Password to your Database

Getting Help

Opening the Help File
Overview of the Help File
Online vs. Offline Help
Searching for Help

The Quick Access Toolbar

The Default QAT Commands
Adding Commands
Removing Commands
Customizing the Toolbar

Basics of Tabs

About Tabs
Opening Additional Dialog Boxes
Using the File (Backstage) Menu
Minimizing the Ribbon

The Home Tab

Views Commands
Clipboard Commands
Sort & Filter Commands
Records Commands
Find Commands
Text Formatting Commands

The Create Tab

Templates Commands
Tables Commands
Queries Commands
Forms Commands
Reports Commands
Macros & Code Commands

The External Data Tab

Import & Link Commands
Export Commands
Collect Data Commands

The Database Tools Tab

Tools Commands
Macro Commands
Relationships Commands
Analyze Commands
Move Data Commands
Add-Ins Commands

First Steps

Planning a Database
Creating a Blank Database
Creating a Database from a Template
Using Database Objects
Setting Navigation Options

About Records

What is a Record?
Navigation Tips
Adding Records
Editing Records
Deleting Records
Printing Records

Creating a Table

About Tables
Creating a Table
Using Design View
Entering Data into a Table
Formatting a Table

Formatting Text

Using the Zoom Box
Selecting Data
Cutting, Copying, and Pasting
Using the Format Painter
Using Undo and Redo
Checking your Spelling

Creating and Using Forms

What is a Form?
Bound vs. Unbound Controls
Creating a Basic Form
Creating a Form with the Wizard
Using Design View to Modify your Form
About the Form Design Tools Contextual Tabs
Using Forms

Creating and Using Queries

What is a Query?
Creating a Query with the Wizard
Using Design View to Modify a Query
About the Query Design Tools Contextual Tab
Using Queries

Creating and Using Reports

What is a Report?
Creating a Report with the Wizard
Using Design View to Modify a Report
About the Report Design Tools Contextual Tabs
Using Reports

Sorting and Filtering Data

Using Find and Replace
Sorting Ascending or Descending
Toggling Filter
Using Selection Sort
Using Advanced Sort

Viewing Data

Using the View Menu
Using the View Icons
Using the Object Tabs
Closing Individual Object Tabs

Printing a Database Object

Print Commands
The Print Dialog Box
Using Print Preview
Printing vs. Exporting

Access 2010Microsoft Access