NEW
Font size
WorksheetsMS Access Quiz
Total questions: 15
Worksheet time: 15mins
What are the four objects in Access?
Tables, queries, forms, and reports
Tables, queries, forms, and macros
Tables, queries, forms, and modules
Tables, queries, forms, and relationships
What is the purpose of tables in Access?
To store and organize data
To create forms and reports
To run queries and macros
To establish relationships between objects
What are rows and columns referred to as in Access?
Records and fields
Tables and queries
Forms and reports
Modules and macros
What is a field in Access?
A way of organizing information by data type
A way of organizing information by category
A way of organizing information by importance
A way of organizing information by location
What is a record in Access?
A unit of information
A unit of measurement
A unit of time
A unit of currency
What is the purpose of forms in Access?
To enter, modify, and view records
To search and compile data
To present data in print
To store and analyze data
What is the purpose of queries in Access?
To search for and compile data
To enter, modify, and view records
To present data in print
To store and analyze data
What is the purpose of reports in Access?
To present data in print
To search and compile data
To enter, modify, and view records
To store and analyze data
What do forms help with in Access?
Making data entry easier
Running complex queries
Creating visually appealing reports
Establishing relationships between tables
What makes queries more powerful than simple searches in Access?
They can search for and compile data from multiple tables
They can create visually appealing reports
They can enter, modify, and view records
They can establish relationships between tables
What is the purpose of reports in Access?
To present data in print
To search and compile data
To enter, modify, and view records
To store and analyze data
How do forms, queries, and reports interact with the data in Access?
They all work with the same data
They each have their own separate data
They can only work with tables, not queries
They can only work with forms, not reports
What is the benefit of using connected database objects in Access?
They make complex tasks more manageable
They make simple tasks more complicated
They allow for faster data entry
They eliminate the need for tables
What is a relational database in Access?
A database that understands how different sets of data relate to each other
A database that only stores tables
A database that doesn't use forms or reports
A database that doesn't allow for data entry
Why are relational databases useful in Access?
They make complex tasks more manageable
They make simple tasks more complicated
They allow for faster data entry
They eliminate the need for tables
