Microsoft Access Skills Inventory
HOW WELL DO YOU UNDERSTAND EACH OF THE FOLLOWING SKILLS?

(Please start by entering your name and your email address.)
Sign in to Google to save your progress. Learn more
First Name *
(Please type accurately!)
Last Name *
(Please type accurately!)
Email Address
(Please type accurately!)
1. Basic Skills *
1-Unfamiliar
2-Confused
3-Starting to Understand
4-Familiar
5-Confident
01-01_ Know what the Navigation pane is
01-02_ Able to separately view lists of tables, queries, forms, and reports
01-03_ Able to sort a table using a single column's values (Sort Ascending, Sort Descending)
01-04_ Able to make a table from scratch in Datasheet View
01-05_ Able to enter data into a table in Datasheet View
01-06_ Able to adjust the width of columns and the height of rows
2. Filter to View a Subset of a Table *
1-Unfamiliar
2-Confused
3-Starting to Understand
4-Familiar
5-Confident
02-07_ Know where the filter tools are
02-08_ Able to Filter by Selection
02-09_ Able to Filter by Form (point-and-click method)
02-10_ Able to Filter by Form (typing method)
02-11_ Understand search wildcard characters (* and ?)
02-12_ Able to save a Filter by Form as a query
3. Create a Report or a Form *
1-Unfamiliar
2-Confused
3-Starting to Understand
4-Familiar
5-Confident
03-13_ Able to make a simple report in one step
03-14_ Able to make a simple form in one step
03-15_ Able to make a report using the multi-step wizard
03-16_ Able to make a form using the multi-step wizard
4. Design View and Layout View *
1-Unfamiliar
2-Confused
3-Starting to Understand
4-Familiar
5-Confident
04-17_ Able look at an object in Design View, and switch back to normal view
04-18_ Able to create a table from scratch in Design View
04-19_ Able to modify the size, position and labeling of form/report elements in Design View
04-20_ Able to modify the size, position and labeling of form/report elements in Layout View
5. Import and Export *
1-Unfamiliar
2-Confused
3-Starting to Understand
4-Familiar
5-Confident
05-21_ Able to create a new table by importing data from an Excel file
05-22_ Able to export a table's data to an external file (text, Excel, Word)
6. Queries *
1-Unfamiliar
2-Confused
3-Starting to Understand
4-Familiar
5-Confident
06-23_ Able to set up a query using the Simple Query Wizard
06-24_ Able to modify a selection criterion in Design View
06-25_ Understand the "logical AND" arrangement of multiple criteria
06-26_ Understand the "logical OR" arrangement of multiple criteria
06-27_ Able to turn on and off the display of specific fields in Datasheet View
06-28_ Able to sort specific fields in Design View
06-29_ Able to filter or sort the results of a query in Datasheet View
7. Basic Relational DatabaseSkills *
1-Unfamiliar
2-Confused
3-Starting to Understand
4-Familiar
5-Confident
07-30_ Able to build a combo box in a table that gets values from another table or query
07-31_ Able to build a combo box in a table that gets values from a typed-in list
07-32_ Able to adjust the width of combo box columns in Design View
Submit
Clear form
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy
Google Forms