Description
Duration: 2 days
Access 2010 gives you a powerful set of tools that are sophisticated enough for professional developers, yet easy for new users to learn. Create powerful database solutions that make organizing, accessing, and sharing information easier than ever. This course is recommended for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
This one-day course prepares you for Exam 77-885
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 9/23/2024 | 9/23/2024 | ||||
| 10/14/2024 | 10/14/2024 | ||||
| 11/4/2024 | 11/4/2024 | ||||
| 11/25/2024 | 11/25/2024 | ||||
| 12/16/2024 | 12/16/2024 | ||||
| 1/6/2025 | 1/6/2025 | ||||
| 1/27/2025 | 1/27/2025 | ||||
| 2/17/2025 | 2/17/2025 | ||||
| 3/10/2025 | 3/10/2025 | ||||
| 3/31/2025 | 3/31/2025 | ||||
| 4/21/2025 | 4/21/2025 | ||||
| 5/12/2025 | 5/12/2025 | ||||
| 6/2/2025 | 6/2/2025 | ||||
| 6/23/2025 | 6/23/2025 | ||||
| 7/14/2025 | 7/14/2025 | ||||
| 8/4/2025 | 8/4/2025 | ||||
| 8/25/2025 | 8/25/2025 | ||||
| 9/15/2025 | 9/15/2025 | ||||
| 10/6/2025 | 10/6/2025 | ||||
| 10/27/2025 | 10/27/2025 | ||||
| 11/17/2025 | 11/17/2025 | ||||
| 12/8/2025 | 12/8/2025 | ||||
| 12/29/2025 | 12/29/2025 | ||||
| 1/19/2026 | 1/19/2026 |
Curriculum
Lesson 1: Getting Started with Access 2010
Identify the Elements of the User Interface
Identify the Tabs and Commands on the Ribbon
Obtain Help in Access
Lesson 2: Identifying the Components of a Database
Define Database Concepts
Identify the Components of a Database
Examine the Relational Database Design Process
Lesson 3: Organizing Data in Tables
Create a Table
Modify Table Data and Properties
Create a Table Relationship
Lesson 4: Viewing Data in Tables
Sort Records
Filter Records
View Data from Related Tables
Lesson 5: Querying a Database
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
Create a Form
View Data Using an Access Form
Modify a Form
Lesson 7: Generating Reports
View an Access Report
Create a Report
Add a Calculated Field to a Report
Format the Controls in a Report
Apply a Theme to a Report
Prepare a Report for Print
Lesson 8: Controlling Data Entry
Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field
Lesson 9: Joining Tables
Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table
Lesson 10: Creating Flexible Queries
Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries
Lesson 11: Improving Forms
Restrict Data Entry in Forms
Organize Information with Tab Pages
Add a Command Button to a Form
Create a Subform
Display a Summary of Data in a Form
Change the Display of Data Conditionally
Lesson 12: Customizing Reports
Organize Report Information
Format Reports
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report
Lesson 13: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Lesson 14: Structuring Existing Data
Restructure the Data in a Table
Create a Junction Table
Improve the Table Structure
Lesson 15: Writing Advanced Queries
Create SubQueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart
Lesson 16: Simplifying Tasks with Macros
Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Lesson 17: Creating Effective Reports
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Publish Reports as PDF
Lesson 18: Maintaining an Access Database
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
