Databases are designed to maintain and manage large amounts of information. Access can be used to develop tables, make relationships between the tables, create queries to extract related information, develop forms to make input easier, and create reports for viewing the end result. As more sophisticated development is necessary, the use of Visual Basic programming may be needed.
The following classes are available
Access 2003 101: Intro to Databases
Learn the basics of database management by creating and modifying tables, creating and running queries, designing forms and generating reports. Our 2-day format engages students in business-oriented case studies addressing database design, creation, querying and reporting. Students will work together in teams to solve real-world problems as they learn to work with the many features of Access.
Available dates and detailed description
Access 2003 102: Intermediate Topics
Students will learn intermediate Access skills including how to enhance database design by using the principles of table relationships and referential integrity. Learn to integrate data with other applications, modify a table design to control data entry, find data with filters, queries, customize forms and reports and create data access pages.
Available dates and detailed description
Access 2003 104: Macros & Advanced Topics
Students will learn to use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros and automate tasks, enhance forms and reports, and use Access data in other Office applications. Students whose job responsibilities include working with heavily related tables, creating advanced queries and reports, writing macros are encouraged to take this course.
Available dates and detailed description
Access 2003 105: Application Development & VBA
This class will cover Application Development & VBA programming. Students will learn to customize an access database and provide many functional features. Students can use VBA to create pull down menus, prompt, and add security. Many features are available using VBA.
Available dates and detailed description
Access 2007: Level 1 - Creating Databases
In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Access 2007 relational database application.
Available dates and detailed description
Access 2007: Level 2 - Queries, Forms & Reports
You have the basic skills needed to work with Microsoft Office Access 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
Available dates and detailed description
Access 2007: Level 3 - Advanced Queries & Macros
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
Available dates and detailed description
Access 2007: Level 4 - Application Development & VBA
Available dates and detailed description
Migrating to Access 2007
This 90-minute ExecuTrain Express course is designed for current Access users who are migrating to Access 2007. Class participants will learn how to take advantage of new tools and interface elements to speed up database creation and editing task. For example, creating new forms and reports become considerably easier in an Access 2007 with two new WYSIWYG (What You See Is What You Get) Design tools. Students should take this class after completing the 90-minute Migrate to Office 2007 course.
Available dates and detailed description