This is a one-day non-credit course offered through the Workforce Solutions department of JSCC. Non-credit courses are not eligible for financial aid, and college admission is not required.
This intermediate-level Access course is designed to build upon your foundational knowledge. You'll delve into advanced query techniques, master complex form and report design, and explore the power of macros and VBA for automation. Learn to optimize database performance with normalization and indexing, and implement robust data validation and error handling. By the end of this course, you'll be able to create sophisticated, efficient, and secure Access databases.
Course Outline:
Review of Fundamentals
- Quick recap of basic concepts: tables, queries, forms, reports
- Data types, field properties, relationships
- Introduction to SQL basics for querying data
Advanced Query Techniques
- Complex queries: UNION, INTERSECT, EXCEPT
- Parameter queries: User input for dynamic results
- Crosstab queries: Summarizing data in a matrix format
Advanced Form Design
- Subforms: Creating hierarchical forms
- Calculated controls: Performing calculations within forms
- Conditional formatting: Formatting based on specific criteria
Advanced Report Design
- Subreports: Incorporating detailed information within main reports
- Grouping and sorting: Organizing data effectively
- Report parameters: Dynamically filtering report data
Macros and VBA
- Introduction to macros: Automating tasks
- Macro actions: Building blocks for automation
- VBA basics: Writing simple VBA code to customize Access
Data Validation and Error Handling
- Input masks: Controlling data entry format
- Validation rules: Enforcing data integrity
- Error handling techniques: Preventing and handling errors
Advanced Database Design
- Normalization: Organizing data efficiently
- Indexes: Improving query performance
- Security and permissions: Protecting sensitive data
Cost of Course: $150 (lunch included)