Access Chapter 1
A software system that provides the tools needed to create, maintain, and use a database
Database Management System (DBMS)
Which of the following conditions is available through a Selection filter?
Equal condition
Which of the following is not true of an Access database? a. A primary key uniquely identifies a record. b. Each field has a data type that establishes the kind of data that can be entered. c. Every record in a table has the same fields as every other record. d. Every table in a database contains the same number of records as every other table.
Every table in a database contains the same number of records as every other table.
Where are data stored in a database?
Table
A view that enables the user to create and modify a table design
design view
A piece of information stored in a table, such as a company name or city
field
A method which enables you to specify conditions to display only those records that meet certain conditions
filter
A filtering method that displays records based on multiple criteria
filter by form
An Access object that simplifies entering, modifying, and deleting table data
form
An Access interface element that organizes and lists database objects in a database.
navigation pane
Which of the following utilities is used to recover in the event of loss or damage?
Back Up Database
Which of the following is true regarding table views?
Changes made in Datasheet view are automatically saved when you move the insertion point to a different record.
Which of the following would be matched if you use a Selection filter's exact match option for the title "Manager"?
Manager and MANAGER
All of the following are examples of an Access object except?
Record Objects are: macros, forms, tables, queries
You edit several records in an Access table. When should you execute the Save command?
Records are saved automatically; the save command is not required
A set of common Access components that can be added to an existing database.
application part
To add a predefined table to an existing database, you should use which of the following?
application part
All of the following statements are true about creating a database except: a. A single blank table is provided with a blank database. b. The objects provided in a template cannot be modified. c. Using a template to create a database saves time because it includes predefined objects. d. When creating a blank database, Access opens to a blank table in Datasheet view.
b. The objects provided in a template cannot be modified.
A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported
database
A grid that enables the user to add, edit, and delete the records of a table
datasheet view
A main component that is created and used to make a database function, such as a table or form
object
The field (or combination of fields) that uniquely identifies each record in a table
primary key
A question the user asks about the data in a database.
query
A complete set of all the fields about one person, place, event, or concept.
record
A connection between two tables using a common field
relationship
An object that contains professional-looking, formatted information from underlying tables or queries
report
A filtering method that displays only records that exactly match selected criteria
selection filter
A method of listing records in a specific sequence (such as alphabetically).
sort
An object used to store data, organizing data into columns and rows.
table
A predefined database that includes professionally designed tables, forms, reports, and other objects.
template