Access 2019/365 – Level 2

What’s new in this release

• Support for large numbers (bigint).
• Property sheet sorting.
• New « Label name » property for controls.
• Easier editing of a new value list item.
• Easier resizing of objects in design view.
• Choose the right Storage drive for your results
• Classic: on a file server or the hard drive of a device.
• Personal OneDrive / Shared OneDrive / SharePoint-Teams

Review of selection queries

• Basic concept of queries
• Using filters in queries (and/or, like, null, [])
• Creating calculated fields (functions / formulas)
• Perform aggregations (sum, average, min, max, count)

Analysis (Architecture of a database)

• Reminder of relational database theory
  • Understand the value of relationships
  • Differentiate between the 3 types of relationships (1 to 1, 1 to many, many to many)
  • Understand the concept of primary key and foreign key
  • Master the concept of referential integrity
• Exercises :
  • Analyze relationships in an existing database
  • Create selection queries that use multiple tables (aggregation)

Advanced queries

• Using action queries (table creation, update, addition and deletion).
• Properties of links in a query.
• Mismatch query.
• Advanced functions in queries.
• Create a list of choices on a “foreign key” field in a table.
• Introduction to the SQL language (union query)

Forms & Reports

• Master the various controls (list box, option group, check box,…)
• Master some forms and reports properties
• Master conditional formatting

Macros

• Understand the purpose of macros
• Master the concept of event in forms
• Useth most common actions in macros

Analysis of data from multiple sources with PowerPivot

• Import / Export (xlsX , CSV,txt, Accdb…).
• Links between tables of different types.