151 Water St. Augusta, ME 04330   207-623-2700   info@capcomp.com

Loading Events

« All Events

  • This event has passed.

Access Advanced 2010

September 27 @ 9:00 am - 4:00 pm


COURSE DESCRIPTION: This ILT Series course builds on the skills and concepts taught in Access 2010: Intermediate. 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; password-protect and encrypt databases; and set Access options and properties.

PREREQUISITES: A student must have an understanding of the concepts of modifying and analyzing tables, using controls and layouts, manipulating form controls in design view, using editing tools and advanced report design. Students should also have completed Access Introduction and Intermediate.

Lesson 1: Logical and Statistical

  • Functions
  • Logical Functions
  • Math and Statistical Functions

Lesson 4: Advanced Data Management

  • Validating Cell Entries
  • Exploring Database Functions


Lesson 6: Analytical Tools

  • Goal Seek and Solver
  • The Analysis ToolPak
  • Scenarios

Lesson 2: Financial and Data Functions

  • Financial Functions
  • Date and Time Functions
  • Array Formulas
  • Displaying and Printing Formulas

Lesson 5: Exporting and Importing

  • Exporting and Importing Text Files
  • Exporting and Importing XML Data
  • Getting External Data

Lesson 7: Macros and Custom Functions

  • Running and Recording a Macro
  • Working with VBA Code
  • Creating Functions

Lesson 3: Lookups and Data Tables

  • Using Lookup Functions
  • Using MATCH and INDEX
  • Creating Data Tables



September 27
9:00 am - 4:00 pm
Event Category:
Event Tags:


Sarah Juenemann


Capitol Computers
151 Water Street
Augusta, ME 04330 United States
+ Google Map
(207) 623-2700