chapter 4 Flashcards
append
add on to end of an object, for example, adding records to the end of an existing table in a database
arrange tab
tab in the Report Layout toolbar that allows you to make changes to the arrangement of tables, rows and columns in a Report
Autonumber
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
Blank Form
allows you to create a new, blank form, which you can then customize and format the way you want
Bound
control that retrieves data from an underlying table or query
Data
facts about people, events, things or ideas
Data type
classification identifying the kind of data that can be stored in a field such as number, text or dates
Database
organized collection of facts about people, events, things or ideas related to a specific topic or purpose
Datasheet view
Access view that displays data organized in columns and rows similar to an Excel spreadsheet
DBA
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
Design tab
tab in Report Layout toolbar that allows you to make modifications to the design of the Report
Design view
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