Microsoft Office Access 2010 Foundation

Request more details:

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.
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