Microsoft Access 2010 Intermediate Onsite Group Training Course

Microsoft Access 2010 Intermediate - Syllabus

Working with Tables and Fields
Understanding Field Properties
Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Adding Field Descriptions and Captions
Changing the Field Size
Formatting Number, Currency, and Date/Time Fields
Formatting Number, Currency, and Date/Time Fields by Hand
Formatting Text Fields
Setting a Default Value
Requiring Data Entry
Validating Data
Creating an Input Mask
Creating a Lookup Field
Creating a Value List
Modifying a Lookup List
Working with Tables and Fields Review

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 IIf 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 Subform
Modifying and Working with Subforms
Working with Forms 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 Intermediate
• Microsoft Access 2013 Introduction
• Microsoft Access 2010 Advanced
• Microsoft Access 2010 Introduction

Microsoft Value Pack (Best Deal)