Using Microsoft Access 2003
Day 2: Creating Forms
| Duration: | 1 day (about 6 to 7 hours) |
| Prerequisite: | Basic knowledge of the Microsoft Access environnment. |
| Course Materials: | Training book (350 pages) and handouts. |
| Prices: | $225 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class is Day 2 of a 3-day our Microsoft Access course. This class teaches you how to build efficient and useful forms for imputting and editing data. We start by building a basic form and then go on to learn about data validation to ensure data entry accuracy, learn how to design forms for the business environment, and learn how to create specialized forms such as switchboards, dialog boxes, and startup screens. You have the option of taking all 3 days of training (highly recommended), or cherry-picking topics from any of the 3 days of training to create a 1 or 2 day custom course. |
Creating and Using a Form
- Creating a Form with AutoForm
- Creating Simple Forms with the Form Wizard
- Navigation in a Form
- Creating a Form in Design View
- Displaying the Design View
- A Tour of the Design View Window
- Understanding Form Controls
- Adding Fields to the Form
- Changing the Size of the Form
- Viewing the Form
- Assigning an AutoFormat in Design View
- Working with the Form Header and Footer
- Working with Form Properties
- Formatting the Background
- Protecting the Form and Data from Other Users
Working with Form Controls
- Manipulationg Form Controls
- Inserting Controls on a Form
- Selecting Controls
- Formatting Controls
- Adding Conditional Formatting
- Sizing Controls
- Moving Controls
- Copying Controls
- Deleting Controls
- Grouping Controls
- Ordering Overlapped Controls
- Converting an Unbound Control to a Bound Control
- Changing a Control's Type
- Setting the Tab Order
- Adding Labels to the Form
- Inserting a Label
- Editing the Label Caption
- Using Labels to Create Keyboard Shortcuts for Controls
- Adding Text Boxes to the Form
- Inserting a Text Box
- Using Text Boxes as Calculated Controls
- Creating a Mortgage Calculator
Designing a Form For Efficient and Accurate Data Entry
- Preventing Errors by Validating Data
- Helping the User with Text Prompts
- Preventing Errors with Data Validation Expressions
- Using Input Masks for Consistent and Accurate Data Entry
- Using Controls to Limit Data Entry Choices
- Working with Yes/No Fields
- Using Check Boxes
- Using Option Buttons to Present a Limited Number of Choices
- Using an Option Group to Select the Shipper
- Using Lists to Present a Large Number of Choices
- Data Entry with ActiveX Controls
- Entering Numbers Using a Spin Button
- Entering Numbers Using a Scrollbar
- Entering Dates Using a Calendar
Designing Forms for Business Use
- Using Forms in a Business Context
- Why Collect the Data?
- What is the Data?
- Who Are Your Users?
- Ten Design Guidelines for Business Forms
- Organizing Controls on the Form
- Making Good Use of Lines and Rectangles
- Organizing with Option Groups
- Organizing with a Tab Control
- Enhancing Form Text
- Formatting Text
- Text Formatting Tips and Guidelines
- Working with Colors
- Creating a Custom Color
- Using Color Effectively
- Adding Images to Your Forms
- Adding Special Effects
- Create a Shadow Effect for Text
Creating Specialized Forms
- Creating a Multiple-Table Form
- Understanding Subforms
- Creating a Form and Subform with the Form Wizard
- Creating a Subform in the Form Design View
- Creating a Subform Using Another Table or Query
- Creating a Subform Using Another Form
- Working with Form Command Buttons
- Case Study: Creating a Switchboard Form
- Creating a Form Pop-Up Box or Dialog Box
- Creating a Pop Up Form
- Creating a Modal Form
- Using a Custom Form with a Parameter Query
- Creating the Custom Form
- Adjusting the Parameter Query
- Using the Custom Form and Parameter Query
- Creating a Startup Form
- Creating a PivotChart Form