ACC 2 - Completion and Modified T/F
The maximum field size for a text field is _.
255
When you want to import data from an Excel worksheet into an Access table, any _ property values set for the fields in the table are not considered in the import process.
Caption
You can quickly insert the value from the same field in the previous record using the _ _ _ (use abbreviation and symbols) keyboard shortcut.
Ctrl + '
The _ _ _ allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually.
Data Type gallery
You can use the _ property to enter an optional description for a field to explain its purpose or usage.
Description
Access allows you to change a field's size in _ view.
Design
Access allows you to modify a table's structure in _ view.
Design
You can create a table by importing the structure of another table into your current database using the _ _ tab on the Ribbon.
External Data
You use the _ _ tab if you want to import data from an Excel worksheet.
External Data
When defining a field, you can obtain more complete Help information about the field's current property, as shown in the item marked 2 in the accompanying figure, by pressing the _ key.
F1
Pressing the _ key allows you to switch between the Table Design grid and the Field Properties pane.
F6
_ is the default Field Size property setting for fields with the Number data type.
Long Integer
If you have a Customer ID field with values like 1234AC, you should use the _ _ data type.
Short Text
Once you click the _ _ button to open the Show Table dialog box, you can choose a table to add to the Relationships window, as shown in the accompanying figure.
Show Table
The _ format is used for currency fields with no dollar signs.
Standard
You use a(n) _ field to connect one table logically with another table.
common
A primary key that is made up of more than one field is called a(n) _ key.
composite
If no one field can be used to make each record unique, you can use a(n) _ _ as the primary key.
composite key
The _ _ determines what field values you can enter for the field and what other properties the field will have.
data type
A _ text file is one in which fields of data are separated by a character such as a comma or a tab.
delimited
A(n) _ is not required for a field, but it is a useful way to explain its purpose or usage.
description
When a primary key has been specified, Access forces you to enter a value for the primary key field in every record in the table. This is known as _ _.
entity integrity
You create a database by first identifying all the _ needed to produce the required information.
fields
The process of relating tables is often called performing a(n) _.
join
The _ custom date format displays the full name of the month (January to December).
mmmm
A(n) _-_-_ relationship exists between the tables in the accompanying figure. (see Schoology)
one to many
A field or collection of fields that uniquely identifies a record within a table is the _ _.
primary key
A foreign key is a field in one table that is also defined as a(n) _ _ in a different table.
primary key
When you change a field's property in Design view, you can _ , or update, the corresponding property on forms and reports that include the field you have modified.
propagate
The characteristics of a field that determine how it is stored and displayed are called the field _.
properties
Unlike calculations with Number data type decimal values, calculations performed with the Currency data type are not subject to _ _.
round-off error
When you select or enter a value for a property, you _ the property.
set
Although you can reorder fields in Datasheet view by dragging a field's column heading to a new location, doing so rearranges only the display of the table's fields; the table _ is not changed.
structure
The name that you use to save a table must be _ within the database.
unique
When you resize a column to its best fit, only the _ field values are affected.
visible
