LearnKey Training

Access 2013 (77-424)

Access 2013 (77-424)

Back to Product Page

Access 2013 (77-424)

5 Sessions -
13 Hours of Interactive Training

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.

  • 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

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: 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