Databases
Microsoft Access
| Course Title: |
Access Level I |
Outline  |
| Description: |
Learn database concepts and terminology and how to navigate an existing database and use tables, forms, queries, and reports. Learn to add and edit table data, apply filters & sorts, and include a Total Row. Learn to create tables and how to control the type of data that is added to them. Learn about Primary Keys and Table Relationships. Learn how to create and use queries, design forms, develop reports, database development principles, relational concepts, and data validation techniques. |
| Audience: |
Designed for experienced PC users with limited database management experience. |
| Prerequisite: |
Office applications |
| Course Title: |
Access Level II  |
Outline |
| Description: |
Learn ways to streamline and customize Microsoft Access. Get started with a quick review of topics detailed in the Level I course such as creating tables, Primary Keys, table relationships, as well as query basics. Gain an understanding of join types and the affect they have on query answers. Learn to work with queries that update, delete, and add information to tables, as well as queries that create tables, and prompt the user for criteria. Learn to create reports based on tables and queries and format those reports. Learn to create data entry forms that include check boxes, drop-down lists, tab controls, and option buttons. In this class you will learn to create a user menu system and macros to control user navigation. |
| Audience: |
Designed for individuals familiar with Access fundamentals |
| Prerequisite: |
Microsoft Access Level I |
| Course Title: |
Access Level III - VBA |
Outline |
| Description: |
Delve deeper into creating and using macros for form and menu systems control. Also explore the Visual Basic for Applications (VBA) language. You will learn to use objects, events, properties, and methods as well as how to use variables, loops, If statements, case statements, and more. Learn to use VBA to manipulate objects and properties and make it easier for users to navigate and use your database. |
| Audience: |
Designed for individuals familiar with Access |
| Prerequisite: |
Microsoft Access Level II |
| Course Title: |
Access Queries |
Outline |
| Description: |
This class is designed for individuals interested in unleashing the power of Access queries. Topics include using criteria, more advanced table links, queries on queries, action queries, calculations in queries, and an introduction to SQL. |
| Audience: |
Individuals using Access to perform advanced data manipulation. |
| Prerequisite: |
Microsoft Access Level I. |
| Course Title: |
Access Reports |
Outline |
| Description: |
This class is designed for individuals interested in creating more powerful reports in Microsoft Access. Topics include report design, using queries with the report, performing calculations in reports, pictures and charts on reports, creating reports from multiple data sources, and creating sub-reports. |
| Audience: |
Individuals who want to expand their knowledge of creating reports in Microsoft Access. |
| Prerequisite: |
Microsoft Access Level I. |
| Course Title: |
Access Advanced Form Design |
Outline |
| Description: |
Students will learn advanced options for creating forms in a Microsoft Access database. Learn to design forms from scratch, add macros to forms, create a menu system so users can easily navigate the database, use forms as query criteria, learn to use various form controls, learn to use form properties, learn to add a Splash Screen to the database, and more. |
| Audience: |
Individuals who want to expand their knowledge of creating forms in Microsoft Access. |
| Prerequisite: |
Microsoft Access Level I |
Crystal Reports
| Course Title: |
Crystal Reports Level I |
Outline |
| Description: |
Designed for individuals new to Crystal Reports. In this 2-day course you will become familiar with the Crystal Reports interface. You will learn how to connect to the data the report will represent and then how to create reports using a wizard and from scratch. You will learn to format, sort, and filter those reports. You will learn to enhance the appearance of the report with graphics and drawn objects. You will learn how to sort and filter report data and how to organize report data into groups. You will also learn to create basic formulas and add them to the report. You will learn how to use conditional formatting, create reports based on Excel data, and how to export Crystal Reports to other file formats. |
| Audience: |
Designed for individuals with some knowledge of database management. |
| Prerequisite: |
Microsoft Access Introduction or similar database experience. |
| Course Title: |
Crystal Reports Level II |
Outline |
| Description: |
Learn more ways to streamline and customize your Crystal Reports. Use advanced formatting techniques, advanced formulas, and other tools to get the best results from your database. |
| Audience: |
Designed for users who want to explore more advanced features of Crystal Reports. |
| Prerequisite: |
Crystal Reports Introduction. |
FileMaker
| Course Title: |
FileMaker Introduction |
Outline |
| Description: |
Topics include: database development basics, field definitions, record management, using relationships, managing files, understanding formulas, expressions and constants, understanding layouts, object types, working in Browse mode, previewing and printing, and importing and exporting data. |
| Audience: |
Designed for individuals interested in learning FileMaker Pro basics. |
| Prerequisite: |
Windows Introduction. |
| Course Title: |
FileMaker Level II |
Outline |
| Description: |
Learn how to streamline your databases and use more advanced tools. |
| Audience: |
Designed for students who need more advanced training in FileMaker Pro. |
| Prerequisite: |
FileMaker Pro Introduction. |
Back to Course Categories
