Access 2013, 2016, 2019, 365 ProPlus - Fundamentals

Formation inter-entreprise

À qui s'adresse la formation?

Tout public


12,00 heure(s)

Langues(s) de prestation


Prochaine session





Basic Windows skills


Be able to understand and create the structure of an Access database.


  • Environment
  • General topics
    • Launching Microsoft Access
    • Exiting Microsoft Access
    • Using/Managing the Ribbon
    • Displaying/Hiding the tool tip texts
    • Navigation pane
    • Customising the Quick access toolbar
    • Moving the quick access toolbar
    • Cancelling/Restoring the manipulations
  • Help
    • Searching help by using keywords
  • Databases
    • Thinking about the database purpose
    • Creating a new database
    • Opening/Closing a database
    • Managing the prior database formats
    • Compacting and repairing a database
    • Saving a database
  • Introduction to database objects
    • Access database objects: tables, queries, forms, reports …
    • Modifying the display/items order
    • Searching an object
    • Managing the objects
  • Tables
    • Table structure
      • Creating a table
      • Modifying the structure of the table with the Design/Datasheet view
      • Modifying field properties
      • Creating a list of values
      • Creating a multivalued list based on permanent data
      • Indexing a table
      • Defining a primary key
    • Relationships between the tables
      • Establishing a relationship between two tables
      • Managing database relationships
      • Displaying/ Modifying linked data in a sub-datasheet
  • Data management
    • Records
      • Entering information in the datasheet
      • Managing the datasheet
      • Adding/ Modifying/ Deleting a record
      • Sorting data
      • Filtering the information
      • Adding/Hiding a total row in a datasheet
      • Inserting a hyperlink
      • Searching a value in the records
      • Replacing a value
    • Data printing
      • Using the print preview
      • Modifying print margins and orientation
      • Printing an object
  • Queries
    • Selection queries
      • Creating a query based on a single table
      • Creating a multi-table query
      • Defining query properties
      • Managing the Design grid
      • Running a query
      • Defining criteria
      • Defining a parameter
      • Modifying the join type in a multi-table query
      • Creating a non-matching query by using the assistant
      • Creating a query which allows to find duplicates by using the assistant
      • Inserting a calculated field in a query
  • Creation of forms and reports
    • Creating a Form
      • Creating an instant form
      • Creating a form with the assistant
      • Displaying a form in design view
    • Creating a Report
      • Creating a report by using the assistant
      • Sorting data
      • Creating Labels by using the Report’s wizard
      • Modifying the labels page setup
      • Printing a report for some records
      • Grouping records
      • Inserting a summary calculation in a report

Certificat, diplôme

Upon completion of the course, participants will receive a certificate of participation issued by the House of Training.

Prochaine session

Language & prix

EN 500,00€

Ces formations pourraient vous intéresser