ACCESS TUTORIAL videos 6 and 7

Question 1

Define Table

Answer 1

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

Question 2

Define record

Answer 2

row of data is called record

Question 3

Define field

Answer 3

a column of data is called a field

Question 4

Define calculated field

Answer 4

a field made up of other fields.

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

Question 5

entity

Answer 5

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

Question 6

Attibute

Answer 6

a characteristic of an entity

Question 7

Query

Answer 7

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

Question 8

Select Query

Answer 8

select certain data from specific tables based on a given criteria

Question 9

updating query

Answer 9

queries that update the original data in a database

Question 10

parameter query

Answer 10

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

Question 11

What are six database design rules?

Answer 11

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