Questions? 1.800.258.7246
home  |  about us  |  view cart  |  search
A division of Rockhurst University Continuing Education Center, Inc.
National Seminars Training - Your Complete Learning Center
SEMINAR FINDER
State:
ZIP:
Sign Up for Emails or Special Offers
Email:
ZIP:
  Access 2007
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
 
Your Price: $225.00  (USD)
CD-ROM 5 Sessions, 15 Hours
Item No. 201188
 

Relational databases are a critical component of our electronic society, and now creating, maintaining, and utilizing them are even easier. In the Access 2007 course from LearnKey, you’ll learn how the ribbon makes it easier to find the exact tool you need and how easy it is to synchronize your database with SharePoint Servers. Expert Erin Olsen takes you step by step through newly designed database templates, from management and security of data to presentation and data sharing. At the conclusion of this course, you’ll be organizing, retrieving, and sharing data easily.

Benefits:

• Gain valuable database management skills.
• Acquire leverage to better career opportunities.
• Learn the latest information technology.

 

Session 1

Section A: Understanding Access
· What Is Access?
· Access vs. Excel
· Components, Objects, and Terms
· Changes In 2007

Section B: Getting Started
· Application Overview
· Using Templates
· Using the Ribbon
· The Navigation Pane
· Shortcut to Forms

· Finding Help


Section C: Using the Navigation Pane Effectively
· Group View Options
· Item View Options
· Organizing Items
· Navigation Options
· Table Views
· Query and Form Views
· Report and Macro Views


Section D: Data Entry
· Working With Records
· Entering and Editing Records Data
· Deleting Records
· Sorting Data In Records
· Finding Data in Records
· Entering Data In Forms


Section E: Database Design
· Design Steps
· Purpose
· Tables
· Fields
· Relationships
· Primary Key
· Making the Relationship
· Naming Conventions
· Design Cleanup
· Example: Purpose and Tables
· Example: Primary Key and Relationships


Section F: Creating Databases and Tables
· Create Blank Database
· Datasheet View
· Saving Tables
· Table Templates


Session 2
Section A: Working With Tables
· Design View
· Text and Memo Data Types
· Number Data Types
· AutoNumber Data Types
· Yes/No Data Types
· Data Beyond the Database
· Creating Tables
· Setting Primary Keys

Section B: Field Properties
· Field Properties Overview
· Modifying Fields
· Text Field Properties
· Number Field Properties
· Validation Rules

· Arranging and Deleting Fields
· Viewing Changes
· Validation Text
· More Field Properties
· Memo Fields
· Attachment Fields
· Input Masks


Section C: Lookup Fields
· Creating Lookups
· Design View Lookups
· Lookup Properties


Section D: Relationship Theory
· Relationship Basics
· Beyond Relationship Basics
· Relationship Types
· Putting Relationship Theory Together


Section E: Creating Relationships
· Viewing Relationships
· Building and Modifying Relationships
· Relationship Reports
· Joining Table Properties


Section F: Analyzing Design
· Cleaning Up
· Formatting Datasheets
· Hiding Columns
· Rearranging Fields
· Performance Analyzer


Section G: Subdatasheets and Filters
· Adding Subdatasheets
· Subdatasheet Display
· Removing Subdatasheets
· Filtering by Selection
· Number Filtering
· Filtering by Form
· Advanced Filters
· Total Row Summaries


Session 3
Section A: Query Basics
· Query Wizard
· Selecting Data Sources
· Selecting Fields
· Sorting Fields
· Arranging Fields
· Criteria
· Comparison Criteria
· Range Criteria

Section B: Intermediate Queries
· Field Properties
· Query Properties

· Unique List
· Outputting All Fields
· Removing Tables
· Multiple Table Queries
· Query Relationships


Section C: Calculation in Queries
· Adding Fields
· Calculation Fields
· Null Values
· Totals
· Expression Builder


Section D: Special Queries
· Crosstab Queries
· Modifying Crosstab Queries
· Finding Duplicate Records
· Finding Unmatched Records
· Parameter Queries
· Range Parameters
· SQL View


Section E: Action Queries
· Updating Queries
· Creating Table Copies
· Creating Table Queries
· Saving Action Queries
· Archiving Records
· Deleting Queries
· Deleting Tables


Section F: Concatenation
· What Is Concatenation?
· Concatenating Data
· Reviewing Concatenation
· Concatenation Examples


Session 4
Section A: Importing/Exporting Data
· Importing Data
· Importing Objects
· Importing From Excel
· Making Changes
· Exporting Data
· Add-Ins
· Save as PDF or XPS


Section B: Using Mail Merge
· Introduction
· Mail Merge Wizard
· Creating a Merge Letter
· Sharing Outlook Contacts
· Importing Outlook Folders
· Collaboration

Section C: Basic Forms
· Lookup Tables
· Form Wizard
· Form Tools
· Layout View


Section D: Form Controls
· Design View
· Controls
· Move Controls
· Selecting Multiple Controls
· Arranging Controls


Section E: Form Design
· Font Formatting
· Conditional Formatting
· Control Types
· Query by Form
· Check Boxes
· Bind Controls
· Properties


Section F: Special Forms
· Split Forms
· Subforms
· Subform Relationships
· Creating Subforms
· PivotTable Forms
· Calculations
· Filtering PivotTables


Section G: Reports
· AutoReports
· Report Wizard
· Grouping and Sorting
· Adding Pictures
· Page Breaks
· Label Wizard
· Charts


Session 5
Section A: Controlling Display and Data Entry
· Form Properties
· Display Options
· Data Entry Options
· Lock Controls
· Bang and Dot Operator
· Query Aliases
· Query Parameters
· Dynamic Reports

Section B: Access Automation
· Remove Grouping
· Control Wizard
· Switchboard Manager
· Edit Switchboard Pages

· Edit Main Switchboard
· Customize Switchboards


Section C: Custom Automation
· Overview
· Unbound Forms
· Add Record
· Message Box
· Close Form
· Close Database
· Modal Dialog Form


Section D: Working With the File
· Custom Navigation Pane
· Arranging Objects
· Database Properties
· Access Options
· Current Database Options
· Compact and Repair
· Back Up Database
· Database Splitter
· Linked Table Manager


Section E: Security
· Security Types
· Password Protection
· User-Level Permissions
· Creating User-Level Permissions
· Security Tips


Section F: Sharing Information
· Printing Tables
· Printing Forms
· Printing Reports
· Output as File
· Database Documenter
· Save as Previous Version




  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
 
FIFA 14 Coins,FIFA Coins,FIFA 14 Coins,FIFA Coins,Replica Handbags,Replica Bags,Sexy Lingerie,Cheap Sexy Lingerie,FIFA 14 Coins,FIFA Coins,Wedding Dresses,Evening Dresses,Tattoo Supplies,Tattoo Kits,Iphone 5s case,Ipad air case,Wedding Dresses,Evening Dresses,Fashion Shoes,Fashion Clothing,Wedding Dresses,Evening Dresses