| Training & Development - Technical Training Curriculum
[Back to course listing]
Microsoft Access, Level 2
Learn sound Table design methods to better control data entry and task automation. Customize Forms and Reports so that data can be shared over an intranet or the Internet. Become familiar with data normalization techniques. Use queries to calculate expressions and extract data from multiple Tables. Improve Form designs by adding bound controls, calculated fields, and a combo box.
Presenter(s): Frank Widman, Senior Technical Training Consultant
Prerequisite: Access, Level 1 or equivalent experience
Enrollment: Use our Online Registration Form, or call 459-5565.
Additional Information: This class is intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable in both labs.
Related Courses:
| Schedule |
| Date |
Time |
Fee |
Location |
|
TBD |
9am - 4pm |
$25 |
Kerr
Hall Room 8 |
Course Outline
- Table and Query Properties
- Creating charts
- Field size
- Format and decimal places
- Input mask
- Caption
- Default value
- Validation rule and text
- Required
- Description
- Top values
- Indexing and Lookups
- Multiple table design
- Primary key
- Indexed property
- Multiple field index
- Looking up key descriptions
- Expressions in Queries
- Expression builder
- Numerical expressions
- Formatting expressions
- Date and time expressions
- Text expressions
- Sorting and criteria in expressions
- Functions in Queries
- Getting help with functions
- If function
- Date and time functions
- Text functions
- Parameters in a Query
- What is a parameter?
- Multiple parameters
- Data typing parameters
- Criteria expressions with parameters
- Recording parameters
- Parameter as a field
- Parameters in expressions field
- Exporting and Importing Data
- Access databases
- Excel spreadsheets
- Word documents
- Delimited ASCII
- Fixed ASCII
|
