chapter 4

Question 1

append

Answer 1

add on to end of an object, for example, adding records to the end of an existing table in a database

Question 2

arrange tab

Answer 2

tab in the Report Layout toolbar that allows you to make changes to the arrangement of tables, rows and columns in a Report

Question 3

Autonumber

Answer 3

data type that describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique. This data type cannot be manually changed or typed in

Question 4

Blank Form

Answer 4

allows you to create a new, blank form, which you can then customize and format the way you want

Question 5

Bound

Answer 5

control that retrieves data from an underlying table or query

Question 6

Data

Answer 6

facts about people, events, things or ideas

Question 7

Data type

Answer 7

classification identifying the kind of data that can be stored in a field such as number, text or dates

Question 8

Database

Answer 8

organized collection of facts about people, events, things or ideas related to a specific topic or purpose

Question 9

Datasheet view

Answer 9

Access view that displays data organized in columns and rows similar to an Excel spreadsheet

Question 10

DBA

Answer 10

Database Administrator, an IT professional whose primary responsibilities include database installation, configuration, design, migration, performance monitoring, security, troubleshooting, as well as backup and date recovery

Question 11

Design tab

Answer 11

tab in Report Layout toolbar that allows you to make modifications to the design of the Report

Question 12

Design view

Answer 12

Access view that displays the detailed structure of a table, query, form, or report. Also known as developer’s view. For Forms and Reports; this may be the only view in which some tasks are performed. Only the controls, not the data are displayed in this view