Access 2013, 2016, 2019, Microsoft 365 Apps for Enterprise Advanced

Goals

Be able to use advanced tools in Access databases.

Prerequisite

Basic Access skills

Contents

Queries

• Action Queries
  • Deleting records
  • Creating a table
  • Adding records to a table
  • Updating records

Creation of forms and reports

• Form creation
  • Creating an instant form
  • Creating a form by using the assistant
  • Displaying a form in Design view
  • Ordering access to the form’s fields
  • Modifying form properties
  • Accessing the form’s source query
  • Creating a form with a subform
  • Managing subforms
  • Inserting fields from several tables
  • Preventing access and modification of a field
  • Defining a data entry form
• Report creation
  • Creating a report by using the assistant
  • Displaying the report in design mode
  • Sorting the data
  • Inserting a subreport
  • Creating a report for printing labels
  • Modifying the labels page setup
• Report grouping and printing
  • Grouping records
  • Printing each group on a single page
  • Avoid printing headers/footers
  • Avoid printing duplicates

Design mode

• Bound controls
  • Inserting a text box
  • Inserting a checkbox, option button, or a toggle button
  • Creating a fixed data list
  • Creating a list which shows data from another table
  • Inserting an option group in a form
  • Changing the type of a control
  • Inserting an object
• Unbound controls
  • Creating a label
  • Drawing a rectangle or a line.
  • Tab control
  • Inserting a page break
  • Inserting an image
• Calculated controls
  • Creating a calculated control
  • Creating a conditional calculation
  • Using the expression builder
• Managing controls
  • Applying/removing tabular or stacked layouts
  • Selecting controls
  • Deleting controls
  • Formatting controls
  • Modifying a number format
  • Modifying the pages’ layout of a tab control
  • Creating a customized format
  • Creating conditional formats
• Sections
  • Displaying/Hiding the sections
  • Modifying the height of a section

Macros

• Creating a macro
• Creating an independent macro
• Running a macro when the database opens
• Associating a macro with a form/report/control
• Modifying a macro
• Running conditional actions
• Referring to a field/property
• Running another macro
• Defining properties values in a macro
• Displaying the help on a built-in function or on a macro action

Optional points: Copy/ Import/ Export

• Export a table or an access query in Excel and establish a connection
• Exporting an object to another database
• Exporting an object to a text file
• Importing or attaching data from a text document
• Importing or attaching data from another access database
• Running a saved export/import