Access level 1

WHO IS IT FOR ?

Designers or users of a database who want to create an Access database or understand how an existing database is structured so that they can use it or have a global approach to the tools for using a database (queries, forms, and reports)

how ?

Theory/practice breakdown: 45%/55%. This training consists of an alternation of theoretical contributions, practical work based on a common thread application, demonstrations, phases of exchange between participants and summaries on the part of the trainer

DURATION

2.00 day(s) 14:00 hours

HOW IT ADVANTAGES YOU

- Design the structure of a relational database in accordance with the rules

- Create tables and define the type of data that will be stored in them

- Link tables together

- Create and modify different objects to extract (queries), enter (forms) or edit (reports) the data of a database

ON THE PROGRAM

Database design

- Understand the organization of a database

- Analyze and design a simple database

- Create the objects that make up the database (tables, queries, etc.)

- Operate a database

Master the principles of a database

- Fundamentals of a database

- Organization of a database

- The relational mode

Create "Selection" queries

- Basic query

- The different types of criteria

- Calculated fields

- Multitable quieres

- Inner joints

- External joins

- Create parameterized queries

Complex quieres

- Bundling queries

- Queries of queries

Forms Object

- Creating forms with the wizard

- Form Editing

- Design of a form for entering criteria for requests

Object State

- Creating reports with the wizard

- Grouping type state

Sustainable Development

Languages

Training program

Tools

Softskills