Questions?

1.800.258.7246


home  |  about us  |  view cart  |  search

Follow us on: FacebookTwitterGoogle+LinkedIn
National Seminars Training - Your Complete Learning Center SEMINAR FINDER
State:
ZIP:
Sign Up for Emails or Special Offers
Email:
ZIP:
  Access 2010
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
 
List Price: $130.00
Your Price: $97.00  (USD)
Savings: $33.00

LearnKey Online Course
5 Sessions / 13 Hours

Item No. 202331S
 

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
 

Agenda/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 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
  Order online here on our secure Web site, call us toll
free at 1-800-258-7246 or fax us at 1-913-432-0824.



100% Guarantee!
Customer satisfaction is our #1 priority. If you are not satisfied with your purchase for any reason, return it to us within 60 days, and we will refund your money in full! No questions asked.





All transactions are processed through an encrypted secure socket layer (SSL).
See our privacy policy
 
National Seminars Training
1.800.258.7246