Microsoft Access Training in Denver Colorado
Whether your business uses Microsoft Access for tracking, reporting or sharing business information, Mission Critical Systems based in Denver Colorado, has the expertise to professionally train users to get the most out of this comprehensive database software. Building curriculum for both beginner users to advanced, students of MCS training courses gain efficiencies in the work place by implementing the comprehensive Access training that is offered by our professional training staff.
Sign up online using the training calendar, or call 303-383-1MCS for further information including on-site training of Microsoft Access
Microsoft Access Training for Beginners
- Training Class Goal: Designed to teach the basics of Access; understanding its various components and creating and using a simple database. This course is recommended for all levels, even for frequent 2003 Access users. It will focus on working with the new 2007 tools to learn the new way to accomplish tasks that might have been done with older Access or programs.
- Course Outline: Database concepts, Design vs. Datasheet view, database wizard, creating blank databases, creating tables, adding fields, identifying primary key fields, adding records, changing table designs, modifying field names, deleting and inserting fields, finding and editing records, sorting and filtering records, setting field properties, input masks, validation rules, indexes, creating Queries, filter queries, modifying query results, operations in queries, conditions (OR, AND), using calculators, Avg and Count functions, creating forms to enter data, formatting and customizing forms, using forms to find, sort and filter records, creating reports through the report wizard, field properties, using the Ribbon, navigating to accomplish tasks, Microsoft Office button.
- Prerequisite for Course: ability to use a mouse (click, double-click, right-click, click-and-drag) and ability to type on a keyboard, some use of another Microsoft Office application, such as Excel, to understand concepts like Ribbon and Office button.
Register for Microsoft Access Basic class online using our Training Calendar
|
 The instructor covered such a great range of topics and tied them all together very well and thoroughly. She was extremely pleasant and patient and answered and explained all questions happily – great instructor! I have now taken 2 courses with MCS and would highly recommend these courses!
|
|
Microsoft Access Training for Intermediate Users
- Training Class Goal: Learn how to develop more in-depth databases as well as additional tools to get more information out of your databases.
- Course Outline: Set table relationships, work with Lookup fields and sub datasheets, create join queries, create PivotTables and Pivot Charts, use hyperlink fields and data access pages, database normalization, implementing referential integrity, creating calculated fields, summarizing and grouping values, adding unbound controls, graphics, adding combo boxes, headers and footers, sub-reports, charts (in forms and reports).
- Prerequisite for Course: basic Access skills including: navigation, creating and using databases in both design and datasheet view, creating basic reports, queries and forms.
Register for Microsoft Access Basic class online using our Training Calendar
What’s New in Microsoft Office Access 2007?
The latest version of Microsoft Access is packed with features that help users create attractive templates, share data and build reports without deep database knowledge. Importing and exporting multiple file formats including Excel and text based files is easier than ever using Microsoft Access 2007.
|
