Access Chapter 1/2 SNAP PRACTICE CONCEPTS – Flashcards
Unlock all answers in this set
Unlock answersquestion
File management systems are sometimes referred to as
answer
flat file databases
question
If a field is one piece of information about a person, place, or item, then all the fields for one unit make up a
answer
Record
question
The Primary Key button is located in the Tools group in the _____ tab
answer
Table Tools Design
question
If a value is not entered in a field, Access actually enters a
answer
null value
question
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
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
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
question
How are joins represented visually in the Relationships window?
answer
A black line connects the common fields in the tables
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
question
The ability to relate, or _____, tables is part of what makes Access a relational database system
answer
join
question
In a one-to-many relationship, the table containing the "one" is referred to as the _____ table
answer
primary
question
_____ integrity rules ensure that a record added to a related table has a matching record in the primary table.
answer
Referential
question
The Name & Caption button can be found in the _____ group in the _____ tab.
answer
Properties; Table Tools Fields
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
question
In the Relationships window, what symbol or character signifies the "many" side of a one-to-many relationship
answer
the infinity symbol (?)
question
Each field in a table must contain
answer
a unique name
question
When designing a database, the first principle is to reduce
answer
redundant or duplicate information
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
question
A database must contain as least one
answer
table
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
question
What does the Navigation pane at the left side of the Access screen display
answer
the objects that are contained in the database
question
Which of the following is the keyboard shortcut for hiding the Navigation pane?
answer
F11
question
Chapter 2 emphasizes that in planning your database and its related tables, it is important to consider
answer
what each table is "about."
question
When a table is displayed in Datasheet view, each column represents a
answer
field in the table
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.
question
An Access database is made up of a collection of
answer
objects
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
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
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
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
