Microsoft Access 2013 Intermediate Onsite Group Training Course

Creating Relational Databases

• Understanding Table Relationships
• Creating Relationships Between Tables
• Enforcing Referential Integrity
• Printing and Deleting Relationships
• Understanding Relationship Types
• Creating Relational Databases Review

Working with Queries

• Understanding Different Types of Queries
• Creating a Multiple Table Query
• Creating a Calculated Field
• Working with Expressions and the Expression Builder
• Using an If Function
• Summarizing Groups of Records
• Display Top or Bottom Values
• Parameter Queries
• Finding Duplicate Records
• Finding Unmatched Records
• Crosstab Queries
• Delete Queries
• Append Queries
• Make-Table Queries
• Update Queries
• Working with Queries Review

Working with Forms

• Creating and Using a Form
• Understanding Form Views
• Modifying a Form in Layout View
• Form Design View Basics
• Changing Tab Order
• Working with Control Properties
• Control Property Reference
• Working with Form Properties
• Form Property Reference
• Changing a Control’s Data Source
• Creating a Calculated Control
• Changing a Control’s Default Value
• Creating a Sub form
• Modifying and Working with Sub forms
• Working with Forms Review

Working with Reports

• Creating a Report
• Working in Layout View
• Adding a Logo
• Working in Design View
• Adjusting Page Margins and Orientation
• Adding Page Numbers and Dates
• Grouping and Sorting
• Summarize Data using Totals
• Understanding Report Sections
• Working with Reports Review

Formatting Forms and Reports

• Formatting Fonts
• Changing Text Alignment
• Changing Colors
• Using Conditional Formatting
• Adding Pictures, Lines and Gridlines
• Working with Number Formatting
• Using Themes
• Formatting Forms and Reports Review

Additional Topics

• Importing Information
• Exporting Information
• Linking Information from an External Source
• Using Hyperlink Fields
• Displaying Database Object Dependencies
• Setting a Password in Access
• Compacting and Repairing a Database
• Additional Topics Review

• Discuss your team's educational needs with a BCS representative.
• Schedule class date(s) that fit your team's availabilty.
• Professional Trainer will conduct the class at your facility or online.
• We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
• You provide the meeting/conference room, student xomputers with correct software installed and a projector for the instructor to use.
• Usually a two-week lead time to schedule a class.
• Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
• 1 Hour Lunch Break, and Two 15-minute Break

• A Professional Instructor will come to your office and train your students
• Up to 6 students can attend the class for the flat rate course price of $1800/day
• Additional students can be added for $125/person/day
• Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
• Course is scheduled based on dates you provide (Subject to instructor availability)
• We usually require about 2-weeks lead time to arrange a training session
• Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
• Two 15 minute breaks and one hour long break for lunch

• A Professional Instructor will come to your office and train your students
• Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
• Additional students can be added for $100/person/day
• Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
• Course is scheduled based on dates you provide (Subject to instructor availability)
• We usually require about 2-weeks lead time to arrange a training session
• Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
• Two 15 minute breaks and one hour long break for lunch

• A Professional Instructor will come to your office and train your students
• Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
• Additional students can be added for $75/person/day
• Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
• Course is scheduled based on dates you provide (Subject to instructor availability)
• We usually require about 2-weeks lead time to arrange a training session
• Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
• Two 15 minute breaks and one hour long break for lunch

• Microsoft Access 2016 Advanced
• Microsoft Access 2016 Introduction
• Microsoft Access 2013 Advanced
• Microsoft Access 2013 Introduction
• Microsoft Access 2010 Advanced
• Microsoft Access 2010 Intermediate
• Microsoft Access 2010 Introduction

Microsoft Value Pack (Best Deal)