Level 3: Access Purple Belt
A Level 3 Access Purple Belt is awarded to individuals that have completed all tasks indicating advanced 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
- Modifying Lookup Field Properties
- Adding a Comment to a Stand-Alone Macro
- Creating a Stand-Alone Macro
- Understanding Action Queries
- Updating Records through a Query
- Creating a New Table through a Query
- Deleting Records through a Query
- Moving Records through a Query
- Creating a Crosstab Query
- Creating a New Blank Report in Design View
- Working with a Report in Design View
- Understanding Report Sections
- Arranging Controls in a Report
- Adding Calculated Controls to a Report
- Adding Report Grouping in Design View
- Working with Group Headers and Footers
- Hiding Repeated Values in a Report
- Adding a Subreport Based on a Report
- Adding a Subreport Based on a Table or Query
- Creating a New Blank Form in Design View
- Working with a New Form in Design View
- Controlling Data Entry for a Field in a Form
- Disabling User Interface Elements in a Form
- Adding a Subform Based on a Table or Query
- Adding a Subform Based on a Form
- Modifying the Subform Properties
- Displaying the Form Header and Footer
- Adding Images to Forms
- Creating a Navigation Form with Tabs
- Defining the Tab Order of Controls
- Modifying a Query in SQL View
- Using the Database Documenter
- Using the Table Analyzer
- Using the Performance Analyzer
- Customizing the Navigation Pane
- Splitting a Database
- Creating a Locked ACCDE File
- Encrypting a Database with a Password
- Configuring Database Startup Options
- Limiting Views and Design Options