Instructor Led Queries Training Classes in Canada

Microsoft Access XP 2003 Level 3 Objectives: * Explain 3 steps to normalize a database * Explain 3 types of database relationships * Use the Table Analyzer Wizard * Explain query join properties * Create command buttons on a form and attach macros * Create action queries * And much, much more...  more...

Access 2003 - Level 2 1 Day ...ween tables and within a single table. - create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries. - enhance the appearance, data entry, and data access capabilities of your forms. - customize reports to better organize the displayed information and produce specific print layouts such as mailing labels. -  more...

Microsoft Access XP 2003 Level 2 Objectives * Creating Relationships Between Tables * Understanding Relationship Types * Understanding the Different Types of Queries * Creating a Form with AutoForm * Creating and Modifying a Report * Adding and Deleting Fields * Creating Charts with Chart Wizard  more...

MS Access Level 1 Training Seminar This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and  more...

Access Training Intermediate Level Upon completion of this course, participants will be familiar with advanced Table Design. They will also be more comfortable using complex queries, forms and reports. Participants will also receive a certificate of completion.  more...

Access 2007 - Level 3 (1 Day) The Level 3 course is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2007, and it is  more...

Microsoft Access Introduction (2 Days) Microsoft Access is a relational database management system from Microsoft which combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the Microsoft Office system. In this 2-day introductory course for Microsoft Access, users will learn: The Basics Table Data Table Design Data Entry Relationships Creating And Using  more...

Microsoft Access 2003 - Level 2 As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database  more...

Access 2003 Queries (2 Days) This course takes a close look at Access Query building. We start with basic query concepts (review from Introduction), then look at some of the more advanced query features. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Access 2007 - Level 2 (1 Day) As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database  more...

Access 2003 - Level 3 (1 Day) This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Office Access 2003 database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.  more...

Access 2003 Intermediate Level 1 (3 Days) This course builds on the two-day Introduction course. The objective is to learn enough about Access to start developing databases. The Introduction course begins this process by seeing how to create tables and queries. This course illustrates how to create a relational database and how to design forms and reports. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Access 2003 Introduction 2 Days This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Access Introduction - Level 1 This course provides competency in database fundamentals, working with Access objects, creating databases and tables, working with table data and structure, locating information, working with related tables, using select queries and advanced query features, and creating advanced queries.  more...

Microsoft Access 2003 XP Level I II This course covers table creation, relationships, extracting information using queries, designing forms and creating reports. Advanced queries including action queries, advanced forms and reports including sub forms and sub reports, import/export, and macros will also be covered.  more...

Microsoft Access 2007 - Module 1 Basic 2 Days Objectives * Understand data base architecture and its components * Opening, closing data base and handling objects * Knowledge about table structure * Creating single queries * Creating single form and report  more...

Microsoft Access - Module 2 - Multi Table queries and relations This course is the second of seven modules (levels) that we have to offer for Microsoft Access 2000/2002/2003. Objectives * Fundamental Principles of data base * Creating multi tables queries * Working with formula and functions * Knowledge about relations * Applying referential Integrity  more...

Microsoft Access - Module 1 Basic 2 Days Objectives * Understand data base architecture and its components * Opening, closing data base and handling objects * Knowledge about table structure * Creating single queries * Creating single form and report  more...

Microsoft Access 2003 - Level 2 Location: Calgary Date: 2008-05-15 List Price: $325 Offered Price: $260.00 Seats Available: 2 Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports;  more...

SQL Advanced ...n completion of this course, students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes. Students enrolling in this course should understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins. For more information  more...

SQL Fundamentals of Querying Location: Winnipeg Date: 2008-05-14 List Price: $159 Offered Price: $127.00 Seats Available: 2 Upon successful completion of this course, students will be able to: * Define what a relational database is and identify some uses for the SQL language. * Recognize proper syntax for an SQL statement. * Use aggregate functions, column aliases, and mathematical expressions in a query statement. * Use  more...

Microsoft Access Level 1 Training Seminar (2 Days) ... Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and reports, and create data access pages. For more information please call  more...

Microsoft Access 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-03-18 List Price: $279 Offered Price: $195.00 Seats Available: 2 Make more informed decisions by effectively tracking, reporting, and sharing information. With its Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge, Microsoft Office Access helps you track and report information with ease. By the  more...

Microsoft Access 2003 Level 2 - English Location: Ottawa Date: 2008-02-14 List Price: $600 Offered Price: $480.00 Seats Available: 2 Module 0: Modifying Tables Module 1: Setting Field Properties Module 2: Using Operators In Queries Module 3: Designing Advanced Queries Module 4: Creating Action Queries Module 5: Using Advanced Query Wizards Module 6: Using Advanced Database Features Module 7: Manipulating Controls Module 8:  more...

MS Access Level 1 Training Seminar Location: City of Mississauga Date: 2007-07-16 List Price: $495 Offered Price: $346.00 Seats Available: 2 This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other  more...

Access Introduction-2 Days Location: Toronto Date: 2007-07-05 List Price: $550 Offered Price: $350.00 Seats Available: 2 This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided.  more...

Access Queries-2 Days Location: Town of Newmarket Date: 2007-04-26 List Price: $550 Offered Price: $385.00 Seats Available: 5 This course takes a close look at Access Query building. We start with basic query concepts (review from Introduction), then look at some of the more advanced query features.  more...

Access Intermediate Level 2-2 Days Location: City of Mississauga Date: 2007-04-23 List Price: $550 Offered Price: $385.00 Seats Available: 5 This two-day course picks up where the Intermediate Level I leaves off. The objective is to become more comfortable with relating tables, as well as looking further at forms, reports and queries.  more...

Access Intermediate Level 1-3 Days Location: City of Mississauga Date: 2007-04-18 List Price: $825 Offered Price: $525.00 Seats Available: 5 This course builds on the two-day Introduction course. The objective is to learn enough about Access to start developing databases. The Introduction course begins this process by seeing how to create tables and queries. This course illustrates how to create a relational database and how  more...

MS Access Level 1 Training Seminar Location: City of Mississauga Date: 2007-04-25 List Price: $495 Offered Price: $346.00 Seats Available: 2 This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other  more...

Microsoft Access 2002 (XP) Level I Location: Toronto Date: 2007-04-16 List Price: $80 Offered Price: $56.00 Seats Available: 2 This course covers table creation, relationships, extracting information using queries, designing forms and creating reports.  more...

Access Queries-2 Days Location: Toronto Date: 2007-04-12 List Price: $550 Offered Price: $385.00 Seats Available: 5 This course takes a close look at Access Query building. We start with basic query concepts (review from Introduction), then look at some of the more advanced query features.  more...

Access Intermediate Level 2-2 Days March 19-20, 2007 9:00am - 4:00pm This two-day course picks up where the Intermediate Level I leaves off. The objective is to become more comfortable with relating tables, as well as looking further at forms, reports and queries. This course is classroom style instruction: Instructor-led, hands-on training.  more...

Access Introduction-2 Days April 2-3, 2007 9:00am to 4:00pm This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided. This course is classroom style instruction: Instructor-led,  more...

Access Introduction-2 Days April 9-10, 2007 9:00am-4:00pm This course provides the first step in learning how to use this powerful database program. The objective is to provide participants with an understanding of Table design, entering data, and building Queries to manipulate data. Forms and Reports are briefly introduced using the Wizards provided.  more...