a

san diego computer training classes


Computer Classes & Lessons

San Diego California

 


 

ADVANCED ACCESS 2007-2010

Price: $79.99  
Course Length: 3.25 hours

Cancellation Policy
Beginning Access 2007-2010 - $79.99
Intermediate Access 2007-2010 - $79.99
Advanced Access 2007-2010 - $79.99

Beg/Int/Adv Access 2007-2010 Package - $209.99
Beginning Access Course Description

Intermediate Access Course Description
Printable PDF version of this page

Microsoft courses are taught by a Microsoft Certified Professional

ADVANCED FORMS: 

  • Add buttons to forms to run macros
  • Add drop-down look-up fields to forms
  • Change Properties of fields
  • Place Calculations in Headers and Footers
  • Work with Layout View to design a form
  • Add Controls to a form
  • List Boxes
  • Combo Boxes
  • Option Groups

CALCULATIONS (EXPRESSIONS):

Learn different ways to calculate numbers and summarize data.

  • Calculate Numbers in Tables & Queries
  • Add Calculated Fields (Expressions) in Forms & Reports
  • Summary Query or Table

EXTERNAL DATA 

Import data from Excel, Outlook, or another Access database. Collect data from e-mail programs, create e-mail surveys, etc. Attach file(s) to Access, send XPS Attachments, save objects as web files, insert hyperlinks.

ADVANCED QUERIES:

  • Multiple Tables  (with or without Joins)
  • Parameters (basic parameters, multiple parameters, date ranges, wildcards, etc.)
  • Find Duplicates Query (locate duplicate records)
  • Find Unmatched Query (locate records in one table that have no matching record in another table)
  • Append Query (add records from one table to another)
  • Delete Query (delete records meeting one or more criteria)
  • Update Query (update records based on one or more criteria)
  • Cross-Tab Query
  • Use Access Functions in Queries
  • Add Queries in Forms, Reports, and Macros

ADVANCED REPORTS, PIVOT REPORTS, & PIVOT TABLES:

  • Create Mailing Labels for a Word Mail Merge
  • Create Pivot Tables
  • Create Pivot Charts
  • Save Forms as Reports

SECURITY:

  • Trusted Locations
  • Encrypt /Decrypt (Password Protect) Database
  • Compile an AACBE Secured Copy of a Database to Distribute to Others

MANAGE A DATABASE

  • Backup
  • Compress
  • Repair
  • Split
  • Use Linked Table Manager


access class san diego, access training san diego

 

San Diego Computer Training Classes Blog