Microsoft Access 2016 (77-730)
Get certified for the MOS 77-730 exam with the Microsoft Access 2016 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Microsoft Access training course and lab cover the 77-730 exam objectives and impart the skills required for creating and managing a database, building tables, creating queries, creating forms, and creating reports.
- Price: $279.99
- Delivery method: eLearning
- DIR Discount: 20%
Submit form to obtain discount
Test Prep
17+ Pre Assessment Questions |
17+ Post Assessment Questions |
Features
36+ LiveLab |
40+ Video tutorials |
02:20+ Hours
124+ Videos |
07:14+ Hours
Why choose TOPTALENT?
- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.
Outline
Lessons 1:
Introduction to Access 2016
- Getting Started
- Working in the Access Interface
- Summary
Lessons 2:
Creating Database Tables
- Introducing Tables
- Creating a Table
- Saving and Modifying a Table
- Summary
Lessons 3:
Working with Tables and Database Records
- Navigating Specific Records
- Adding, Updating, and Deleting Records
- Working with Primary Keys
- Finding and Replacing Data
- Sorting and Filtering Data and Setting Field Viewing Options Within a Table
- Understanding Table Relationships
- Summary
Lessons 4:
Modifying Tables and Fields
- Creating Fields and Modifying Field Properties
- Modifying Database Tables and Fields
- Summary
Lessons 5:
Creating Forms
- Creating a Form
- Sorting and Filtering Data in a Form
- Summary
Lessons 6:
Creating Reports
- Creating a Report
- Working With Reports
- Summary
Lessons 7:
Creating and Modifying Queries
- Creating a Query
- Modifying a Query
- Sorting and Filtering Data in a Query
- Format Fields Within Queries
- Summary
Lessons 8:
Using Controls in Forms and Reports
- Controls
- Defining Control Tab Order
- Formatting Controls
- Arranging Control Alignment, Size, and Position
- Adjusting Page Margins and Changing Page Orientations for Forms and Reports
- Summary
Lessons 9:
Understanding Advanced Forms
- Creating Advanced Forms
- Using Application Parts to Create Blank Forms
- Creating and Modifying a Navigation Form
- Summary
Lessons 10:
Creating Advanced Reports
- Defining Groups
- Creating Aggregate Fields
- Creating a Subform on a Report
- Creating the Print Layout
- Using the Label Wizard
- Summary
Lessons 11:
Creating Advanced Queries
- Creating Crosstab Queries
- Creating a Subquery
- Filtering and Saving a Filter as a Query
- Creating Action Queries
- Understanding Advanced Query Modification
- Summary
Lessons 12:
Displaying and Sharing Data
- Creating a Chart Using the Chart Wizard
- Formatting a Chart
- Changing Chart Types
- Saving a Database Object as Another File Type and Printing
- Summary
Lessons 13:
Importing and Exporting Data
- Importing Data
- Exporting Data
- Saving and Running Import/Export Specifications
- Summary
Lessons 14:
Understanding Database Tools
- Maintaining a Database
- Using Database Tools
- Encrypting and Decrypting a Database
- Navigating in Access Database
- Improving User Interface Design by Using Macros
- Summary