ACCESS
ACCESS 2007 - LEVEL 1


Description
View Course Syllabus 
Audience:    New Users

Duration: 3 half-days - 9 hours

Access Level 1 - Description:  Access Level 1 introduces you to the major sections of the software; Tables, Queries, Forms and Reports.  Each section is covered showing how to create and edit a table, query, form and report.  Access Level 1 gives you the essential skills to take advantage of the program right away.

Course Syllabus - Access Level 1

  • Learn the major core sections of Access
  • Become familiar with the Access environment
  • Database navigation: Search data for specific records
  • Create quick data sets using Filter by Form and Filter by Selection
  • Create a new database
  • Learn the crucial importance of data types
  • Edit field attributes using the field property section
  • Create and design Queries
  • Create and edit Forms
  • Create and edit Reports
  • Introduction to Table Relationships

Have questions? Contact us - View testimonials - Save on multi-course Discount Package

Access 2007 - Level 2


Description
View Course Syllabus

Audience:    Prerequisite: Access Level 1 or similar experience.

Duration3 half-days - 9 hours

Access Level 2 - Description:  Go beyond Access Level 1 and move into table relationships.  Create multiple queries based on joined tables. Sort queries with multiple fields and continue to develop more advanced queries. Learn to create forms with sub forms based on table relationships. Make forms more powerful by adding command buttons and controls. Apply advanced level formatting to reports. Add formulas to reports to get subtotals and grand totals

Course Syllabus

  • Create table relationships.
  • Create multiple table queries based on table relationships.
  • Sort a query with multiple fields.
  • Develop advanced and/or queries.
  • Build summary, cross tab, calculated and pivot table queries.
  • Develop forms and sub forms based on table relationships.
  • Modify sub forms by using option groups, combo boxes and command buttons.
  • Apply advanced formatting to reports.
  • Modify report properties.
  • Create formula calculations in a report.
  • Export/import data to and from Excel.
  • Import and export data in different formats.
  • Merge a database with Word template.