Database Concepts and MS Access Assessment

What is the primary purpose of a database form?

• To store raw data only

• To make data entry and viewing more user-friendly

• To create complex calculations

• To delete records permanently

In MS Access, which view allows you to modify the structure and layout of a form?

• Datasheet View

• Query View

• Design View

• Print View

What is a record in a database?

• A collection of fields containing information about one specific item

• The name of a database file

• A type of query

• A collection of tables

Which feature in MS Access helps you create a form automatically?

• Query Wizard

• Table Wizard

• Form Wizard

• Report Wizard

What is the purpose of a query in a database?

• To print reports only

• To create new tables only

• To retrieve specific information based on certain criteria

• To format text in forms

Which symbol is used in query criteria to find records that begin with a specific letter?

• #

• &

• *

• Like "S*"

In Datasheet View, how can you arrange records alphabetically?

• Using Advanced Filter Sort

• Using the Sort button (A to Z or Z to A)

• Using Design View

What is the main difference between Form View and Design View?

• Form View is for entering and viewing data, Design View is for modifying the form's layout

• Form View is for creating queries, Design View is for running queries

• Form View is for printing, Design View is for saving

• Form View is for deleting records, Design View is for adding records

Which tool would you use to find all records where the value is greater than 100?

• Sort tool

• Form Wizard

• Query criteria using > 100

• Advanced Filter Sort

What is the purpose of Advanced Filter Sort?

• To create new databases

• To modify form layouts

• To perform complex filtering and sorting operations

• To print reports only