MS Access 2002 Utilisation de base


Présentation/Description
Public ciblé
Durée prévue
Objectifs du cours
Numéro du cours

Présentation/Description
This course presents the learner with the fundamentals of Microsoft® Access 2002. It makes no assumptions about the student's background and comprehensively guides the student through the basics of Access databases with the emphasis on learning by doing. This course is ideal for beginners who would like to achieve measurable and certifiable standards at their own pace.

Public ciblé
Le cours Microsoft Access 2002 - Utilisation de base (Nø F74050) ne requiert aucune connaissance sur les bases de donn‚es. C'est pourquoi il convient aussi bien aux chefs de projet ou responsables d'‚quipe qu'aux secr‚taires, d‚veloppeurs/concepteurs Web, administrateurs systŠme et administrateurs de base de donn‚es, auxquels peuvent s'ajouter tout un ‚ventail d'autres fonctions telles que secr‚taire d‚butant, agent de service aprŠs-vente, etc. Ce cours s'adresse aux personnes qui travaillent dans un bureau (‚ventuellement en r‚seau) dont la tƒche principale consiste … produire des documents, feuilles de calcul, bases de donn‚es et/ou pages Web.

Durée prévue (hours)
8.0

Objectifs du cours

MS Access 2002 Utilisation de base

  • Identify advantages of a relational database.
  • Identify the basics of a relational database.
  • Sequence the steps for planning a relational database.
  • Open a database by using Microsoft Access.
  • Match database objects with their features.
  • Identify the functions of each database object view.
  • Create a blank database.
  • Identify the options available when creating a database by using a database template.
  • Get help by using the Office Assistant.
  • Identify features of the Help Window.
  • Create a table in Datasheet view.
  • Identify features of the Table Wizard
  • Create a table in Design view.
  • Create a field for a table in Design view.
  • Move a field in a table in Datasheet view.
  • Modify a field property in a table in Design view.
  • Create an input mask in a table field.
  • Delete a field from a table in Design view.
  • Set a field as a primary key in Design view.
  • Set an index for a field in a table.
  • Match optimum field data types with their features.
  • Customize an input mask for a field in a table in Design view.
  • Identify features of the Lookup Wizard.
  • Identify the functions of Lookup field properties.
  • Enter data into a table in Datasheet view.
  • Edit data in a table in Datasheet view.
  • Delete data from a table in Datasheet view.
  • Add a hyperlink to a table in Datasheet view.
  • Sort table data by a single field.
  • Copy data into fields from other Office applications by using Office Clipboard.
  • Match the record navigation controls with their functions.
  • Locate a record in a datasheet by using the Find command.
  • Filter by selecting a value in Datasheet view.
  • Filter by excluding a selected value in Datasheet view.
  • Filter by form in Datasheet view.
  • Filter for input by entering specific criteria in a Filter For box.
  • Filter a record by using the Advanced Filter/Sort window.
  • Resize a column in Datasheet view.
  • Format a datasheet.
  • Identify features of relationships between tables.
  • Create a one-to-many relationship between tables.
  • Sequence the steps to define a many-to-many relationship between two tables.
  • Print a relationship report of a database.
  • Identify features of a subdatasheet.
  • Validate data integrity in a table.
  • Identify features of the Required property used to ensure data integrity.

    • Numéro du cours:
    fr_FR_74050_ng