Access 2007 Completo (English)

Study&Go
Online

125€ - ($85.922)
¿O prefieres llamar ahora al centro?
+34 9... Ver más
Compara este curso con otros similares
Ver más cursos similares

Información importante

  • Curso
  • Online
  • 60 horas de dedicación
Descripción

Objetivo del curso: Learn about advance table design: validation data rules, indexes and auto-forms. Learn about different types of databases and their own characteristics. Learning how to create macros, modules, sub-forms, and both dynamic and static pages. Learn how to guarantee the database's security: protecting, assigning passwords, restricting and sharing information.
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

Temario

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