Functions/Formulas
Ribbon Tabs
Databases
Tables
Queries
100
Gives the number of entries within a range
What is Count
100

Has the most commonly used commands

What is the Home Tab

100
A relationship where one thing relates to multiple things.
What is one to many
100
Used to tell the user what the field is about.
What is description?
100
The easiest way to make a query.
What is Query Wizard
200
This function automatically adds the numbers in a range.
What is Autosum
200
The tab that has the Spellchecker and the Thesaurus.
What is Review
200
A database object that you can use to create a user interface for a database application.
What is a Form
200
Used to directly link to a part of the database, a webpage, or an e-mail
What is Hyperlink
200
Allows you to build a query from scratch.
What is Query Design View
300
The function that returns the current date
What is Today
300
What Excel tab include Margins, Orientation, and Themes.
What is Page Layout
300
Used to create subsets of data that you can use to answer questions.
What is a Query
300
Tells the type of information entered into a cell.
What is Data Type
300
Determines the order that data in a query is displayed.
What is Sort
400
What function returns the current date and time
What is Now
400
The tab that you use to create Tables, Queries, and Forms
What is Create
400
Used to view, format, and summarize data.
What is a report
400
The view that allows you to edit data type, field names, and descriptions.
What is Design View
400
Determines if the information appears when you run the query.
What is Show
500
Function that returns true or false.
What is Logic
500
The tab in Access that has the Relationship command.
What is Database Tools
500
What is the maximum amount of characters allowed in a text field in Access.
What is 255
500
Allows you to make very specific changes to a table.
What is Properties
500
Allows you to create equations using information from the queries, functions, constants, or operators.
What is Builder
M
e
n
u