Computer Applications Dec. 1 -Pop Quiz SOLUTION

Hi, this is a pop quiz, surprise.

In a Word document, impress me with your knowledge of Access databases. Answer the following questions in 4-5 complete sentences, per question. Tell me everything you know about...

1. Databases and tables (6 points)

ANSWER: A database is an organized collection of information that can be retreived, sorted and filtered. Databases are similar to Excel but have more powerful features like better reporting, multi-user and user-based security. Databases have one or more tables in them. The tables contain organized information for one entity, like all the students in a school or all the patients in a doctor's office. Tables are the most important part of a database because they contain the information.

2. Records vs. fields, how are they related? what's the difference? (6 points)

ANSWER: A record is all the information collected for one person, or entity in a table. It is represented by one row in a table. If there are 400 students in a school, there will be 400 records in the student table. It is a one-to-one ratio. In a record there can be many fields, such as first name, last name, address, city, state, zip. Each piece of information you keep for a record is called a field. A field name can be "Address1" and the field value would be "1627 S. Main Street" for that field.

3. What makes Renweb a database? how does it paralell to what we have been learning? Give another real-world example of a database and what tables, records and fields it has. (8 points)

ANSWER: Renweb is a database because it is an organized collection of the students, grades, teachers, classes, etc. for a school. It can be retrieved, sorted, filtered and reported. The tables in Renweb are just like the tables in Access. Students can retrieve information in Renweb just like Access information can be retrieved in queries. Another real world example is eBay. The tables are the lists of stuff for sale that you see when you search it. Sellers add to the table of items for sale every time they post something. When a buyer looks for something for sale by lowest price they are searching certain fields such as "description" and "price."

SAVE and PRINT your Word document for me :-)