Access Chapter 1 Flashcards
Datasheet view
view that enables you to add, edit, and delete the records of a table
Form
an access object that enables you to enter, modify, or delete table data
Compact and Repair
an access utility that reduces the size of the database and can repair a corrupt database.
Object
a main component that is created and used to make a database function
Filter by Form
a filtering method that displaces records based on multiple criteria
Relational Database Management System (RDBMS)
a system that uses the relational model to manage groups of data (tables) and rules (relationships) between tables.
Custom Web App
a database that can be built, used, and shared with others through the use of a host server
Report
an object that contains professional-looking formatted information from underlying tables or queries.
Table
an object used to store data, and the foundation of every database.
Backup Database
an access utility that creates a duplicate copy of the database.
Template
a predefined database that includes professionally designed tables, forms, reports, and other objects.
Filter by Selection
a filtering method that displays only records that math selected criteria.
Relationship
a connection between two tables using a common field
Sort
a method of listing records in a specific sequence
Design View
view that enables you to create tables, add and delete fields, and modify field properties.
Navigation Pane
an access interface element that organizes and lists the database objects in a database.
Query
a question you ask that can help you find and retrieve table data meeting conditions you specify.
Field
the smallest data element in a table, such as first name, last name, address, or phone number.
Record
complete set of all the fields (data elements) about one person, place, event, or concept.
Primary Key
the field (or combination of fields) that uniquely identifies each record in a table.
Which sequence represents the hierarchy of terms, from smallest to largest?
field, record, table, database
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.
Which of the following is not true of an Access database?
every table in a database contains the same number of records as every other table.
Which of the following is true of an Access database?
- Short text, Number, AutoNumber, and Currency are valid data types.
- Every record in a table has the same fields as every other record.
- Each table should contain a primary key; however, a primary key is not required.
Which of the following is true regarding the record selector box?
An orange border surrounds the record selector box and the active record.
Which of the following will be accepted as valid during data entry?
Entering numbers into a text field.
You have finished an Access assignment and wish to turn it in to your instructor for evaluation. As you prepare to transfer the file, you discover that is has more than doubled in size. You should:
Compact and repair the database before sending it to your instructor.
Which of the following conditions is available through “Filter by Selection”?
Equals Condition
An Employees table is open in Datasheet view. You want to sort the names alphabetically by last name and then by first name (e.g., Smith, Andrew). To do this, you must:
First sort ascending on first name and then on last name.
Which of the following is not true when creating relationships between tables?
The common fields used to create a relationship must both be primary keys.
Which of the following is true when creating relationships between tables?
- Join lines create a relationship between two tables.
- The data types of common fields must be the same.
- Enforcing referential integrity ensures that data cannot be entered into a related table unless it first exists in the primary table.
All of the following statements are true about creating a database EXCEPT
the objects provided in a template cannot be modified
All of the following statements are true about creating a database
- Creating a custom Web app requires that you use a host server.
- When creating a blank desktop, Access opens to a blank table in Datasheet view.
- Using a template to create a database saves time because it includes predefined objects.