NEW
Font size
WorksheetsDatabase Concepts and MS Access Assessment
Total questions: 10
Worksheet time: 5mins
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
