Access 2007-Nivel 1

Curso

En Chihuahua

¡50% de ahorro!
$ 900 más IVA

Llama al centro

¿Necesitas un coach de formación?

Te ayudará a comparar y elegir el mejor curso para ti y a financiarlo en cómodas cuotas mensuales.

Descripción

  • Tipología

    Curso

  • Lugar

    Chihuahua

  • Horas lectivas

    16h

Objetivo del curso: This course is designed for students who wish to learn the operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The first part of the course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Destinatarios del curso: This course is designed for students who wish to learn the operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

Sedes y fechas disponibles

Ubicación

Inicio

Chihuahua
Ver mapa
Trasviña Y Retes 2901, Col San Felipe, 31203

Inicio

Consultar

Acerca de este curso

Windows XP Nivel1

Preguntas & Respuestas

Plantea tus dudas y otros usuarios podrán responderte

¿Quién quieres que te responda?

Sólo publicaremos tu nombre y pregunta

Programa académico

Lesson 1: Exploring the Microsoft® Office Access™ 2007 Environment

Examine Database Concepts
Explore the User Interface
Explore the Ribbon
Customize the Access Environment
Obtain Help
Use an Existing Access Database

Lesson 2: Designing a Database

Describe the Relational Database Design Process
Define Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships

Lesson 3: Building a Database

Create a New Database
Create a Table
Manage Tables
Create a Table Relationship
Save a Database as a Previous Version

Lesson 4: Managing Data in a Table

Modify Table Data
Sort Records
Work with Subdatasheets

Lesson 5: Querying a Database

Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

View Data Using an Access Form
Create a Form
Modify the Design of a Form

Lesson 7: Generating Reports

View an Access Report
Create a Report
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat to a Report
Prepare a Report for Print

Lesson 8: Controlling Data Entry

Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field

Lesson 9: Joining Tables

Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Lesson 10: Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Lesson 11: Improving Forms

Design a Form Layout
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Subform

Lesson 12: Customizing Reports

Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Lesson 13: Sharing Data Across Applications

Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

Llama al centro

¿Necesitas un coach de formación?

Te ayudará a comparar y elegir el mejor curso para ti y a financiarlo en cómodas cuotas mensuales.

Access 2007-Nivel 1

$ 900 más IVA