Microsoft Access 2013 Chapter 1 – Flashcards
Unlock all answers in this set
Unlock answersquestion
Access work area
answer
Where you work on objects such as tables, forms, and reports
question
AutoCorrect
answer
Corrects common data entry errors
question
backup copy
answer
Copy of the database used if problems occur with the original
question
Byte
answer
Field size in which the integer value is in the range of 0 to 255
question
caption
answer
Used whenever you want something other than the field name displayed
question
Click to Add
answer
To define an additional field, click or tap this heading
question
column headings
answer
Descriptions of the contents of the column, rather than data
question
criterion
answer
Condition that records must satisfy in order to be included in query results
question
Currency
answer
Data type where the field can contain only monetary data
question
data type
answer
Indicates the type of data that can be stored in the field
question
database
answer
Collection of organized data
question
database design process
answer
Process of determining the tables and fields that make up the database
question
database management system
answer
Software that allows you to use a computer to create a database
question
database properties
answer
Details about a file
question
datasheet
answer
Table represented as a collection of rows and columns
question
Datasheet view
answer
View where data in the table is presented in rows and columns
question
description
answer
Explains important details about a field
question
Design view
answer
View used to create a table or to modify the structure of the table
question
Detail
answer
In a query, this option shows all the records and fields
question
field size
answer
Storage space assigned to the field by Access
question
fields
answer
Columns in the table
question
form
answer
Formatted document with fields that contain data
question
Form view
answer
Data is displayed in a form on the screen
question
hard copy
answer
Information that exists on a physical medium
question
import
answer
To make a copy of the data as a table in the Access database
question
Integer
answer
Field size in which the integer value is in the range of -32,768 to 32,767
question
keywords
answer
Words or phrases that further describe the database
question
landscape orientation
answer
Printout is across the height of the page
question
layout
answer
Design of a table
question
list
answer
Rows and columns where column entries represent the same data type
question
Navigation buttons
answer
Buttons used to move within a table
question
Navigation Pane
answer
Contains a list of all the objects in the database
question
Number
answer
Data type where the field can contain only numbers
question
object tabs
answer
Appear at the top of the work area for open objects
question
portrait orientation
answer
Printout is across the width of the page
question
primary key
answer
Another term for unique identifier
question
Print Preview
answer
View that shows the report as it will appear when printed
question
queries
answer
Questions the database can answer
question
records
answer
Rows in the table
question
redundancy
answer
Storing the same fact in more than one place
question
relational database
answer
Database of tables with information on a specific subject
question
reserved words
answer
Words that have a special meaning to Access
question
row selector
answer
Small box that precedes the field
question
Short Text
answer
Data type where the field can contain any character
question
status bar
answer
Presents information about a database object and progress of current tasks
question
Summary
answer
In a query, this option only shows computations
question
systems analysis
answer
Determination of database requirements is part of this process
question
unique identifier
answer
Way of uniquely identifying each record in the database
