1.  
2. Events 

---

Access 2013, 2016, Office 365 Advanced

440 €

at 1.1 KM
Keyjob Follow

• Training
• Business
• Strategy
• Technology
• Digital
• IT
• Productivity
• Office
• Performance

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