unit four presentations

Question 1

what is microsoft access

Answer 1

a database creation and management program

Question 2

what is a database?

Answer 2

a collection of data that is stored in a computer system
- they allow users to enter, access, and analyze data quickly and easily
- maintain the validity and consistency of data
- like a collection of lists like at a drs office)

Question 3

what is a relational database?

Answer 3

understands how lists and objects within them relate to one another
- uses keys to link data from different tables together

Question 4

what is the difference between excel and access?

Answer 4

access is stronger at handling non-numerical data (names and descriptions) and uses relational databases to store and analyze non-numerical data

Question 5

what are the four main objects of databases?

Answer 5

tables
queries
forms
reports

Question 6

what are tables?

Answer 6

store all the data
- rows and columns are referred to as records and fields