GMetrix Exam GMetrix Access: Database Fundamentals 1 — Questions and Answers
Question 1: What is the primary purpose of Microsoft Access?
- Creating spreadsheets for calculations
- Building and managing relational databases (Correct answer)
- Designing slide presentations
- Drafting and formatting documents
Correct answer: Building and managing relational databases
Microsoft Access is a relational database management system used to store, organize, query, and report on structured data.
Question 2: What is a primary key in a Microsoft Access table?
- The first field listed in the table
- A field that uniquely identifies each record with no duplicates or nulls (Correct answer)
- A foreign key linking to another table
- The password protecting the table
Correct answer: A field that uniquely identifies each record with no duplicates or nulls
A primary key uniquely identifies every record in a table and enforces that no two rows share the same value.
Question 3: Which type of table relationship connects one record in a parent table to multiple records in a child table?
- One-to-one
- One-to-many (Correct answer)
- Many-to-many
- Self-referencing
Correct answer: One-to-many
A one-to-many relationship is the most common relational database link, such as one customer having many orders.
Question 4: What is the primary function of a query in Microsoft Access?
- To format printed reports
- To retrieve, filter, and summarize data from one or more tables (Correct answer)
- To create data-entry forms
- To add new fields to a table
Correct answer: To retrieve, filter, and summarize data from one or more tables
Queries allow you to ask questions of the database, returning only the records and fields that meet your specified criteria.
Question 5: Which Access view allows you to define field names, data types, and field properties for a table?
- Datasheet view
- Form view
- Design view (Correct answer)
- Layout view
Correct answer: Design view
Design view is where you define the structure of a table by naming fields and assigning their data types and properties.
Question 6: Which data type in Access should you use for a field that stores whole numbers used in calculations?
- Short Text
- Currency
- Number (Correct answer)
- AutoNumber
Correct answer: Number
The Number data type stores numeric values of various sizes and supports arithmetic operations.
GMetrix Exam GMetrix Access: Database Fundamentals 1
What is the primary purpose of Microsoft Access?