AL1 C1 C2 Flashcards
When you delete a table from your computer’s hard drive, the message asking you to confirm the deletion does not display. Why?
Access automatically sends the deleted table to the Recycle Bin, where it can be retrieved.
Each field in a table must have a name that is
unique
What is the first step in creating a table?
Determine the fields.
To create a new database or open a previously created database, click the Windows Start button and then click the
Access tile
What does it mean when a pencil icon displays next to a field entry?
The record is being edited and the changes to the data have not yet been saved
When a database is being designed, one field in each table has an asterisk next to its name. That field is called the
primary key field
Use options in the _____ category in the More Fields button drop-down list to define a data type, assign a field name, and add a group of related fields.
Quick Start
When you have a table open and click the Quick Print option in the Print backstage area, what happens?
The information in the table is sent to the printer without making any changes to the printer setup or the table formatting
When you open a _____, it displays in _____ in the work area.
table; Datasheet view
What data type should you use for a field that will store telephone numbers?
Short Text
Which of the following Access screen elements contains tabs with commands and buttons divided into groups?
ribbon
Adjust field column widths in a table by selecting the columns and then _____ one of the selected column boundary lines.
double clicking
How can you print a table without the table name, date, and page number?
Remove the checkmark from the Print Headings option at the Page Setup dialog box
To control what objects are shown in the Navigation pane, click which of the following?
the button on the menu bar containing the down arrow
A database is composed of a series of _____ used to enter, manage, view, and print data.
objects
Which of the following Access screen elements displays messages, the current view, and view buttons?
Status bar
To freeze a column, click in the column, click the _____ button, and then click _____ at the drop-down list.
More; Freeze Fields
What is the maximum number of characters that can be stored in a field of the Short Text data type?
255
A _____ displays data from a table or related tables that meets a conditional statement and/or performs calculations.
query
A relational database is a database with related
tables
If a new database is opened in the current Access window, what will happen?
the existing database will close
Data in a database is organized into _____, which contain information for related items.
tables
A field is one piece of information about a person, place, or item, and all the fields for one unit are considered a
record
Change a field name by _____ the name, clicking Rename Field at the shortcut menu, and then typing the new name.
right-clicking
When a new field column is added in Datasheet view, where is it added?
to the right of existing fields
The Name & Caption button is in the _____ group on the _____ tab.
Properties; Table Tools Fields
The _____ includes the First and Last record buttons, the Previous and Next record buttons, and the New (blank) record button.
Record Navigation Bar
Which of the following groups is not on the Print Preview tab?
Properties
When creating a table, you can provide additional information about a field as a caption and a(n)
description
One method for deleting a record is
clicking the Delete button arrow on the Home tab and then clicking Delete Record.
The _____ is the base upon which other objects are created.
table
When a field in a column is active, the text typed in the Description text box displays
at the left side of the Status bar
A field name can contain up to _____ characters.
64
When working in a table, press the Tab key to make the next field active or press _____ to make the previous field active.
Shift + Tab
In Access, you can create a table in Datasheet view or in _____ view.
Design
When moving a field column, begin by positioning the mouse pointer on the field name in the header row until the pointer displays as a
down-pointing black arrow
When designing a database, the first principle is to reduce
redundant or duplicate information
A _____allows fields and records to be presented in a layout different from the datasheet.
form
To display a table in Print Preview, click the _____ option at the Print backstage area.
Print Preview
In which situation would you want to define a default value for a field in your table?
when most records are likely to contain the same field value
By default, Access prints a table
in standard letter size
Use the _____ and _____ features to prevent field columns from showing or to view two nonadjacent field columns for comparison.
hide; freeze
If a value is not entered in a field, Access enters a
null value
How are relationships indicated in the Relationships window?
A black line connects the table field list boxes
To display a different subdatasheet, remove the subdatasheet first, before selecting the next subdatasheet. Do this by clicking the _____, pointing to Subdatasheet, and then clicking Remove.
More button
If Cascade Update Related Fields is selected at the Edit Relationships dialog box and changes are made to the primary key field value in the primary table, Access will automatically _____ the matching value in the related table.
update
In the Relationships window, what signifies the “one” side of a one-to-many relationship?
the number 1
In defining a primary key, which step do you complete just before you click the Primary Key button?
Click the field
Suppose that you have not yet established any relationships among your tables. What happens when you click the Relationships button?
The Show Table dialog box displays
What are the two general categories of database management systems?
file management and relational database management systems
When a table is opened, it is sorted by
the primary key field
Data in a foreign key field _____ match data in the primary key field of the related table.
must
File management systems are sometimes referred to as
flat file databases
When a relationship is established between two tables, the primary key in one table is joined to the _____ key in the other table.
foreign
In which situation would using a one-to-one relationship be helpful?
when you need to divide a large table with many fields into two separate tables
If only Enforce Referential Integrity is selected at the Edit Relationships dialog box and the related table contains a record, then a _____ key field value in the primary table cannot be changed.
primary
What is displayed in the three-row grid in the middle of the Edit Relationships dialog box?
the names of the fields to be used to join the tables
Choosing Cascade Update Related Fields and Cascade Delete Related Records at the Edit Relationships dialog box will cause primary key updates and deletions in _____ to be made automatically in _____.
the primary table; the related table
The _____ integrity rules ensure that a record added to a related table has a matching record in the primary table.
referential
Where is the Primary Key button?
in the Tools group on the Table Tools Design tab
In the Relationships window, what signifies the “many” side of a one-to-many relationship?
the infinity symbol (¥)
How does joining tables help ensure data integrity?
by avoiding the need to enter the same data in multiple tables
A table should be about _____ subject(s).
one
Which of the following features is found in a relational database management system but not in a file management system?
the ability to define relationships between tables
To close subdatasheets for all records, begin by clicking the _____ button.
More
What is done at the Show Table dialog box?
Tables are added to the Relationships window
Once a relationship is established between tables, clicking the Relationships button displays which of the following?
the Relationships window
If a table has more than one relationship defined, clicking the expand indicator will display the
Insert Subdatasheet dialog box
To edit a specific relationship, position the mouse pointer _____, click the right mouse button, and then click the Edit Relationship option.
on the middle portion of the black line that connects the related tables
In a one-to-many relationship, the table containing the “one” is referred to as the _____ table.
primary
What happens when you position the mouse pointer on the join line connecting related tables, click the right mouse button, and then click Delete at the shortcut menu?
You are prompted to confirm the deletion
In defining a one-to-many relationship between two tables, what is the next step after placing the two tables in the Relationships window?
Drag the common field from the primary table to the related table
Access is a(n) _____ database management system in which relationships are defined between sets of data.
relational
When you perform a join, you are
establishing a relationship between tables
A database table can contain which of the following two types of key fields?
primary and foreign
To print a report showing the relationships among tables, click the Relationship Report button, which is in the
Tools group in the Relationships window
To display subdatasheets for all records in the primary table, begin by clicking the
More button in the Records group on the Home tab
When a relationship is established between two tables, a subdatasheet displays
records in related tables
What happens if a primary key field is left blank?
Access will not allow closing the database until a value is entered in the field
A one-to-one relationship is _____ a one-to-many relationship.
not as common as
Typically, a primary key field in one table becomes _____ in a related table.
the foreign key field
Which of the following steps should be performed first to edit a relationship?
Click the Relationships button
In planning a database and its related tables, it is important to consider
what each table is about
To add a table to the Relationships window, click the table name at the Show Table dialog box and then click the _____ button.
Add
For primary key fields, Access enforces entity integrity, which means that
it expects a value in the primary key field(s) for each record in the table.
The Relationships window displays _____ that have been defined between tables.
all the relationships
The ability to relate, or _____, tables is what makes Access a relational database system.
join
A relational database management system eliminates the need for
data redundancy
Abbreviate field names so that they are _____ but still easily understood.
as short as possible
The plus symbols (+) in a subdatasheet are referred to as
expand indicators
Relationships between tables are edited
at the Edit Relationships dialog box
To add a new record to an open table, make sure the _____ tab is active and then click the _____ button in the Records group.
Home; New
To insert a new field column in a table in Datasheet view, click in the first cell below the
Click to Add heading
To create a one-to-many relationship, open the database containing the tables to be related and then click the Relationship button in the _____ group on the _____ tab.
Relationships; Database Tools
Changes made to fields in a _____ affect the table and any related tables.
subdatasheet
In database design, the lines drawn between tables that represent relationships are called
join lines
The Add & Delete group is on the _____ tab and contains five buttons for assigning data types plus a More Fields button.
Table Tools Field
Use the keyboard shortcut _____ to display the Open backstage area.
Ctrl + O
What happens if you enter four characters into a text field that has a field size of 2?
Access will not accept the additional text.
Why would you click the Enable Content button?
to indicate that a file originated from a trusted location on your computer
