Level 4: Access Black Belt
A Level 4 Access Black Belt is awarded to individuals that have proven advanced proficiency in Microsoft Access as assessed by the McGraw-Hill SIMnet platform.
Skills listed within this credential are provided as an example of the minimum knowledge base expected to be completed within the course.
Skills / Knowledge
- Creating a Desktop Database from a Template
- Organizing Objects in the Navigation Pane
- Adding a Lookup Field from Another Table
- Modifying Lookup Field Properties
- Creating a Stand-Alone Macro
- Adding a Comment to a Stand-Alone Macro
- Understanding Action Queries
- Updating Records through a Query
- Moving Records through a Query
- Deleting Records through a Query
- Creating a New Table through a Query
- Creating a Crosstab Query
- Finding Duplicate Data Using a Query
- Finding Unmatched Data Using a Query
- Understanding Report Sections
- Adding Report Grouping in Design View
- Working with Group Headers and Footers
- Creating a New Blank Report in Design View
- Working with a Report in Design View
- Arranging Controls in a Report
- Adding Calculated Controls to a Report
- Hiding Repeated Values in a Report
- Adding a Subreport Based on a Report
- Adding a Subreport Based on a Table or Query
- Creating a Blank Form from an Application Part
- Creating a New Blank Form in Design View
- Displaying the Form Header and Footer
- Defining the Tab Order of Controls
- Controlling Data Entry for a Field in a Form
- Disabling User Interface Elements in a Form
- Adding a Subform Based on a Form
- Adding a Subform Based on a Table or Query
- Modifying the Subform Properties
- Adding Images to Forms
- Creating a Navigation Form with Tabs
- Importing Data from Excel
- Importing Data from a Text File
- Adding Records to a Table by Importing
- Exporting Data to Excel
- Exporting Data to a Text File
- Using the Table Analyzer
- Using the Database Documenter
- Customizing the Navigation Pane
- Deleting and Renaming Database Objects
- Using the Performance Analyzer
- Splitting a Database
- Linking to a Table in another Access Database
- Encrypting a Database with a Password
- Creating a Locked ACCDE File
- Modifying a Query in SQL View
- Limiting Views and Design Options
- Configuring Database Startup Options
- Sorting Records in a Datasheet
- Filtering Data Using Filter by Selection
- Filtering Data Using AutoFilter
- Creating a Table in Design View and Setting the Primary Key
- Creating Relationships
- Creating Field Validation Rules
- Creating Record Validation Rules
- Adding a Lookup Field from a List
- Creating a Form Using the Form Wizard
- Applying Conditional Formatting to a Report
- Adding Fields to a Form in Layout View
- Controlling Data Entry in a Form
- Adding a Command Button Control to a Form
- Creating a Report Using the Report Wizard
- Grouping Records in a Report
- Creating a Query in Design View
- Adding Totals to a Query
- Adding Text Criteria to a Query
- Combining AND and OR in a Query
- Using a Parameter Query
- Adding a Calculated Field to a Query
- Microsoft Access
- Access
- MOS
- Data Entry
- SQL
- Queries
- Access Expert
- Database
Job Insights
These are the most common job titles and employers with the most open positions related to this credential.
Showing results for United States.
Top job titles related to this credential
Average salary trend for undefined
Chart
Table