NEW
Font size
WorksheetsN5 Admin Database Terminology
Total questions: 15
Worksheet time: 8mins
What is a database table?
A report that summarizes data
A collection of related records organized in rows and columns
A form used to input data
A query that filters information
Which view allows you to see the data in a spreadsheet-like format?
Report View
Form View
Query View
Datasheet View
In database terminology, what is a query used for?
To print information in a professional format
To enter new data into a table
To retrieve specific data based on criteria
To change the appearance of data
What is the primary purpose of a database form?
To extract specific information from tables
To present data in a visually appealing way for printing
To provide a user-friendly interface for viewing and entering data
To define the structure of tables
Which datatype would be most appropriate for storing a person's date of birth?
Text
Number
Currency
Date/Time
What is the main purpose of Design View in a database?
To create and modify the structure of database objects
To enter data into tables
To print reports
To run queries
Which of the following is a common sorting option in databases?
Colorful
Alphabetical
Random
Circular
What are criteria in database queries?
The fields selected for the query results
The conditions that data must meet to be included in results
The order in which results are displayed
The format of the query output
Which view would you use to preview how a report will look when printed?
Design View
Report View
Datasheet View
Query View
What is the purpose of formatting in a database?
To organize data into tables
To improve the visual appearance and readability of data
To create relationships between tables
To filter out unwanted information
Which datatype would be most appropriate for storing a product price?
Text
Currency
Yes/No
Memo
What is the main difference between a table and a report?
Tables store data while reports present data in a formatted way
Tables can only contain numbers while reports can contain text
Tables are temporary while reports are permanent
Tables are for administrators while reports are for users
When would you use the "Ascending" sort option in a database?
To sort text from Z to A
To sort numbers from largest to smallest
To sort dates from oldest to newest
To hide certain records from view
What is a primary key in a database table?
The password used to access the database
The first field in any table
A field or combination of fields that uniquely identifies each record
The most important information in the table
Which of the following is NOT a common datatype in databases?
Number
Text
Drawing
Date/Time
