| Focus on essential skills for creating reports and forms based on single and multiple table queries with sorting and parameters. Start with basic editing skills to build custom reports, set properties, place fields. Create templates, learn formatting. Sort and group data; insert expressions & subtotals; add totals in group header/footer. Work with form and section properties, text box properties. Add check boxes and combo boxes. Create a continuous form, subform control, multi-source form, two-part form. 12 hours |
Basic Report/Form Skills
- What is a report/form?
- Identifying sections and controls
- The toolbox/toolbar
- Selecting controls/sections
- Changing font/alignment
- Sizing a control /section
Basic Editing Skills
- Manipulating controls
- Creating a report using a wizard
Creating a Custom Report
- Setting report and control properties
- Setting page setup options
- Adding headers and footers in a report
- Moving labels to page header
Enhancing the Report
- Creating a report template
- Adding a page number
- Adding and formatting a date field
- Adding unbound objects
- Creating a multi-column report
Sorting and Grouping
- Manipulating groups and sorts
- Hiding duplicates
- Adding totals in a group header or footer
- Keeping groups together
- Calculating percentages using expressions
Report and Section Properties
- Report/section properties summary
- Changing source for records in report
- Suppressing page header/footer
- Adding page breaks between sections
- Keeping data together
|
Text Box Properties in a Report
- Changing the control source of a text box
- Changing format and decimal places
- Sizing sections/text fields automatically
- Creating a running sum
Creating a Custom Form
- Setting page setup options/tab order
- Adding headers and footers in a form
Enhancing the Form
- Creating a form template
- Adding check box, combo box, etc.
- Changing a control type
Form and Section Properties
- Changing the source for records in a form
- Preventing switching between views
- Changing editing capabilities of a form
- Creating additional viewing space
- Record dividers
Text Box Properties in a Form
- Changing the control name/source
- Properties set by tables
- Adding control/tip text
- Enabled and locked
- Tab stop and auto tabbing
- Adding scroll bars
Other Forms
- Creating a continuous form
- Creating a form for a Subform control
- Creating a Subform control on Main form
- Creating a Multi-source form
- Creating a Two part form
|