Access 2010 Course

COURSE TITLE

Access 2010 Course

DURATION

13 Hours of Interactive Training

COURSE OVERVIEW

Are you an office worker who needs to design, implement and maintain basic Access databases? Perhaps you are someone who's been using Excel to store all of your company lists? If this sounds like you, then this is the course for you. Microsoft has really outdone itself with all of the amazing new features to Access 2010, and this course covers them all. If you are new to databases then this Access 2010 course is where you want to start.

Jason Manibog will take you step-by-step through this course; starting with understanding what a Database is and how data relates to each other. Learn the process of planning and implementing a database effectively and then learn to use the tools provided in Access 2010 to design and maintain a basic database.

BENEFITS

Learn to create, modify, and personalize objects
Learn to work independently or in collaboration with others on database projects
Learn to ask and answer questions from others about the database
Create and/or modify a simple Access database

CONTACT

Website:

Email:

Telephone:+961+8+9404 7041

Fax:+961+8+9467 9132

PRICING

Contact Mobile MOUSe for pricing.

ADVANTAGES OF ONLINE COURSES

Session times are at your discretion
You can pick and choose which sessions to cover and in any order
Learn at your own pace
Free repetition (for a period of 6 months)
Multiple course levels at a discounted price
Many of the courses are internationally accredited
Training from the comfort of your home or workstation
Training can be accessed from any location

MOBILE MOUSe

ACCESS 2010 ONLINE COURSE OUTLINE

Session 1

Section A: Introduction

Database Defined
Available Database Platforms
Access Advantages and Disadvantages

Section B: Access 2010 Tour

Opening Access and Databases
Interface Overview
Quick Access Toolbar
Introduction to Backstage
Getting Help
Understanding Database Parts

Section C: Working with Tables and Forms

Navigating Tables
Sorting and Filtering Table Data
Entering and Editing Table Data
Navigating Forms
Entering and Editing Form Data
Form Types
Working with Multiple Items

Section D: Working with Queries and Reports

Running Queries
Running Reports

Section E: Database Organization Techniques

Using the Navigation Pane
Access Naming Conventions
Copying and Renaming Objects
Deleting Objects

Section F: Customizing Access

Customizing Quick Access Toolbar
Customizing the Ribbon
Backstage Customization Options
Additional Backstage Options
Section G: Understanding Relational Databases
Flat vs. Relational Databases
Relational Database Rules
Section H: Planning a Database
Defining Database Needs
Mapping Out a Database

Session 2

Section A: Building a Database

Database Options
Database from Template
Database from Scratch

Section B: Building Tables

Application Parts
Using Application Parts
Using Naming Conventions
Tables from Scratch
Create Table in Design View

Section C: Table Design Basics

Good Table Design Basics
Defining the Data Type
Yes/No Data Type
Other Data Types
Saving and Testing Tables

Section D: Adjusting Table Design

Understanding Field Properties
Database Adjustment Feedback
Edit Field Size
Removing Fields
Text vs. Numeric Field Options
Adding Descriptions
Renaming Fields
Importance of Field Consistency
Required Fields

Section E: Data Validation and Input Masks

Validation Rules
Building the Rule
Specify Validation Text
Testing Validation Rule
Input Masks
Input Mask Wizard

Section F: Lookups

Lookups Defined
Creating a Lookup
Using the Lookup Wizard
List-Based Lookups

Section G: Table Relationships

Understanding Table Relationships
Creating a Table Relationship
Referential Integrity
Determine Relationship Options
Manually Create Table Relationship

Section H: Importing Data

Importing Data into a New Table
Importing Data into an Existing Table
Troubleshooting Import Errors
Linked Tables

Session 3

Section A: Building Forms Automatically

Introduction to Forms
Creating a Standard Form
Form View Options
Creating a Split Form
Using the Form Wizard
Creating a Form/Subform

Section B: Building Forms Manually

Creation Process Defined
Creating Forms in Design View
Creating a Blank Form
Create Form using Application Parts
Manage Active Content and Security
Customizing Forms in Design View

Section C: Customizing and Personalizing Forms

Form Customization Techniques
Using and Customizing Themes
Alternating Row Colour
Form Personalization Techniques
Inserting an Image
Adding Background Images
Conditional Formatting

Section D: Working with Form Layout

Form Design Options
Using the Layout View
Using Stacked Layout
Converting Layouts
Controlling Margins and Padding
Unstacking a Layout

Section E: Working with Form Design

Using the Design View
Object Property Considerations
Getting the Form Properties
Controlling Tab Order

Section F: Adding Controls to Forms

Controls Defined
Adding a Button
Adding a Combo Box
Adding a Text Box

Section G: Filtering Data with Forms

Form-Based Filtering
Right-Click Filter Options
Filtering By Selection
Filtering By Form
Using Wildcards
Filtering Across Multiple Fields
Either/Or Filters

Section H: Building Navigation Forms

Understanding Switchboards
Using the Switchboard Manager
Editing Switchboard Items
Running the Switchboard
Creating a Navigation Form

Session 4

Section A: Building a Query with a Wizard

Purpose of Queries
Building a Query
Simple Query Wizard
Query Design Window
Using Other Wizards

Section B: Building a Query from Scratch

Defining a Queried Table
Adding Fields to a Query
Testing the Query
Hiding and Rearranging Fields
Joining Tables in Queries
Inner vs. Outer Joins
Convert Inner to Outer Join

Section C: Basic Criteria

Criteria Types
Filtering Data with Criteria
Using AND and OR Criteria
Using the IN Criteria

Section D: Comparison Criteria

Building a Comparison Query
Using < and >
Using BETWEEN
Using NULL and NOT
Querying using Wildcards
Using Single Character Wildcards

Section E: Performing Calculations

Understanding Calculations
Building a Calculated Field
Using Expression Builder
Understanding Expression Builder
Writing and Formatting Expressions
Concatenating Fields

Section F: Working with Calculated Totals

Using the Total Row
Performing Queries Using Aggregates
Calculated Total Considerations

Section G: Advanced Select Queries

Crosstab Query Defined
Crosstab Query Example
Editing Query Properties
Parameter Query Defined
Parameter Query Example

Section H: Action Queries

Action Query Defined
Enabling Active Content
Make-Table Query Example
Running an Action Query
Append-Table Query Example
Update Query Example
Update Query Errors
Run Update Query
Delete Query Example

Session 5

Section A: Reports

Building Reports
Report Button
Report Wizard
Reports from Scratch
Viewing Options

Section B: Report Formatting

Report Themes
Modifying Report Themes
Conditional Formatting
Expression Builder

Section C: Basic Report Design

Report Design Concepts
Adding Footer Information
Arranging Report Fields
Customizing a Report Layout
Adding Hyperlinks
Adding Charts

Section D: Grouping Data on Reports

Adding Totals to Reports
Adding Calculated Fields to Reports
Building an IF Statement

Section E: Controlling Page Layout

Report Layout Considerations
Working with Page Breaks
Using Print Preview
Modifying and Resizing Fields
Changing Page Size
Controlling Margins and Page Layout

Section F: Building Specialized Reports

Parameter Reports Defined
Building a Parameter Report
Enter a Different Parameter
Building a Mailing Labels Report
Building a Multi-Column Report