Font size
WorksheetsH Admin Introduction to Databases
Total questions: 15
Worksheet time: 8mins
What is the primary purpose of Microsoft Access?
Word processing
Database management
Spreadsheet calculations
Presentation creation
In MS Access, what view allows you to modify the structure of a table?
Form View
Report View
Design View
Print View
Which object in MS Access is used to enter, edit, and display data from a table in a user-friendly format?
Reports
Forms
Queries
Modules
What symbol is used as a wildcard to represent any single character in MS Access?
%
*
?
#
In Query Design, which operator would you use to find records between two values?
LIKE
BETWEEN
AND
OR
What is the main purpose of the Primary Key in a table?
To sort data
To uniquely identify each record
To create relationships
To format data
Which view in MS Access displays data in a spreadsheet-like format?
Design View
Layout View
What type of query would you use to perform calculations on your data?
Select Query
Action Query
Parameter Query
Calculated Query
In MS Access, which object is best suited for printing data in an organized format?
Tables
Queries
Forms
Reports
What is the purpose of establishing relationships between tables?
To create calculations
To format data
To prevent data redundancy
To sort records
Which wildcard character matches zero or more characters in MS Access?
#
?
*
%
What field property would you set to prevent null values in a field?
Required
Indexed
Unique
Validated
In Query Design, which criteria would find all records that start with "S"?
S*
*S
Like "S*"
"S%"
What is the maximum number of tables you can include in a query?
(a)
Which feature allows you to automatically format the appearance of forms and reports?
Design View
Auto Format
Themes
Style Gallery
