Loading Events

« All Events

Access Advanced 2010

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

$195

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

 

Details

Date:
September 27
Time:
9:00 am - 4:00 pm
Cost:
$195
Event Category:
Event Tags:
,

Organizer

Sarah Juenemann

Venue

Capitol Computers
151 Water Street
Augusta, ME 04330 United States
+ Google Map
Phone:
(207) 623-2700
Website:
www.capcomp.com