Access 2007 - Advanced (English)


95€ - ($68.716)
IVA inc.
Compara este curso con otros similares
Ver más cursos similares

Información importante

  • Curso
  • Online
  • 30 horas de dedicación

Objetivo del curso: Learn about advance table design: validation data rules, indexes and auto-forms. Importing and exporting information from other databases. Learn about different types of databases and their own characteristics. Learning how to create macros, modules, sub-forms, and both dynamic and static pages.
Dirigido a: The present course is fully oriented to anyone who desires to acquire knowledge of the most advanced range of applications this database creation and management tool provides.

Información importante


Advanced report design
  • Introduction
  • Customizing a report
  • Performing calculations
  • Creating general totals
  • Summary
Advanced table design
  • Introduction
  • Creating a template
  • Updating and eliminating information
  • Finding information
  • Validating data
  • Using input masks
  • Summary
Advanced queries
  • Introduction
  • Grouping and counting registers
  • Aggregate functions
  • Adding calculated fields
  • Expression builder
  • Crosstab queries
  • Summary
Action queries
  • Introduction
  • Types of action queries
  • Creating a select query
  • Make table queries
  • Update queries
  • Append data queries
  • Delete queries
  • Summary
Importing information
  • Introduction
  • Importing and linking data
  • Importing from another Access database
  • Importing from an Excel spreadsheet
  • Linking data without importing
  • Summary
Exporting information
  • Introduction
  • Export or copy?
  • Exporting to an Access database
  • Exporting to an Excel spreadsheet
  • Exporting a file to a Word text
  • Merging correspondence with Word
  • Copying information to other Office programs
  • Summary
Working with macros
  • Introduction
  • Creating a macro
  • The most frequent actions
  • Conditional macros
  • AutoExec macros
  • Summary
Customizing Access
  • Introduction
  • Creating a switchboard
  • Creating custom categories
  • Start-up options
  • Customizing the Quick Access toolbar
  • Customizing the Status bar
  • Formatting a table
  • Summary
Sharing and protecting information
  • Introduction
  • Assigning passwords
  • Protecting when you share
  • Backup copies
  • Summary
Utilities of Access
  • Introduction
  • Analyzing tables
  • Analyzing performance
  • Database Documenter
  • Compacting and repairing
  • Summary

Compara este curso con otros similares
Ver más cursos similares