access lesson 11

Question 1

database

Answer 1

large collections of data that are optimized for data storage

Question 2

QuickStove

Answer 2

small company that sells emergency preparedness and backpacking equipment

Question 3

create menu tab

Answer 3

table design
query design
form design
report design

Question 4

external data menu tab

Answer 4

used to import data into Access from external sources

Question 5

compact and repair database tool

Answer 5

analyze the database and reduce the size of the database file

Question 6

access can automatically analyze a database file and reduce the size of the file every time the file is closed

Answer 6

options in the file menu tab
current database tab
“compact on close”

Question 7

tables

Answer 7

used to store data in access

Question 8

queries

Answer 8

used to find the specific data from the database

Question 9

forms

Answer 9

present the data from the table in a separate window one record at a time

Question 10

reports

Answer 10

allow you to organize and present the data in your database

Question 11

object view displays…

Answer 11

the finished object

Question 12

design view is used to…

Answer 12

edit the object

Question 13

layout view

Answer 13

like design view but provides fewer options for manipulating the object and is often easier to use than the design view

Question 14

what is the technical term for table

Answer 14

relation

Question 15

entities

Answer 15

information about specific things

Question 16

attribute

Answer 16

data stored for each database record

stored in the columns of tables

Question 17

examples of attributes

Answer 17

first name, last name, email address, and address

Question 18

short text data type

Answer 18

used to store most data that won’t be treated like a number (used in calculations) such as text, telephone numbers, and zip codes

Question 19

what is short text data limited to?

Answer 19

255 characters

Question 20

long text data type

Answer 20

used to store larger amounts of text

Question 21

what is long text data limited to?

Answer 21

65536 characters

Question 22

number data type

Answer 22

used to store positive and negative numbers

Question 23

date/time data type

Answer 23

used to store date or time information

Question 24

currency data type

Answer 24

a number data type that places a currency symbol ($) in front of the number

Question 25

autonumber data type

Answer 25

a number data type (unique value for each record added)

Question 26

yes/no data type

Answer 26

used to store data that has only two possible values

Question 27

OLE object data type

Answer 27

used to store files created in other programs

Question 28

hyperlink data type

Answer 28

used to store links to websites or other folders or files on your computer

Question 29

attachment data type

Answer 29

used to store files for a database record

Question 30

calculated data type

Answer 30

used to create a field that is generated by a formula

Question 31

look up wizard data type

Answer 31

used to simplify data entry

Question 32

field size property

Answer 32

determines how large the field will be

Question 33

input mask property

Answer 33

used to set rules for how the data will be entered for the field

Question 34

default value property

Answer 34

used to automatically set a starting value for a field when. a new record is added to the table

Question 35

validation rule and validation text properties

Answer 35

(work together) used to check values when they are entered into a table to make sure they fit a specific rule

Question 36

required property

Answer 36

used to make sure that the value is entered for a field when a new record is added to a table

Question 37

what is the first field in a table used for?

Answer 37

uniquely identify each of the records on the table (primary key)

Question 38

foreign key

Answer 38

a field used to link two tables

Question 39

why do we normalize data?

Answer 39

to ensure that each table contains data about very specific things limit duplicated/redundant information

Question 40

one-to-one relationship

Answer 40

occurs when a record from one table can only be associated with only one record from the other table

Question 41

one-to-many relationship

Answer 41

the most common type of relationship occurs when a single record from one table could be associated with more than one record from the other table, but a record from the second table can only be associated with one record from the first table

Question 42

many-to-many relationship

Answer 42

occur when a record from one table may be associated with more than one record from another table and a record from the second table may also be associated with more than one record from the first table

Question 43

what does the 1 on a relationship line mean?

Answer 43

"one"

Question 44

what does the oo (infinity) on a relationship line mean?

Answer 44

"many"

Question 45

enforce referential integrity button

Answer 45

the user will only be able to add an employee ID on the "reseller" table that already exists on the "Employee" table

Question 46

form

Answer 46

a window that displays the data in a table to the user

Question 47

how you you change the arrangement of the fields on the form?

Answer 47

just drag the fields where we want them to be in the layout view