Microsoft Access 2016 (77-730)
(77-730)
/ ISBN: 9781644591543
This course includes
Lessons
TestPrep
LiveLab
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.
The Microsoft Access 2016 77-730 exam validates a candidate's knowledge of the Access 2016 application's environment and fundamental database design principles. The certified candidates of this exam know the correct application of the basic characteristics of Access 2016 and they can create and maintain basic Access database objects, including data entry forms, tables, relationships, multi-level reports, and multi-table queries.
Lessons
-
15+ Lessons
-
142+ Quizzes
-
83+ Flashcards
-
83+ Glossary of terms
TestPrep
-
17+ Pre Assessment Questions
-
17+ Post Assessment Questions
Lab
-
36+ Performance lab
-
40+ Video tutorials
-
02:20+ Hours
Video Lessons
-
124+ Videos
-
07:14+ Hours
- Getting Started
- Working in the Access Interface
- Summary
- Introducing Tables
- Creating a Table
- Saving and Modifying a Table
- Summary
- 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
- Creating Fields and Modifying Field Properties
- Modifying Database Tables and Fields
- Summary
- Creating a Form
- Sorting and Filtering Data in a Form
- Summary
- Creating a Report
- Working With Reports
- Summary
- Creating a Query
- Modifying a Query
- Sorting and Filtering Data in a Query
- Format Fields Within Queries
- Summary
- 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
- Creating Advanced Forms
- Using Application Parts to Create Blank Forms
- Creating and Modifying a Navigation Form
- Summary
- Defining Groups
- Creating Aggregate Fields
- Creating a Subform on a Report
- Creating the Print Layout
- Using the Label Wizard
- Summary
- Creating Crosstab Queries
- Creating a Subquery
- Filtering and Saving a Filter as a Query
- Creating Action Queries
- Understanding Advanced Query Modification
- Summary
- Creating a Chart Using the Chart Wizard
- Formatting a Chart
- Changing Chart Types
- Saving a Database Object as Another File Type and Printing
- Summary
- Importing Data
- Exporting Data
- Saving and Running Import/Export Specifications
- Summary
- Maintaining a Database
- Using Database Tools
- Encrypting and Decrypting a Database
- Navigating in Access Database
- Improving User Interface Design by Using Macros
- Summary
Hands on Activities (Performance Labs)
- Creating a Blank Database
- Creating a Database from a Template
- Creating a New Table and Changing its Font Style and Size
- Changing Gridlines to Vertical
- 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
- 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
- Creating and Viewing a Form in Form View
- Using the Filter By Form Option
- Creating a New Report and Binding it to a Query
- Sorting a Field of Reports
- Using a Find Duplicates Query Wizard
- Finding Unmatched Records
- Changing Date/Time Controls
- Changing the Width of a Form
- Creating a Basic Form and Applying Themes
- Inserting a Background Image in a Form
- Creating a Split Form
- Creating Labels Using the Label Wizard
- Creating Crosstab Queries
- Saving a Filter as a Query
- Creating an Append Query
- Printing a Database Object
- Importing a Table from Another Access Database
- Exporting Objects to Other Access Databases
- Compacting and Repairing a Database
- Backing Up a Database
- Splitting a Database
| What are the prerequisites for this exam? | There are no technical prerequisites for the certification exam. |
|---|---|
| What is the exam registration fee? | USD 100 |
| Where do I take the exam? | Certiport |
| What is the format of the exam? | The exam consists of performance based questions and is conducted in a live or simulated environment. |
| How many questions are asked in the exam? | The exam contains 40-60 questions. |
| What is the duration of the exam? | 90 minutes |
| What is the passing score? | The passing score varies from exam to exam and is provided on the score report. |
| What is the exam's retake policy? | Microsoft Office Specialist (MOS) exam retake policy
|
| What is the validity of the certification? | For life |
| Where can I find more information about this exam? | To know more about the 77-730, click here. |
| What are the career opportunities after passing this exam? |
|
×
