©SIRJOEL EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
Microsoft Access Study Guide.
Datatype - Answers✔The type of field values you can enter in that field of a table.
Database - Answers✔Collection and organization of information used to create lists.
DBMS - Answers✔Software designed to store, organize, and manage large amounts of data.
Datasheet - Answers✔Similar to an excel worksheet with columns and rows.
Field - Answers✔A single characteristic or piece of information stored in a table; name, grade level, etc.
Primary Key - Answers✔The field that uniquely identifies each record.
Record - Answers✔All the related information about a particular item on the table.
Form - Answers✔Object that you use to enter new records into the database or to edit data in existing
records.
Query - Answers✔Database object that is based upon a specific question you ask about the data in the
database.
Theme - Answers✔A set of predesigned formatting elements.
More common than spreadsheets - Answers✔Which of the following is not a typical benefit of relational
databases?
A) More accurate data
B) Faster information retrieval
C) More common than spreadsheets
D) Minimized duplicate data entry
Reduces duplicate data entry - Answers✔Which of the following is NOT an advantage of managing data
with relational database software such as Access versus spreadsheet software such as Excel?
A) Allows multiple users to enter data simultaneously
ALL RIGHTS RESERVED.
Microsoft Access Study Guide.
Datatype - Answers✔The type of field values you can enter in that field of a table.
Database - Answers✔Collection and organization of information used to create lists.
DBMS - Answers✔Software designed to store, organize, and manage large amounts of data.
Datasheet - Answers✔Similar to an excel worksheet with columns and rows.
Field - Answers✔A single characteristic or piece of information stored in a table; name, grade level, etc.
Primary Key - Answers✔The field that uniquely identifies each record.
Record - Answers✔All the related information about a particular item on the table.
Form - Answers✔Object that you use to enter new records into the database or to edit data in existing
records.
Query - Answers✔Database object that is based upon a specific question you ask about the data in the
database.
Theme - Answers✔A set of predesigned formatting elements.
More common than spreadsheets - Answers✔Which of the following is not a typical benefit of relational
databases?
A) More accurate data
B) Faster information retrieval
C) More common than spreadsheets
D) Minimized duplicate data entry
Reduces duplicate data entry - Answers✔Which of the following is NOT an advantage of managing data
with relational database software such as Access versus spreadsheet software such as Excel?
A) Allows multiple users to enter data simultaneously
