Access®™ Assessment Form

Access®™ Assessment Form

Are you familiar with the ribbon/tools of Microsoft Access
Do you understand what a database is and why you’d use one
Have you created a simple Access database
Do you know how to modify table data
Have you sorted and filtered records and created Lookups
Have you joined data from different tables in a query
Can you sort and filter records
Can you sort and filter data in a query
Have you performed calculations in a Query
Can you create Parameter & Action Queries
Can you create Unmatched and Duplicate Queries
Have you summarized data in a database
Can you create a Report & Add Controls to a Report
Do you understand what a Relational Database is
Can you create a Table and Table Relationships
Can you create Query Joins with & without common fields
Have you related data within a Table
Can you work with Subdatasheets and Create Subqueries
Know what it means to Normalize Data
Can you create a Junction Table & improve Table Structure
Have you Imported & Exported Data to Text Files & Excel Formats
Have you used Access to perform a Mail Merge
Have you organized report information & formatted reports
Have you added a calculated field to a Report
Have you added a sub-report to existing Report
Have you created sub-form
Have you validated Field, Record and Form Information
Have you created Macros in Access
Can you validate and automate data entry with macros
Have you linked tables to external data sources
Have you previously managed and documented database changes
Can you split a database for multiple users
Have you implemented database security and passwords
Have you created / modified a database switchboard

Computer Knowledge

I am comfortable using a keyboard and mouse
I know how to download an app
I know how to test my microphone and camera
I have used Zoom before

How can we reach you?