Microsoft Access

Register for Microsoft Access Training now!

BCT120 Microsoft Access Basic 2003

The student will be able to create and work with database functions. The student will be able to format data as well as work with tables and fields.

BCT121 Microsoft Access Intermediate 2003

The student will be able to create relational databases along with working with queries. The student will also be able to work with forms and reports upon completion.
Prerequisite/Core requisite: BCT120 Microsoft Access Basic 2003

BCT122 Microsoft Access Advanced 2003

The student will be able format forms and reports as well as work with macros. The student will also be able to import objects from other access databases, export to word, merge records to word as well as other advanced topics.
Prerequisite/Core requisite: BCT122 Microsoft Access Int 2003

BCT040 Microsoft Access Basic 2007

The student will be able to create and work with database functions. The student will be able to format data as well as work with tables and fields.

BCT045 Microsoft Access Intermediate 2007

The student will be able to create relational databases along with working with queries. The student will also be able to work with forms and reports upon completion.
Prerequisite/Core requisite: BCT040 Microsoft Access Basic 2007

BCT050 Microsoft Access Advanced 2007

The student will be able format forms and reports as well as work with macros. The student will also be able to import objects from other access databases, export to word, merge records to word as well as other advanced topics.
Prerequisite/Core requisite: BCT045 Microsoft Access Int 2007

BCTxxx Microsoft Access 2010 Basic

Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and set field properties and data entry rules; and create queries, forms, and reports.

BCTxxx Microsoft Access 2010 Intermediate

Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and sub-data sheets; 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.

BCTxxx Microsoft Access 2010 Advanced

Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; and password-protect and encrypt databases.

Register for Microsoft Access Training now!

Comments on this entry are closed.