GMetrix Access: Database Fundamentals Flashcards
6 cards from real GMetrix Exam practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 GMetrix Access: Database Fundamentals flashcards as text
What is the primary purpose of Microsoft Access?
Answer: Building and managing relational databases
Microsoft Access is a relational database management system used to store, organize, query, and report on structured data.
What is a primary key in a Microsoft Access table?
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.
Which type of table relationship connects one record in a parent table to multiple records in a child table?
Answer: One-to-many
A one-to-many relationship is the most common relational database link, such as one customer having many orders.
What is the primary function of a query in Microsoft Access?
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.
Which Access view allows you to define field names, data types, and field properties for a table?
Answer: Design view
Design view is where you define the structure of a table by naming fields and assigning their data types and properties.
Which data type in Access should you use for a field that stores whole numbers used in calculations?
Answer: Number
The Number data type stores numeric values of various sizes and supports arithmetic operations.