Access Exam

A "database" is...

• a structured set of data held in a computer, especially one that is accessible in various ways
• spreadsheet program
• owerful presentation software

In a database, a "form" allows you to...

• create a query
• enter data and edit it in a simple form that consists of the fields from a table

In a database, a "table" is a...

• set of data elements using a model of vertical columns and horizontal rows
• spreadsheet program
• presentation program

Keisha wants only Beyoncé songs from her database. What should she use to see and save them?

• Filter
• Form
• Query

Michelle needs each NTHS member to complete an information sheet. Which tool is best?

• Filters
• Form
• Query

Nick wants Access to assign an ID number to each record. What is this called?

• Data Type
• auto numbering
• Properties

The swim coach is looking for swim team purchase orders  that are greater than $200. What criteria would give her this info?

• >200 OR swimming
• >=200 OR swimming
• >200 AND swimming

TRUE OR FALSE:  You can create "reports" in Access Database in order to format data in user friendly way

• TRUE
• FALSE

In a database, a "field" is 

• unique identifier
• user friendly report
• a data structure for a single piece of data composed of records and fields

What Query view is shown in this image?

• Datasheet View
• Design View