FR
EN
LU
DE
Details
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
Sign up
Next session(s)
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!