Description

This internship will allow you to improve your skills on Access. You will learn how to create advanced queries, use different types of joins, create interactive forms and reports, and transfer data. You will also know how to automate tasks using macro-commands.

Who is this training for ?

For whom ?

Database designers wishing to improve and automate a database.

Prerequisites

Training objectives

Create advanced queries on Access

Create consultation forms and subforms

Create reports containing calculations and statistics on the data

Use data from other applications

Use an Access database for a Word mailing

Discover macro-commands to automate processing on Access

Training program

• Advanced selection queries
  • Management of multitable queries.
  • Control all internal and external joins.
  • Parameterized queries.
  • Non-match and search for duplicates.
  • Query optimization.
  • Practical work Create queries with one or more parameters.
  • Queries with different types of joins.
  • Practice of queries linking several tables.
• Advanced Action queries
  • The addition, update and deletion action queries.
  • The table creation query.
  • The principle and usefulness of the 'query chain.
  • Query chaining.
  • Practical work Using Action queries.
  • Create new tables using of queries Action.
  • Create queries dependent on other queries.
• The forms
  • Designing a form.
  • Using templates.
  • The new "Page" mode.
  • Using external controls : lists, options.
  • Properties of the form and objects.
  • Sequence of forms: subforms.
  • Practical work Creating forms consultation and updating of data.
  • Integrate text boxes, lists.
  • Create a form with subform.
  • Integrate calculations and statistics by group.
• The states
  • Complex reports with several levels of grouping.
  • Calculations and statistics by section.
  • Management of report and page headers and footers.
  • Advanced layout options.
  • Creating reports for printing labels.
  • Practical work Creating reports using simple groupings and successive.
  • Integrate calculations and statistics.
• Communication between Access and other products
  • Sharing and protecting a database.
  • Import/Export of Excel/text file.
  • PDF and XPS export formats.
  • Using an Access database for Word merge and mail merge.
  • Practical work Recovering TXT and XLS type data.
  • Export tables and queries.
  • Mail merge between Access and Word.
• Macro commands
  • Introduction to macros.
  • Using the pre-programmed macro buttons.
  • Putting conditions in macros.
  • Practical work Use pre-programmed buttons.
  • Create macros for different actions.
  • Assign a button to a macro.