Access Intermediate
Now that your data is safely being held in Access tables, it’s time to create a means to enter new data and print that data. This class focuses on Form and Report Design, utilizing Access’s Form and Report Controls. We also continue working with Queries including creating user prompts, Parameter Queries, and Grouping Queries. PARAMETER QUERIES * GROUPING * FORM & REPORT DESIGN!
Scheduled Dates
| This class is scheduled on an as-needed basis. Please choose an available day and time or call us at (909) 981-6331 for more information. |
Topics Include:
- Primary Key
- Adding and Deleting Database Relationships
- Importing tables, queries,forms, reports
- Linking tables
- Creating a parameter query
- Set up grouping with queries
- Creating an Autoform
- How to use a Form
- Add Records
- Edit Records
- Delete Records
- Open/Close a form
- Using Form Wizard to design a form
- Viewing, resizing and moving sections
- Resizing objects
- Moving a single object or group
- Aligning items
- Deleting items
- Adding labels
- Formatting text
- Using Size to Fit
- Drawing lines and rectangles
- Adding colors and borders
- Sending an object to the back
- Adding special effects
- Using the Label Wizard
- Using the Report Wizard with and without grouping
- Grouping sections
- Creating a calculating textbox
- Office Links