Database - Beginner Level Review

Mrs. Leonard maintains a large database of student information. She has identified two student records that have the same name, same enrolled courses, but slightly different student numbers. Only one of them has related quarterly grading records. What should Mrs. Leonard do?

• Delete the record that has the quarterly grades.
• Delete the record that does not have any quarterly grades.
• Move the record with the quarterly grades to a backup database.
• Move the record with no quarterly grades to a backup database.

Your team is complaining about entering data into your table using the Datasheet view. They are asking your help to make data entry easier. Which database component can you use to help your team with data entry?

• Field
• Table
• Record
• Form

Which of the following allows a user to create a table or report based on specific fields within a database?

• Table
• Query
• Field
• Record

Johann is creating a database field which will store descriptive text about products. Which data type should he set for this field?

• Numeric
• Yes/No
• Text
• Memo

Which database component is commonly referred to as a table row within a database?

• Record
• Field
• Title
• Column

Nadia is creating a table of financial transactions. In each record, she will capture the date and type of transaction, the person who recorded it and the amount. Which data type should she set for the field containing the transaction amount?

• Number
• Currency
• Date/Time
• Text

Keisha is a Science Supervisor for all the science teachers in the district. She wants to track all the classes taught by each teacher during school year. What information would be the most helpful for Keisha to have in her database to help her with her tracking?

• Name of Principal, School Address and Name of Teacher.
• Class dates, Class Title and Name of Teacher.
• School Address, Class title and Teacher's Email.
• Class Title, Room number and Name of Principal.

Which of the following is used to retrieve specific information from a database?

• Instance
• Table
• Query
• Keyword

Which of the following consists of multiple tables of information that are related through common fields?

• Relational Database
• Spreadsheet
• Presentation
• Text Document

Mr. Daniels is the basketball coach at school. Which of the following would be his best use of a database?

• The team's game schedule.
• Track student academic eligibility by teacher.
• Organizing sports equipment in the storage room.
• School calendar of holidays.