ACCESS TUTORIAL videos 6 and 7 Flashcards
Define Table
1) consists of data that is arrayed in rows and columns
Define record
row of data is called record
Define field
a column of data is called a field
Define calculated field
a field made up of other fields.
not a field in a table. It is created in the query genetorator
entity
tangible thing or event ( employees, customers, inventory, suppliers, sales, hours worked, and purchases
Attibute
a characteristic of an entity
Query
database equivalent of a question that is posed about data in a table(s).
Select Query
select certain data from specific tables based on a given criteria
updating query
queries that update the original data in a database
parameter query
a type of select query that finds the same kind of information repeatedly, but it is different entitles each time
What are six database design rules?
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