Access 2003 - Basic
-
2
day(s)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches the basic functions and features of Access 2003. Students will learn how to plan and create a database, work with tables, create queries and forms, filter records, and generate reports. This course is approved courseware for Microsoft Office Specialist certification. Comes with CertBlaster exam prep software (download) and access to an online e-Learning program.
|
Access 2003 - Intermediate
-
2
day(s)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches intermediate-level features and functions of Access 2003. Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages. This course is approved courseware for Microsoft Office Specialist certification. Comes with CertBlaster exam prep software (download) and access to an online e-Learning program.
|
Access 2003 - Advanced
-
1
day(s)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, teaches advanced-level functions and features of Access 2003. Students will learn how to: query with SQL; use crosstab, parameter, and action queries; create and run macros; import, export, and link database objects; optimize, replicate, and synchronize databases; and maintain database security. This course is approved courseware for Microsoft Office Specialist certification. Comes with CertBlaster exam prep software (download) and access to an online e-Learning program.
|
Access 2007 - Basic
-
2
day(s)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Comes with CertBlaster exam prep software (download) and access to an online e-Learning program. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.
|
Access 2007 - Intermediate
-
2
day(s)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2007: Basic. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Comes with CertBlaster exam prep software (download) and access to an online e-Learning program. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.
|
Access 2007 - Advanced
-
1
day(s)
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2007: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data. Comes with CertBlaster exam prep software (download) and access to an online e-Learning program. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.
|
Access 2010 - Basic
-
2
day(s)
This ILT Series course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.
|
Access 2010 - Intermediate
-
2
day(s)
This ILT Series course builds on the skills and concepts taught in Access 2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
|