You need to design a new Access database. The first step is to organize the smallest to largest data, also called:
Hierarchy of data.
Access is a relational database, which means that the data are organized into a collection of related:
Tables
In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called:
A Field
A pre-designed database that contains various pre-built objects is called:
template
Tables and forms are examples of database:
Objects
Each major subject or grouping of information you will store in your database should have a separate:
Table
When you need to create an interface to view, add, update, and delete data in Access, you should use a:
Form
If you want create a formatted, professional way to present and print the contents of your database, you use a:
Report
The last row in an Access table is called the:
Append row
In a database, the special field that contains a unique value for each record is the:
Primary key
If any of your database columns display the ###### symbols, you need to:
Widen the column
When you first open a table in Datasheet view, Access uses the first field to sort the data records:
In ascending order
When you want to view only certain database fields such as product type, use this function:
Filter
You need to find both a particular product type AND a price, you can do this through:
Compound Criteria
Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?
Rich text
When you need to create a new table from scratch in your database, you go to:
Design view
Which of the following must you do before adding a field between existing fields?
Insert a new row
Which of the following is used to enter records into a table?
Datasheet view
Which of the following contains a unique value for each record?
Primary key
When you enter a new field in a table, you are limited to:
64 characters
Which of the following properties indicates the way a field displays in a table?
Format property
When you set field properties, the available properties vary based on the:
Field Data type
The default size of a Short Text field is
255 characters
The property which specifies that a user much enter a value in a field is called:
Required
The overall descriptions about what the different data fields represent and their formats is called:
Metadata
When you limit entries to a certain range of values or making sure entries match a specified format, you use:
Field Validation Rules
How does Access store a "Yes" response for the Yes/No data type?
-1
Which of the following displays the contents of a field and also allows the user to type in a value into that field?
Text box
The field in common between two tables is called the:
Foreign key
When importing data records from Excel, which of these must be true?
The first row of the Excel file must contain the field names from the Access table.
Which of the following finds data in your database by allowing you to ask a question?
Query
To see the results of a query, you need to click:
Run
In Access, the most common way to create queries is with:
Query design
Which of the following tabs do you use to create a query?
Create
In Access, the most common type of query is a
Select Query
When you want to add fields to a query that you have created, put the fields into the:
Design grid
When used in an expression, the asterisk (*) represents any string of characters and is also called:
A wildcard character
Which of the following symbols must you use when defining a parameter query?
[ ]
Which of these should be used to write criterion for a query?
Expression
This operator can help you find records containing data that is similar to the criterion value:
Like comparison
When entering a criterion expression, which of the following tools helps suggest a list of possible values?
Intellisense
Which of the following requires you to enter the specific criteria value when you run the query?
Parameter query
The formula expression for a calculated field is in which of the following formats:
FieldName: Expression
Access provides a variety predefined formulas that perform specific tasks and are called:
Functions
Set the following property in order to have Access evaluate the fields in the query and avoid including duplicated values:
Unique values
An Access object you can use to create an interface to easily view, add, update, and delete data in a database is called:
A form
A form that contains no data but has buttons that perform different actions is referred to as:
Unbound
In this view, you can alter the design of a form and see the effects of the changes in real time.
Layout View
This form option lets you view data in two ways on the same form by combining both a columnar display and a datasheet display.
Split form
An object you can use to create an organized and professional output of the data is called:
A report
This convenient Access feature steps you through the process of quickly creating a report.
Report wizard
This report layout displays the fields in a table (row and column) format:
Delimited
In Access, the fields, labels, buttons, and so forth are all known as:
Controls
This control is used to perform an action such as Close Form, Open Form, Delete Record, etc.
Master control
Click this tab to move a control in a report from one part of the layout to another.
Arrange
To help focus your viewer's attention to certain records in a report, use:
Conditional formatting
To ensure that your report prints as desired, review it in:
Preview
To make the data contained in a report easier to read and understand, a good option is:
Stacking
This option in the Group, Sort, and Total pane changes the wording in the label of the grouping field.
title
To add a date and time to your report, go to:
Header/Footer