Course description
Microsoft Office Access 2010 is the newest version of Microsoft's popular database program. This advanced level is intended to help those who are familiar with Access do more with their database by exploring form controls and data management.
Upcoming start dates
Who should attend?
Training content
Section 1: Advanced Data Management
- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes
Section 2: Advanced Form Tasks
- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks
Section 3: Pivoting Data
- Creating a PivotTable
- Using PivotTables
- Advanced PivotTable Tasks
- Creating a PivotChart
- Using PivotCharts
Section 4: Advanced Topics
- Access and Windows
- Splitting Your Database
- Using Outlook with Access
- Using Access 2010 with SharePoint Server
- Access and Web Databases
Section 5: Macros and Visual Basic for Applications (VBA)
- Macro Basics
- More about Macros
- Access and VBA
- Building Advanced Procedures
- Using VBA in a Database
Why choose BBLN?
In operation for over 20 years, Building Blocks takes a consultative approach to customer engagement to deeply asses the needs. We offer a variety of options for consideration.
All of our instructors have a minimum of 20 years of teaching experience using adult learning theory.
We can proudly say that our customers routinely say we exceeded their expectations and in doing so, we offer many benefits that are included in the service and pricing.
Contact this provider
Building Blocks Learning Network
Building Blocks Learning Network (Building Blocks) is a training company with over 20 years of experience in Adult Education. Our specific expertise includes professional development in the areas of Executive Leadership, Management and Leadership, Coaching, Policy Development, How Government Works,...