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 2013
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
 
List Price: $130.00
Your Price: $97.00  (USD)
Savings: $33.00

LearnKey Online Course
5 Sessions / 13 Hours

Item No. 202931S
 

What's new in Access 2013? Along with a new look and similar features you used in Access 2010, you will be introduced to the new web apps feature. In Access 2013 you can design your own or use templates to create apps that can be shared with your coworkers or friends. LearnKey expert Jason Manibog will take you step-by-step through this course; starting with database management and navigation. Users will learn to use the tools provided in Access 2013 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 new web apps feature
  • Create and/or modify a simple Access database
 

Agenda/Course Outline ...

Session 1

Section A: Databases
  • What Is a Database?
  • Access Databases
  • Queries
  • Forms
  • Parts of Access Database
  • Tour of the Backstage View
  • Backstage View Recap
  • Get Help
  • Customize Quick Access Toolbar
Section B: Existing Data
  • Work with Existing Data
  • Adding Records to Labels
  • Updating Records
  • Deleting Records
  • Find Data
  • Replace Data
  • Sort Data
  • Filter Fields
  • Filter Multiple Fields
  • Filter Options
  • Add Row Totals
  • Change View
  • Run Queries
  • Forms
  • Reports
  • Navigation Options
Section C: Relational Databases
  • Flat vs. Relational Databases
  • Flat File
  • Relational Database
  • Rule 1
  • Rule 2
  • Rule 3
  • Rule 4
  • Rule 5
  • Identify Entities and Attributes
  • Planning a Database
  • Database Diagram

Session 2

Section A: Create a Database
  • Create Database with Template
  • Create Database with Wizard
  • Create Database in Old Format
  • Create a New Database
Section B: Create Tables
  • Create Tables in Datasheet View
  • Tables from Templates, Application Parts
  • Import Tables from Other Databases
  • Import External Data into Tables
  • Create Linked Tables from Other Sources
  • Create Tables in Design View
  • Format Tables, Hide Fields in Tables
  • Add Table Descriptions
  • Rename Tables
Section C: Create and Modify Fields
  • Table Views
  • Unique Values
  • Test Fields
  • Set Primary Key Fields, Auto Increment
  • Change Field Captions
  • Change Field Sizes
  • Change Field Data Types
  • Change Data Formats
  • Set Default Values
  • Require Value in Fields
  • Use of Input Masks
  • Validation Rules
  • Delete Fields
Section D: Manage Table Relationships
  • Create Field Lookups
  • Lookup Tips
  • Edit Reference between Tables
  • View Relationships
  • Create Relationships
  • Relationship Types
  • Edit Relationships
  • Enforce Referential Integrity
  • Modify Relationships

Session 3

Section A: Create Forms
  • Introduction to Creating Forms
  • Creating a Form
  • Create Form with Wizard
  • Split Forms and Blank Forms
  • Create Forms with Application Parts
  • Modify Forms
  • Layout View vs. Design View
  • Prebuilt Form Layouts
  • Manage Labels
  • Move Form Controls
  • Make Multiple Selections
  • Arrange Items in Forms
  • Work with Form Layouts
Section B: Enhance Forms
  • Insert Headers and Footers
  • Add Form Controls
  • Add a Button
  • Set Form Control Properties
  • Remove Form Controls
Section C: Organize Forms
  • Organizing a Form
  • Modify Tab Order in Forms
  • Modify Data Sources
  • Add Subforms
Section D: Format Forms
  • Format Forms, Apply Themes
  • Insert Backgrounds
  • Insert Images
  • Sort Records
  • Format Printing Layouts, Change Margins
Section E: Navigation Forms
  • Work with and Create Navigation Forms
  • Format Navigation Forms

Session 4

Section A: Queries
  • Purpose of Queries
  • Create Queries
  • Add Fields and Save Queries
Section B: Modify Queries
  • Hide and Remove Fields
  • Rename and Delete Queries
  • Modify and Sort Queries
  • Format Fields in Queries
Section C: Multitable Queries
  • Create Multitable Queries
  • Inner and Outer Joins
Section D: Criteria in Queries
  • Types of Criteria in Queries
  • Use Criteria in Queries
  • Use AND and OR in Queries
  • Use IN in Queries
  • Use NOT and BETWEEN in Queries
  • Use NULL in Queries
  • Use Wildcards in Queries
  • Use Parameters in Queries
Section E: Calculations in Queries
  • Calculated Fields
  • Expression Builder
  • Text Calculation
  • Numeric Calculation
  • Group and Summarize Data
  • Crosstab Queries
  • Return Top Result
Section F: Action Queries
  • Use Action Queries
  • Make Table Query
  • Append Query
  • Update Query
  • Delete Query
  • Recap Action Queries

Session 5

Section A: Create Reports
  • Build Reports
  • Create New Reports
  • Group Reports
  • Create Reports with Application Parts
Section B: Modify Reports
  • Modify Existing Reports
  • Manage Labels
  • Add Report Controls
  • Add Calculated Fields
  • Group Data by Fields
  • Sort Data
  • Change Sort Order
  • Modify Data Sources
Section C: Reports
  • Format Reports
  • Apply Themes and Add Backgrounds
  • Insert Images
  • Insert Headers and Footers
  • Insert Page Numbers
  • Format Reports into Multiple Columns
Section D: Print and Distribute Reports
  • Print and Distribute
  • Change Report Orientation
  • Set Margins
  • Print Reports
  • Export Data to Alternate Formats
  • Save and Run Export
  • Delete Reports
Section E: Finalize
  • Finalize Database
  • Setting a Form as a Startup Option
  • Saving Databases as Templates
  • Saving Databases to External Locations
  • Maintain Backward Compatibility
Section F: Protection
  • Protect a Database
  • Split Databases
  • Merge Databases
  • Encrypt Databases
Section G: Database Maintenance
  • Maintain a Database
  • Backup Database
  • Recover Data from Backups
  • Compact and Repair Database
Section H: Tips
  • Test Taking Tips
  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