WorksheetsQuiz on MS Access Objects
Total questions: 15
Worksheet time: 8mins
What is the primary purpose of tables in MS Access?
To generate reports
To hold raw data
To filter data
To create user-friendly forms
Which of the following is an example of a table in MS Access?
Students table
Report card
Query for grades
Student registration form
What is the main function of forms in MS Access?
To store data
To present data professionally
To make data entry easier
To filter and search data
How do queries help users in MS Access?
By storing data
By providing a user interface
By searching and filtering data
By generating reports
What type of information can you retrieve using queries?
Only raw data
Specific data based on conditions
All data in the database
Only summary data
What is the purpose of reports in MS Access?
To store raw data
To present and print data
To analyze data
To input data
Which of the following best describes how tables, queries, forms, and reports work together?
Reports store data, forms extract data, queries present data, tables input data
Forms store data, queries present data, tables analyze data, reports input data
Tables store data, queries extract data, forms input data, reports present data
Tables store data, forms present data, queries analyze data, reports input data
If you want to find all students with grades above 90, which MS Access object would you use?
Table
Form
Query
Report
What is a key feature of forms in MS Access?
They generate reports automatically
They filter data from multiple tables
They allow users to enter and edit data easily
They store data in rows and columns
Which object would you use to summarize student details and marks?
Query
Form
Report
Table
What is the main advantage of using forms for data entry?
They make data entry easier and reduce errors
They present data in a professional format
They reduce the need for queries
They store data more efficiently
Which of the following statements is true about queries?
They are primarily used for printing data
They can filter and retrieve specific data from multiple tables
They are used to input data into the database
They can only retrieve data from one table
What type of layout do reports provide in MS Access?
User-friendly interface
Structured layouts for presenting data
Raw data storage
Data filtering options
In MS Access, which object is primarily used for data storage?
Reports
Tables
Queries
Forms
How do reports differ from forms in MS Access?
Reports summarize data, while forms allow data input
Reports are interactive, while forms are static
Reports are used for data entry, while forms are for data presentation
Reports store data, while forms filter data
