Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ISTM 210 > access lesson 11 > Flashcards

access lesson 11 Flashcards

1
Q

database

A

large collections of data that are optimized for data storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

QuickStove

A

small company that sells emergency preparedness and backpacking equipment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

create menu tab

A

table design
query design
form design
report design

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

external data menu tab

A

used to import data into Access from external sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

compact and repair database tool

A

analyze the database and reduce the size of the database file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

tables

A

used to store data in access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

queries

A

used to find the specific data from the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

forms

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

reports

A

allow you to organize and present the data in your database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

object view displays…

A

the finished object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

design view is used to…

A

edit the object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

layout view

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

what is the technical term for table

A

relation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

entities

A

information about specific things

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

attribute

A

data stored for each database record

stored in the columns of tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

examples of attributes

A

first name, last name, email address, and address

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

short text data type

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

what is short text data limited to?

A

255 characters

20
Q

long text data type

A

used to store larger amounts of text

21
Q

what is long text data limited to?

A

65536 characters

22
Q

number data type

A

used to store positive and negative numbers

23
Q

date/time data type

A

used to store date or time information

24
Q

currency data type

A

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

25
Q

autonumber data type

A

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

26
Q

yes/no data type

A

used to store data that has only two possible values

27
Q

OLE object data type

A

used to store files created in other programs

28
Q

hyperlink data type

A

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

29
Q

attachment data type

A

used to store files for a database record

30
Q

calculated data type

A

used to create a field that is generated by a formula

31
Q

look up wizard data type

A

used to simplify data entry

32
Q

field size property

A

determines how large the field will be

33
Q

input mask property

A

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

34
Q

default value property

A

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

35
Q

validation rule and validation text properties

A

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

36
Q

required property

A

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

37
Q

what is the first field in a table used for?

A

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

38
Q

foreign key

A

a field used to link two tables

39
Q

why do we normalize data?

A

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

40
Q

one-to-one relationship

A

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

41
Q

one-to-many relationship

A

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

42
Q

many-to-many relationship

A

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

43
Q

what does the 1 on a relationship line mean?

A

“one”

44
Q

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

A

“many”

45
Q

enforce referential integrity button

A

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

46
Q

form

A

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

47
Q

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

A

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

ISTM 210 (23 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions