25.6.13
This website uses cookies to ensure you get the best experience on our website. Learn more

Level 2: Access Yellow Belt

A Level 2 Access Yellow Belt is awarded to individuals that have proven basic 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 New Record in a Table and Entering Data
  • Adjusting Table Column Widths
  • Finding and Replacing Data
  • Deleting Records
  • Creating and Saving a Table in Datasheet View
  • Adding Fields in Datasheet View
  • Creating a Table in Design View and Setting the Primary Key
  • Setting the Default Value Property
  • Applying an Input Mask
  • Adding a Lookup Field from Another Table
  • Adding a Lookup Field from a List
  • Creating Relationships
  • Creating a Split Form
  • Creating a Form Using the Form Wizard
  • Adding Fields to a Form in Layout View
  • Creating a Report Using the Report Wizard
  • Adding Fields to a Report in Layout View
  • Resizing Controls
  • Moving and Arranging Controls
  • Adding Design Elements to Form and Report Headers
  • Grouping Records in a Report
  • Using the Simple Query Wizard
  • Creating a Query in Design View
  • Adding Text Criteria to a Query
  • Adding Numeric and Date Criteria to a Query
  • Specifying the Sort Order in a Query
  • Using a Parameter Query
  • Importing Data from Excel
  • Microsoft Access
  • Access
  • Data Entry
  • SQL
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.

2024-04 2024-04 2024-05 2024-05 2024-06 2024-06 2024-07 2024-07 2024-08 2024-08 2024-09 2024-09 2024-10 2024-10 2024-11 2024-11 2024-12 2024-12 2025-01 2025-01 2025-02 2025-02 2025-03 2025-03 Month 66,000 66,000 68,000 68,000 70,000 70,000 72,000 72,000 74,000 74,000 76,000 76,000 Salary (USD)