Font size
WorksheetsPITS MS Access Quiz
Total questions: 50
Worksheet time: 25mins
MS Access is classified as a:
Spreadsheet software
Database management system
Word processor
Presentation software
Which of the following is a unique identifier for a record in a table?
Field size
Data type
Primary key
Caption
A collection of related records in Access is known as a:
Form
Table
Query
Report
Which table view allows you to define fields, data types, and properties?
Datasheet View
Layout View
Design View
Report View
Which data type is suitable for storing price values in Access?
Text
Memo
Currency
Date/Time
Which property ensures that no blank entries are allowed in a field?
Default value
Required
Caption
Validation rule
Which Access object is used to display and enter data graphically?
Report
Query
Form
Macro
Which Access feature reduces redundant data across tables?
Normalization
Sorting
Filtering
Importing
What does a query primarily do?
Store raw data
Ask questions about data
Print documents
Format tables
Which query type allows input criteria at runtime?
Select Query
Crosstab Query
Parameter Query
Update Query
What symbol is automatically added in date criteria in queries?
“ ”
# #
$$
%%
In a query, the AND operator means:
At least one condition must be true
Both conditions must be true
None must be true
Either condition must be false
Which function in a query provides alternate actions similar to Excel?
SUM
IIF
COUNT
AVG
Which of the following allows calculations in queries?
Parameter Fields
Expressions
Macros
Report Wizard
Which of the following is an example of a calculated field?
Age: Date()-DOB
On Hand * Cost
Selling Price - Discount
All of the above
Which object is best for printing summaries of data?
Report
Form
Query
Switchboard
What is the correct order when creating a table relationship?
Create → Save → Delete
Select fields → Drag → Create
Query → Report → Relationship
Sort → Filter → Join
In Datasheet View, what does each row represent?
Table
Field
Record
Query
Which Access tool is used to quickly create a form?
Report Wizard
Form Wizard
Macro Wizard
Switchboard Manager
A query that displays summarized data grouped by fields is called:
Crosstab Query
Select Query
Action Query
Simple Query
Which criteria would retrieve all items with a cost greater than 100?
>100
<100
=100
<=100
Which object allows users to print invoices or summaries with formatting?
Macro
Table
Report
Query
To create a new database from scratch, which option is chosen?
Open Existing
New Blank Database
Import Data
Create Table
Which tool is used to establish links between two tables?
Relationship Tool
Query Wizard
Form Wizard
Report Wizard
Which of the following is a benefit of relational databases?
Slower data retrieval
More redundancy
Improved accuracy
Higher errors
What type of query updates data in a table?
Crosstab
Append
Update
Delete
Which Access feature prevents invalid data entry?
Caption
Input Mask
Report Wizard
Sorting
Which Access component allows users to view only selected fields?
Table
Query
Macro
Switchboard
Which command removes duplicate data in queries?
Group By
Filter
Sort
Distinct
In a form, which control is used for selecting from a predefined list?
Text Box
Combo Box
Label
Button
In Access, a collection of related fields is called a (a) .
A (a) is a graphical interface to enter and display data in Access.
The unique identifier for a record is known as the (a) .
The two main table views are _____ View and _____ View.
Datasheet
Design
To prevent blank entries, set the field property to (a) .
A query is a (a) you ask about data in a database.
The symbol used to enclose dates in query criteria is (a) .
The (a) operator requires both conditions to be true.
A calculated field uses (a) to generate new values.
The Access function similar to Excel’s IF function is (a) .
A query that prompts users for input each time it runs is a (a) .
A query that groups and summarizes data is called a (a) query.
A table relationship is created by dragging one field to a (a) field.
(a) Wizard helps in creating new forms quickly.
In a report, data can be displayed and printed with _____ and _____.
Formatting
Layout
The (a) property in a field specifies its maximum characters or digits.
To define formats like phone numbers or postal codes, we use (a) .
A set of records retrieved by a query is called a (a) .
The (a) tab is used to create a new database object.
Reports in Access are mainly used for (a) .
