Sowjana Koka
A Level 1 Access White Belt is awarded to individuals that have completed all tasks indicating basic proficiency in Microsoft Access as determined 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
- Working with Security Warnings
- Organizing Objects in the Navigation Pane
- Switching between Database Object Views
- Navigating Records
- Creating a New Record in a Table and Entering Data
- Sorting Records in a Datasheet
- Adjusting Table Column Widths
- Finding and Replacing Data
- Deleting Records
- Previewing and Printing Database Objects
- Backing Up a Database
- Creating a Desktop Database from a Template
- Creating a New Desktop Database
- Using Compact and Repair
- Creating and Saving a Table in Datasheet View
- Renaming Fields
- Adding Fields in Datasheet View
- Using Quick Start to Add Related Fields
- Deleting Fields in Datasheet View
- Moving Fields in Datasheet View
- Creating a Table in Design View and Setting the Primary Key
- Inserting, Deleting, and Moving Fields in Design View
- Formatting Fields
- Setting the Default Value Property
- Modifying the Field Size Property
- Applying an Input Mask
- Adding a Lookup Field from a List
- Creating Relationships
- Enforcing Deletions and Updates in Relationships
- Creating a Single Record Form Based on a Table or Query
- Creating a Split Form
- Creating a Form Using the Form Wizard
- Creating a New Blank Form
- Adding Fields to a Form in Layout View
- Creating a Report Using the Report Wizard
- Creating a New Blank Report in Layout View
- Adding Fields to a Report in Layout View
- Resizing Controls
- Moving and Arranging Controls
- Modifying the Layout of a Form or Report
- Adding Design Elements to Form and Report Headers
- Adding Page Numbers to Reports
- Grouping Records in a Report
- Adding Totals to a Report
- Previewing and Printing 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
- Using AND in a Query
- Using OR in a Query
- Combining AND and OR in a Query
- Adding a Calculated Field to a Query
- Specifying the Sort Order in a Query
- Hiding and Showing Fields in a Query
- Using a Parameter Query
- Filtering Data Using AutoFilter
- Filtering Data Using Filter by Selection
- Importing Data from Excel
Issued on
October 1, 2019
Expires on
Does not expire