Description

The Access interface, user-friendly and intuitive, allows anyone to easily build a database. However, to ensure effective use of Access, it is essential to understand the structure of a relational database and to use the different tools methodically. This training brings you these different approaches.

Who is this training for ?

For whom ?

Anyone starting out with Access. This training is aimed at users of versions 2010, 2013 and 2016.

Prerequisites

Training objectives

Design and structure a relational database.

Develop queries.

Build forms and reports. Make it easier to use with simple macros.

Training program

• Design and organize your database
  • Organize and distribute your data between different tables.
  • Create tables, define fields.
  • Identify the index primary key.
  • Define relationships, ensure referential integrity.
  • Import, export, attach data.
• Analyze your data: queries
  • Create a query from one or more tables.
  • Develop 'Selection' queries.
  • Insert calculated fields.
  • Group the data on a field, an expression.
  • Add a totalization line: sum, average, ...
  • Illustrate the result with a pivot chart.
  • Act on data with 'Action' queries: update, add, delete.
• Simplify entry: forms Generate simple forms.
  • Apply filters and sorts.
  • Insert controls: checkboxes, radio buttons, drop-down lists.
  • Create query-based forms .
  • Insert a subform.
  • Use expressions in forms.
• Highlight your results: the reports
  • Create column or table reports.
  • Add a logo, a header and a footer.
  • Develop structured reports: sort, group.
  • Add totals, subtotals.
  • Highlight results: conditional formatting.
  • Save a report as PDF.
• Make it easier to use
  • Customize navigation.
  • Design a home menu.
  • Create simple macros.
  • Associate macros with buttons.