HAND-IN ASSIGNMENT: CREATE AN ACTUAL DATABASE IN ACCESS/ all students must hand in a database file which contains a table along with a report. Access Database files end in .accdb

A) DATA BASE CREATION: Colleges You are investigating various schools, colleges and universities. You have decided what you want to study and now need to find the best school for that field of study, however there many other features to be considered, such as tuition and other essential information. You decide which features you want to compare. Create a database with a table to record college features. The table should have at least 8 fields. Fields move across the database and records move down in rows. Research at least six schools. Create a report showing specific information such as tuition. (Examples of fields may include: Tuition, Distance from home, Admission criteria, GPA required for Admission, SAT score, student population, housing, and so on). Microsoft Works and Excel will not be accepted. Excel is not a Database, it is a spreadsheet program; however, data from Excel can be copied and imported in Access Database. This tutorial located on Microsoft Online will guide everyone through the process: https://support.office.com/enus/article/video-copy-data-from-excel-b0bee2b9-e721-4332-869d-51fc9180f411

FYI - LESSON OBJECTIVES: After completing various assignments, students will be able to: 1. Complete a database using Microsoft Access 2. Define the term, database, and explain how a database interacts with data and information. 3. Define the term, data integrity, and describe the qualities of valuable information.