Access Chapter 1/2 SNAP PRACTICE CONCEPTS – Flashcards
30 test answers
Unlock all answers in this set
Unlock answers 30question
Can more that one object be open in the work area at one time? If so, how are the objects displayed?
answer
Yes; each object is displayed in its own tab
Unlock the answer
question
The process of defining a table's structure involves
answer
assigning a data type to the table's fields, designating a primary key, and determining the fields to be included
Unlock the answer
question
To insert a new field in a table, open the table in Datasheet view and then click
answer
in the first field below the Click to Add heading
Unlock the answer
question
How are joins represented visually in the Relationships window?
answer
A black line connects the common fields in the tables
Unlock the answer
question
What happens when you select a record and select Delete Record from the drop-down list on the Delete button
answer
A message displays asking you to confirm that you want to delete the record
Unlock the answer
question
The ability to relate, or _____, tables is part of what makes Access a relational database system
answer
join
Unlock the answer
question
In a one-to-many relationship, the table containing the "one" is referred to as the _____ table
answer
primary
Unlock the answer
question
_____ integrity rules ensure that a record added to a related table has a matching record in the primary table.
answer
Referential
Unlock the answer
question
The Name & Caption button can be found in the _____ group in the _____ tab.
answer
Properties; Table Tools Fields
Unlock the answer
question
In which situation would a one-to-one relationship be helpful?
answer
when you need to divide a table with many fields into two separate tables
Unlock the answer
question
In the Relationships window, what symbol or character signifies the "many" side of a one-to-many relationship
answer
the infinity symbol (?)
Unlock the answer
question
Each field in a table must contain
answer
a unique name
Unlock the answer
question
When designing a database, the first principle is to reduce
answer
redundant or duplicate information
Unlock the answer
question
When working in a table, you can press _____ to make the next field active or _____ to make the previous field active.
answer
Tab; Shift + Tab
Unlock the answer
question
A database must contain as least one
answer
table
Unlock the answer
question
With options at this category on the More Fields button drop-down list, you can define a data type, field name, and add a group of related fields in one step.
answer
Quick Start
Unlock the answer
question
What does the Navigation pane at the left side of the Access screen display
answer
the objects that are contained in the database
Unlock the answer
question
Which of the following is the keyboard shortcut for hiding the Navigation pane?
answer
F11
Unlock the answer
question
Chapter 2 emphasizes that in planning your database and its related tables, it is important to consider
answer
what each table is "about."
Unlock the answer
question
When a table is displayed in Datasheet view, each column represents a
answer
field in the table
Unlock the answer
question
Regarding the fields you create for a table, what is the difference between the field's name and its caption?
answer
The name is what Access uses for the table and the caption is what displays to users.
Unlock the answer
question
An Access database is made up of a collection of
answer
objects
Unlock the answer
question
You can extract data from two tables as if they were one large table when the tables
answer
are joined on a common field
Unlock the answer
question
If you wanted to print your table without the table name, date, and page number appearing, you would
answer
uncheck the Print Headings option at the Page Setup dialog box
Unlock the answer
question
In which situation would you want to define a default value for a field in your table
answer
when most records are likely to contain the same field value
Unlock the answer
question
In defining a primary key, which quick step do you complete just before you click the Primary Key button
answer
Click the desired field
Unlock the answer
