Course content Planning a report· - Database, tables and fields·
- Understanding the data
Connecting to data· Creating a new report· - Starting a new report·
- Report layout·
- Adding, moving and sizing fields ·
- Adding, moving and sizing objects·
- Previewing and refreshing data·
- Saving a report
Formatting objects· - Editing and formatting text objects·
- Text fields, number fields and ·
- date/time fields
Record selection· - Using the select expert·
- Adding and editing selection criteria·
- Setting the report date
Sorting and grouping· - Applying a sort order·
- Adding and editing a group definition·
- Grouping on a date field
Grouping and summarising· - Summarising·
- Adding a subtotal and grand total·
- Top N / sort group
Working with text objects· - Text rotation·
- Combining text and fields
Special fields and graphics· - Adding and formatting special fields·
- Inserting boxes, lines and graphics
Linking tables· - Using the visual linking expert·
- Relationships and joins
Formulas· - Creating and editing a formula·
- Numeric and date calculations·
- Using IF formulas
Conditional reporting· - Using the highlighting expert·
- Conditional formatting
Section formatting· - Using the section expert·
- Changing backgrounds
|
