Access
Excel
Access Design View
100
A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format
What is Datasheet view
100
The selected cell in which data is entered when you begin typing. Only one cell is active at a time
What is active cell
100
How many characters does text field type hold ?
What is 255
200
A view that shows the design of these database objects: tables, queries, forms, reports, and macros
What is Design view
200
The sheet that you're working on in a workbook
What is active sheet
200
Which field type holds more than 255 characters
What is Memo
300
Used to display a title for a form, instructions for using the form, or command buttons that open related forms or carry out other tasks
What is form header
300
small lines of measurement, similar to divisions on a ruler, that intersect an axis
What is tick marks
300
A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values
What is Lookup field
400
One or more fields (columns) whose values uniquely identify each record in a table
What is primary key
400
A named set of input values that you can substitute in a worksheet model
What is scenario
400
In a query, what is the name of the field you have to follow
What is Criteria
500
A pane that is used to view or modify the properties of various objects such as tables, queries, fields, forms, reports, data access pages, and controls
What is property sheet
500
The values that a function uses to perform operations or calculations
What is argument
500
In a Query, What command is used to create a formula
What is Expression Builder
M
e
n
u