ACCESS TUTORIAL videos 6 and 7 Flashcards

1
Q

Define Table

A

1) consists of data that is arrayed in rows and columns

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

Define record

A

row of data is called record

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

Define field

A

a column of data is called a field

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

Define calculated field

A

a field made up of other fields.

not a field in a table. It is created in the query genetorator

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

entity

A

tangible thing or event ( employees, customers, inventory, suppliers, sales, hours worked, and purchases

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

Attibute

A

a characteristic of an entity

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

Query

A

database equivalent of a question that is posed about data in a table(s).

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

Select Query

A

select certain data from specific tables based on a given criteria

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

updating query

A

queries that update the original data in a database

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

parameter query

A

a type of select query that finds the same kind of information repeatedly, but it is different entitles each time

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

What are six database design rules?

A

1) you dont need a table for the business. The database represents the entire business
2) identify the entities in the business description
3) Look for relationships among the entities
4) look for attributes of each entity and designate an primary key
5) avoid data redundancy
6) Do not include a field if it can be calculated from other fields

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