LearnKey Training

Access 2010 Course (77-885)

Access 2010 Course (77-885)


Access 2010 Course (77-885)

5 Sessions -
13 Hours of Interactive Training

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 LearnKey's 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

About The Author
Jason Manibog, LearnKey’s senior instructor, has spent over 15 years in the Information Technology arena as a trainer, consultant, and courseware writer. Jason is a Microsoft Certified Trainer with multiple certifications in Microsoft, CompTIA, and Adobe. Jason brings a wealth of real-world experience and the ability to explain things in very practical, real-life like terms to any class he teaches, courseware he writes, or e-Learning courses he develops.

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 Color
  • 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 Paramenter
  • Building a Mailing Labels Report
  • Building a Multi-Column Report

Section G: Introduction to Macros

  • Macros Defined
  • Form Data Validation Macros
  • Report Data Validation Macros
  • Table Data Validation Macros

Section H: Finalizing the Database

  • Exporting the Database
  • Saving Export Steps
  • Publishing the Database
  • Saving the Database as a Template