Microsoft Access training provides a powerful set of tools that are sophisticated enough for professional data managers, yet easy to learn for new users interested in storing and accessing large amounts of data.  This is often the next step in data management after Excel has maximized its potential to connect information.  While the entire first day of Access training focuses on tables, or how the data is stored. The introductory course also offers participants the opportunity to explore what a Database can do, how it may be applied and best practices to ensure the database scales up.  During the second half of the class, many issues common to new database developers, such as relationships, are identified and resolved.  This course is recommended for anyone new to Microsoft Access.

Microsoft Access Training: Introduction
Module 1: Introduction to Access & Creating Tables		Module 2: Working with Relationships & Tables
Introduction to database design concepts & terminology Become familiar with the Access 2010 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips Open and examine and existing Access database Working with tables and data records Find, sort and filter records in a table Introduction to table creation options Create tables using the design view Using the Data Type Gallery Introduction to table field properties		Relational database design concepts Create table relationships Explore relationship types Define referential integrity Display object dependencies How to “Normalize” databases Additional table field properties Create a lookup list
Sign up to view this video		Sign up to view this video
Microsoft Access Training: Intermediate
Module 3: Queries		Module 4: Additional Queries, & Importing/Exporting Objects & Data
Create select queries Use criteria to refine query results Create multi-table queries Create query joins Implement query parameters Performing calculations in a query		Create a totals queries Create crosstab queries Create Action Queries Import/export data Linking tables from one database to another Overview of importing data from Microsoft Outlook Overview of the collecting data via email feature
Sign up to view this video		Sign up to view this video
Microsoft Access Training: Advanced
Module 5: Creating Forms		Module 6: Creating Reports
Creating an AutoForm Using the Form Wizard to design new forms Add and modify form controls Using Office Themes Adding images and titles Create calculated controls Work with control properties Create forms in design view Creating Forms with Sub-forms Create tabbed forms		Using the Report Wizard to create new Reports Modify report's page setup settings Modify report design and layout Work with report sections Create summary functions Create reports in design view Use the Mailing Labels Wizard
Sign up to view this video		Sign up to view this video
Microsoft Access Training: Advanced II
Module 7: Automating Access Databases		Module 8: DB Maintenance and Deployment
Create macros Implement and run macros Creating table macros Event driven macros Setting database startup options Introduction to VBA concepts and terminology		Create switchboards Discuss deploying Access databases in a multi-user environment Explore Microsoft Access security features Compact and repair databases Using hyperlinks in an Access database
Sign up to view this video		Sign up to view this video

Microsoft Access training provides a powerful set of tools that are sophisticated enough for professional data managers, yet easy to learn for new users interested in storing and accessing large amounts of data.  This is often the next step in data management after Excel has maximized its potential to connect information.  While the entire first day of Access training focuses on tables, or how the data is stored. The introductory course also offers participants the opportunity to explore what a Database can do, how it may be applied and best practices to ensure the database scales up.  During the second half of the class, many issues common to new database developers, such as relationships, are identified and resolved.  This course is recommended for anyone new to Microsoft Access.

Microsoft Access Training: Introduction
Module 1: Introduction to Access & Creating Tables		Module 2: Working with Relationships & Tables
Introduction to database design concepts & terminology Become familiar with the Access 2010 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips Open and examine and existing Access database Working with tables and data records Find, sort and filter records in a table Introduction to table creation options Create tables using the design view Using the Data Type Gallery Introduction to table field properties		Relational database design concepts Create table relationships Explore relationship types Define referential integrity Display object dependencies How to “Normalize” databases Additional table field properties Create a lookup list
Sign up to view this video		Sign up to view this video
Microsoft Access Training: Intermediate
Module 3: Queries		Module 4: Additional Queries, & Importing/Exporting Objects & Data
Create select queries Use criteria to refine query results Create multi-table queries Create query joins Implement query parameters Performing calculations in a query		Create a totals queries Create crosstab queries Create Action Queries Import/export data Linking tables from one database to another Overview of importing data from Microsoft Outlook Overview of the collecting data via email feature
Sign up to view this video		Sign up to view this video
Microsoft Access Training: Advanced
Module 5: Creating Forms		Module 6: Creating Reports
Creating an AutoForm Using the Form Wizard to design new forms Add and modify form controls Using Office Themes Adding images and titles Create calculated controls Work with control properties Create forms in design view Creating Forms with Sub-forms Create tabbed forms		Using the Report Wizard to create new Reports Modify report's page setup settings Modify report design and layout Work with report sections Create summary functions Create reports in design view Use the Mailing Labels Wizard
Sign up to view this video		Sign up to view this video
Microsoft Access Training: Advanced II
Module 7: Automating Access Databases		Module 8: DB Maintenance and Deployment
Create macros Implement and run macros Creating table macros Event driven macros Setting database startup options Introduction to VBA concepts and terminology		Create switchboards Discuss deploying Access databases in a multi-user environment Explore Microsoft Access security features Compact and repair databases Using hyperlinks in an Access database
Sign up to view this video		Sign up to view this video

There are no prerequisites for this series. However, Excel training is reccomended through advanced levels. Access is an advanced database application. Excel training will introduce you to concepts and working in tables.