Review
The course starts with an exercise that will call on the skills learnt in the Access Introduction course. It will help to determine whether the student should continue with the Intermediate course or go back a step and complete the Introduction course.
Queries
-
Exploring comparison operators
- AND, OR, NOT, BETWEEN
-
Using wildcards
-
Action queries
- Update, Append, Delete and Make Table queries
-
Top values
-
Calculated fields and concatenation
-
Exploring table joins
-
Parameter queries
-
Function queries
-
Using the Find Duplicates query wizard
Forms
-
Bound and unbound controls
-
Form sections
-
Using the Field List
-
Aligning controls
-
Using the form controls
- labels, lines, images, check boxes, option buttons, command buttons, drop-down lists
-
Creating a form from scratch
-
Setting default values
-
Changing the tab order
|
Reports
-
Creating a report from scratch
-
Creating a report using the wizard
-
Basing a report on a table or query
-
Grouping and sorting data
-
Keeping groups of data together
-
Controlling pagination
-
Report sections
-
Report layouts
-
Creating a running summary
-
Formatting a report into columns
-
Formatting text
-
Adding lines
-
Using the label wizard
Sub-reports and Sub-forms
-
Why use a subreport or subform?
-
Creating and using a subform or subreport
-
Using Expressions
-
Using the Expression Builder
-
Date functions
- Date, DateDiff, DatePart and DateADD
-
Expressions using fields
-
Integral IF – IIF
-
Aggregate functions
- Sum, Avg, Count
-
Referring to subform / subreport controls in expressions
Macros
|
