Description
Access is a relational database management system (RDBMS). This specificity makes Access a very powerful tool for querying, analyzing or relating data. Its backward and forward compatibility with Excel is also an asset. At the end of this training, you will master all the tools to efficiently and pertinently use your data in Access (version 2010, 2013 or 2016).
Who is this training for ?
For whom ?Access user (versions 2010, 2013 and 2016) wishing to use a database under Access or import data into Access to analyze them.
Prerequisites
Training objectives
Training program
- Master the organization of data under
- Access Reminder of basic notions: fields, tables, relationships.
- Methodology for creating and optimizing a relational schema.
- Define relationships and their properties.
- Create a junction table to manage 'many-to-many' relationships.
- Identify the benefit of creating a 'one-to-one' relationship.
- Define a single or multiple primary key.
- Check data consistency: referential integrity.
- Develop simple and complex queries
- Reminder: queries selection, grouping, crosstab.
- Create queries based on queries.
- Define joins in queries.
- Add calculation formulas, use Access functions.
- Develop parameterized queries.
- Detect duplicates.
- Detect non -correspondence between tables.
- Add, delete or modify data in batches, dynamically generate a table: Action queries.
- Bring together data from several tables: Union queries.
- Manipulate SQL language: Select, Insert, Update...
- Construct reports to present results
- Create and layout a column or tabular report.
- Sort and group data.
- Master the concept of sections, headers and footers group.
- Configure page breaks and breaks.
- Add calculation formulas.
- Insert graphics, images.
- Edit mailing labels.
- Building elaborate reports: the notion of subreport.
- Import and export data
- Import/export data from Excel, txt, csv files.
- Attach Access tables, Excel workbooks.
