Microsoft Office Word 2016 Expert (77-725 & 77-726)
Microsoft 77-725-77-726
Microsoft Office Word 2016 Expert (77-725 & 77-726)
ISBN: 978-1-64459-150-5Microsoft 77-725-77-726
Microsoft Access 2016 (77-730)
Become a certified Microsoft Access 2016 professional with this online training program. Learn with our fully interactive learning features & Live Labs.
(77-730) / ISBN : 978-1-64459-154-3This course includes
Interactive Lessons
Gamified TestPrep
Hands-On Labs
AI Tutor (Add-on)
56
Reviews
About This Course
Enroll for our Microsoft Access 2016 online training program to prepare and practice for the 77-730 certification exam. The course curriculum focuses on creating, modifying, and managing Microsoft Access Database objects. It has been equipped with 124+ video tutorials and 36+ hands-on lab exercises to make your learning more interactive. By the end of this Microsoft Access training course, you’ll be able to create and organize databases for storing information, design user-friendly interfaces for data entry, perform complex data manipulations, and optimize database performance and security.
Skills You’ll Get
- Create database tables with entry fields and data types
- Manage relationship between data tables to ensure integrity and consistency
- Use queries and forms to add, update, delete, and retrieve data
- Execute data calculations using sum, average, count
- Perform data manipulation for sorting, filtering, and grouping
- Extract information from database by creating simple & complex queries
- Ability to build parameterized queries for dynamic data retrieval
- Automate data manipulation with action queries
- Ability to create, design & customize forms and reports
- Using subqueries to perform nested queries within a query
- Encrypting and decrypting databases for data protection
- Knowledge of database maintenance best practices
Interactive Lessons
15+ Interactive Lessons | 142+ Quizzes | 82+ Flashcards | 82+ Glossary of terms
Gamified TestPrep
17+ Pre Assessment Questions | 17+ Post Assessment Questions |
Hands-On Labs
36+ LiveLab | 40+ Video tutorials | 02:20+ Hours
Video Lessons
124+ Videos | 07:14+ Hours
1
Introduction to Access 2016
- Getting Started
- Working in the Access Interface
- Summary
2
Creating Database Tables
- Introducing Tables
- Creating a Table
- Saving and Modifying a Table
- Summary
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
4
Modifying Tables and Fields
- Creating Fields and Modifying Field Properties
- Modifying Database Tables and Fields
- Summary
5
Creating Forms
- Creating a Form
- Sorting and Filtering Data in a Form
- Summary
6
Creating Reports
- Creating a Report
- Working With Reports
- Summary
7
Creating and Modifying Queries
- Creating a Query
- Modifying a Query
- Sorting and Filtering Data in a Query
- Format Fields Within Queries
- Summary
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
9
Understanding Advanced Forms
- Creating Advanced Forms
- Using Application Parts to Create Blank Forms
- Creating and Modifying a Navigation Form
- Summary
10
Creating Advanced Reports
- Defining Groups
- Creating Aggregate Fields
- Creating a Subform on a Report
- Creating the Print Layout
- Using the Label Wizard
- Summary
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
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
13
Importing and Exporting Data
- Importing Data
- Exporting Data
- Saving and Running Import/Export Specifications
- Summary
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
D
Appendix: 3D Avatar-based Simulation
1
Introduction to Access 2016
- Creating a Blank Database
- Creating a Database from a Template
2
Creating Database Tables
- Creating a New Table and Changing its Font Style and Size
- Changing Gridlines to Vertical
3
Working with Tables and Database Records
- Deleting a Record
- Adding Records to a Database Table
- Finding and Replacing a Specific Value
- Calculating Average and Exporting a Table in Text Format
- Hiding the Fields
- Creating a Relationship Between Tables
4
Modifying Tables and Fields
- Opening a Table in Design View and Editing its Field Properties
- Renaming a Table
- Deleting a Table from a Database
- Changing the Title Bar Text with the Caption Property
- Creating Multivalued Lookup Fields
5
Creating Forms
- Creating and Viewing a Form in Form View
- Using the Filter By Form Option
6
Creating Reports
- Creating a New Report and Binding it to a Query
- Sorting a Field of Reports
7
Creating and Modifying Queries
- Using a Find Duplicates Query Wizard
- Finding Unmatched Records
8
Using Controls in Forms and Reports
- Changing Date/Time Controls
- Changing the Width of a Form
- Creating a Basic Form and Applying Themes
- Inserting a Background Image in a Form
9
Understanding Advanced Forms
- Creating a Split Form
10
Creating Advanced Reports
- Creating Labels Using the Label Wizard
11
Creating Advanced Queries
- Creating Crosstab Queries
- Saving a Filter as a Query
- Creating an Append Query
12
Displaying and Sharing Data
- Printing a Database Object
13
Importing and Exporting Data
- Importing a Table from Another Access Database
- Exporting Objects to Other Access Databases
14
Understanding Database Tools
- Compacting and Repairing a Database
- Backing Up a Database
- Splitting a Database
Any questions?Check out the FAQs
Know more about our Microsoft Access 2016 (77-730) online training course.
Contact Us NowIt is an online training course that is especially designed to equip you with the skills needed to pass the 77-730 certification exam. It gives you access to our interactive learning content and lab activities focused on creating and managing databases, creating queries, building tables, and creating forms and reports.
All those wanting to improve their data management skills and demonstrate their ability to use the Access 2016 features for passing the 77-730 exam should take up this course. Professionals who need to manage databases for their jobs include Database administrators, Data analysts, Business analysts, Accountants, Researchers, and Office administrators.
As a prerequisite, you should have understanding of the basic data concepts: data types, fields, records, and tables is recommended for better understanding. Expertise in Microsoft Office applications is an added advantage.
The average annual salary of a Microsoft office specialist in data management roles ranges from $78,000 to $100,000.
Yes, it is a beginner friendly course that helps you build on your data management skills gradually.
The certification fee is $100.
Related Courses
All Course
Microsoft Office Excel 2016 Expert (77-727-77-728)
Microsoft 77-727-77-728
Microsoft Office Excel 2016 Expert (77-727-77-728)
ISBN: 978-1-64459-140-6Microsoft 77-727-77-728
Microsoft Azure Administration (AZ-104)
Microsoft AZ-104.AP2
Microsoft Azure Administration (AZ-104)
ISBN: 978-1-64459-322-6Microsoft AZ-104.AP2
Developing Solutions for Microsoft Azure
Microsoft AZ-204.AP1
Developing Solutions for Microsoft Azure
ISBN: 978-1-64459-363-9Microsoft AZ-204.AP1
Designing Microsoft Azure Infrastructure Solutions
Microsoft AZ-305.AP1
Designing Microsoft Azure Infrastructure Solutions
ISBN: 978-1-64459-421-6Microsoft AZ-305.AP1