Access 2007 - Basic (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 what a database is and how to create a database with Access. Learn how to design and create a relational database using different tools. Learn how to define and maintain relations amongst tables. Creating and maintaining forms. Learn how to design filters and queries to databases tables. Designing, creating and performing reports and tabs.
Dirigido a: The present course is fully oriented to anyone who desires to acquire knowledge of the basic range of applications this database creation and management tool provides.

Información importante


  • Cover
  • Welcome
  • Objectives
  • People
  • Course structure
  • Practice and exercises
  • Setup of the program
First steps with Access 2007
  • Introduction
  • The program interface
  • Working with databases
  • Summary
Basic concepts of Access
  • Introduction
  • What is a database?
  • The structure of a database
  • Components of a database
  • Printing objects of Access
  • Summary
Creating tables
  • Introduction
  • Creating a table
  • Creating a table in the Datasheet View
  • Creating a table in the Design View
  • Working with types of data
  • Working in the fields
  • Creating more than one table
  • Summary
Modifying tables
  • Introduction
  • Modifying a table
  • Improving the appearance of a table
  • Modifying the design
  • Modifying data
  • Summary
Defining relationships
  • Introduction
  • Relational databases
  • Creating a relationship
  • Modifying relationships
  • Viewing relationships
  • Summary
Introduction to queries
  • Introduction
  • The queries of Access
  • Creating a query
  • Saving a query
  • Running a query
  • Creating a parameter query
  • Summary
Introduction to forms
  • Introduction
  • Making concepts clear
  • The Form Wizard
  • Editing the data of a form
  • Ways of visualizing forms
  • Incorporating control objects
  • Printing forms
  • Summary
Designing a form
  • Introduction
  • Creating a form manually
  • Adding a sub form
  • Adjusting the properties of a form
  • Working with controls
  • Summary
Introduction to reports
  • Introduction
  • Getting used to reports
  • The Report Wizard
  • Modifying the format of reports
  • Printing reports
  • Summary

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