stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Microsoft Access 2010 Chapter 1 Flashcards | StudBud
Explore
/
Microsoft Access 2010 Chapter 1
Microsoft Access 2010 Chapter 1
49 terms
·
StudBud Administration
·
513 plays
Microsoft Access 2010 Chapter 1 Terms
Flashcards
49 cards
F
Practice quiz
P
Host live
L
Questions
49
Answers
1
Questions the database can answer
Problems
Searches
Queries
Help
2
Storing the same fact in more than one place
Infeffective
Storage
Repetion
Redundancy
3
Data type where the field can contain only monetary data
Money
currency
number
cash
4
The most common type of relationship between tables
muti-relation
multiple relationships
One-to-Many Relationship
5
Numeric values with decimals place to more accuracy that Single
Double
three
two numbers
Triple
6
Indicates the type of data that can be stored in the field
data mode
database
data field
data type
7
Printout is across the width of the page
Width
Print Preview
Portrait Orientation
Landscape
8
To define an additional field, click this heading
Click to Add
click
click to lose
click to put
9
Columns in the table
fields
cells
rows
row+column
10
Software that allows you to use a computer to create a database
database management
Database user
Microsoft Excel
criterion
11
Numeric values decimal places beyond Single and Double
Point
Comma
Asterics
Decimal
12
Collection of organized data
Powerpoint
list
excel
database
13
Word or phrases that further describe the database
keycodes
special words
password
keywords
14
View shows the report as it will appear when printed
Save Computer
Print Property
Print Preview
Print Layout
15
View used to create a table or to modify the structure of the table
Form
Datasheet View
Design view
Design Layout
16
Rows in the table
Records
Information
Field
Entry
17
Tables are the ____ you use to store and manipulate data
Objects
Symbols
Items
Sources
18
Design of a table
setup
Layout
form
look
19
Information that exists on a physical medium
hard copy
medium copy
medium-soft copy
soft copy
20
Table represented as a collection of rows and columns
Word document
spreadsheet
Double
datasheet
21
Variety of components to make your work more efficient
Access House
Access Door
Access Window
Access Area
22
Where you work on objects such as tables, forms, and reports
Bit
Access work area
The Office
Access Work Zone
23
___ for open objects appear at the top of the work area
shape tabs
Number tabs
Object Tabs
database tabs
24
Contains a list of all the objects in the database
navigation slate
side bar
Object List
Navigation PAne
25
Copy of the database used if problems occur with the original
backstop
backup copy
foward copy
backup
26
Where you work on objects such as tables, forms, and reports
The Office
Bit
Access Work Zone
Access work area
27
Integer value in the range of 0 to 255
Terabyte
Character
Byte
milibyte
28
Shorthand representation of the structure of a relational database
DLDB
DLBD
DBDL
DDBL
29
____the column changes its size
widing
resizing
resizer
rezoning
30
Integer value in the range of -2,147,483,648 to 2,147,483,647
Short Number
Long Number
Long Integer
Short Ineger
31
Details about a file
metadata
database properties
SLQ
DBDL
32
Numeric values with decimal places to seven significant digits
Double
Triple
Single
Couple
33
Value in the range of -32,768 to 32,767
rational number
number
Integer
Value
34
Excel data in rows with heading in top row
List
Column
Row
Field
35
In a query, this option shows all the records and fields
option
description
detail
in-depth
36
Printout is across the height of the page
Layout View
Portiate Orientation
Landscape Orientation
Design View
37
Formatted document with fields that data
cell
paper
form
list
38
Determination of database requirements is part of this process
status bar
system analysis
conclusion
summary
39
Another term for unique identifier
Primary Word
Primary Key
Seconday Key
Main Field
40
Words that have a special meaning to Access
Keyword
Illegal Words
Reserved Words
Locked Words
41
Data type where the field can contain any character
Character
Text
Record
Index
42
Data type where the field can contain only numbers
Currency
Number
index
lookup
43
In a query, this option only shows computations
conclusion
paragraph
Summary
status bar
44
Special identifier required for replication
Redo ID
Repeat ID
Replication ID
Copy ID
45
View where data in the table is presented in rows and columns
Design View
Graph View
Datasheet view
Work View
46
Small box that precedes the field
picker
column selector
area selector
Row Selector
47
Database of tables with information on a specific subject
Relational Database
Reasonable Database
Spreadsheet
Data Relation
48
Presents information about the database object
Work Area
Status Bar
Married
Single
49
Condition that the records to be included must satisfy
validation
Criteria
criterion
rules
