NEW
Font size
WorksheetsS3 Microsoft Access Database Topic Exit
Total questions: 20
Worksheet time: 10mins
What is the primary purpose of a database table?
To create attractive reports
To store and organize related data in rows and columns
To print documents
To design forms
In Access, what is a field?
A complete row of information in a table
A report template
A column that stores a specific type of data
A blank space in a form
Which view allows you to enter and edit data directly in a table format?
Report View
Form View
Print View
Datasheet View
What is a record in a database?
A complete row of related information
A column header
A sorting method
A type of query
What tool would you use to find specific information in a database?
Forms
Reports
Queries
Tables
In Design View, what can you modify?
Only the data entry
The structure and properties of database objects
The printer settings
Only the field names
What is the purpose of a form in Access?
To analyze data
To store data
To enter and view data in a user-friendly layout
To delete records permanently
Which feature helps organize data in ascending or descending order?
Queries
Sorting
Forms
Reports
What is the purpose of criteria in a query?
To print all records
To specify conditions that data must meet
To change field names
To create new tables
How can you add images to a form?
Through Query Design
Using the Image control in Design View
Only in Datasheet View
Images cannot be added to forms
What is an advanced sort?
Sorting by multiple fields at once
Sorting only numbers
Sorting only text
Deleting duplicate records
Which view is used to create the structure of a new table?
Form View
Report View
Design View
Print View
What happens when you delete a record?
The entire table is deleted
Only that specific row of data is removed
The field names are deleted
Nothing happens
How can you print selected records from a form?
You must print all records
Use the Print Selected Records option
Delete unwanted records first
Through Query Design only
What is the main purpose of a report?
To enter new data
To present data in a formatted layout for printing
Which tool helps you find duplicate records?
Forms
Reports
Queries
Advanced sorting
In Design View of a form, what can you modify?
Only the background color
Only the text size
The layout and design elements
Only the field names
What is the difference between sorting and filtering?
They are exactly the same
Sorting arranges data while filtering shows only specific data
Filtering is not available in Access
Sorting can only be done on numbers
How are images stored in an Access database?
As actual images in the database
As links to external files
Images cannot be stored in Access
Only as temporary files
What is the maximum number of fields allowed in a table?
10 fields
255 fields
50 fields
Unlimited fields
