TC2 is pleased to announce the following training opportunity. If you wish to attend, please contact Jeanne Glauser jglauser@tcwib.net for more information and to register.

Course Outline
Fundamentals of Relational Databases and Microsoft Access
Summary:
This class is conglomeration of five individual classes. The summary of the five parts is as follows
1. At work, storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a simple relational database application and its associated tools. You have used databases to store and retrieve data. Now, you may want to plan and design your own database. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying relational database design techniques.
2. Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access 2007 relational database application.
3. 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.
4. Your training in and use of Microsoft Office Access 2007 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. 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.
5. In previous levels, you were introduced to the various features of Microsoft Office Access 2007 that dealt with local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
Duration:
5 Days/Lecture & Lab
Audience:
This course is designed for students who wish to learn relational database fundamentals and specifically operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes.
Topics:
Upon successful completion of this course, students will be able to:

• Analyze client requirements.
• Create a preliminary design.
• Implement the database design.
• Generate reports.
• Customize a database.
• Examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
• Design a simple database.
• Build a new database with related tables.
• Manage data in a table.
• Query a database using different methods.
• Design forms.
• Generate reports.
• Modify the design and field properties of a table to streamline data entry and maintain data integrity.
• Retrieve data from tables using joins.
• Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
• Enhance the capabilities of a form by grouping form controls and making other aesthetic improvements to make forms work more efficiently and intuitively for the user.
• Customize reports to organize the displayed information and produce specific print layouts.
• Share data across different applications.
• Restructure data into appropriate tables to ensure data dependency and minimize redundancy.
• Write advanced queries to analyze and summarize data.
• Create and revise Microsoft Office Access 2007 macros.
• Display data more effectively in a form.
• Customize reports by using various Microsoft Office Access 2007 features, making them more effective.
• Maintain your database using tools provided by Microsoft Office Access 2007.
• Share Access data with other applications.
• Use VBA to automate a business process.
• Create and modify a database switchboard, and set the startup options.
• Secure databases.
• Share databases using a SharePoint site.

Prerequisites:
Students should have user, operator or administrator experience on common operating systems such as Windows XP, Vista, Windows 7, as well as experience working with Microsoft Office applications