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

Loading Events

« All Events

  • This event has passed.

Access Intermediate 2010

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

$195

COURSE DESCRIPTION: This ILT Series course builds on the skills and concepts taught in Access 2010: Introduction. 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.

PREREQUISITES: A student must have an understanding of the concepts of defining field data types and properties, creating simple criteria queries and creating sorting queries. Students should also have completed Access Introduction.

Lesson 1: Using multiple worksheets & workbooks

  • Using Multiple Workbooks
  • Linking Worksheets with 3-D Formulas
  • Linking Workbooks
  • Managing Workbooks

Lesson 5: Tables

  • Sorting and Filtering Data
  • Advanced Filtering
  • Working with Tables

Lesson 8: Documenting and Auditing

  • Auditing Features
  • Comments in Cells and Workbooks
  • Protection
  • Workgroup Collaboration

Lesson 2: Advanced Formatting

  • Using Special Number Formats
  • Using Functions to Format Text
  • Working with Styles
  • Working with Themes
  • Other Advanced Formatting

Lesson 6: Web and Sharing Features

  • Saving Workbooks as Web Pages
  • Using Hyperlinks
  • Sharing Workbooks

Lesson 9: Templates and Settings

  • Changing application settings
  • Using built-in Template
  • Creating and Managing Templates

Lesson 3: Outlining and Subtotals

  • Outlining and Consolidating Data
  • Creating Subtotals

Lesson 7: Advanced Charting

  • Chart Formatting Options
  • Combination Charts
  • Graphical Elements

Lesson 10: PivotTables and PivotCharts

  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • Using PivotCharts

Lesson 4: Cell and Range Names

  • Creating and Using Names
  • Managing Names

Details

Date:
September 18
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