Microsoft Access Test UPDATED Exam
Questions and CORRECT Answers
Relational databases - CORRECT ANSWER - A database in which data is divided into
tables, which are kind of like spreadsheets. Each table has just one subject, such as customers
(one table) or products (another table).
Records and fields - CORRECT ANSWER - Storage for the discrete data in a table. Rows
(or records) store each unique data point, such as the name of a customer. Columns (or fields)
isolate the information being captured about each data point into the smallest possible unit—first
name might be one column and last name might be another.
Primary key - CORRECT ANSWER - A value that ensures each record is unique. For
example, there might be two customers with the same name, Elizabeth Andersen. But one of the
Elizabeth Andersen records has the number 12 as its primary key and the other has a primary key
of 58.
Parent-child relationships - CORRECT ANSWER - Common relationships between tables.
For example, a single customer may have multiple orders. Parent tables have primary keys. Child
tables have foreign keys, which are values from the primary key that show how the child table
records are linked to the parent table. These keys are linked by a relationship.
What is good database design? - CORRECT ANSWER - Avoid duplicate information (also
called redundant data).
Ensure that data is correct and complete.
Steps of Database Design? - CORRECT ANSWER - Step 1: Determine the purpose of
your database
Step 2: Find and organize required information
Step 3: Divide information into tables
Step 4: Turn information items into columns
Step 5: Specify primary keys
Questions and CORRECT Answers
Relational databases - CORRECT ANSWER - A database in which data is divided into
tables, which are kind of like spreadsheets. Each table has just one subject, such as customers
(one table) or products (another table).
Records and fields - CORRECT ANSWER - Storage for the discrete data in a table. Rows
(or records) store each unique data point, such as the name of a customer. Columns (or fields)
isolate the information being captured about each data point into the smallest possible unit—first
name might be one column and last name might be another.
Primary key - CORRECT ANSWER - A value that ensures each record is unique. For
example, there might be two customers with the same name, Elizabeth Andersen. But one of the
Elizabeth Andersen records has the number 12 as its primary key and the other has a primary key
of 58.
Parent-child relationships - CORRECT ANSWER - Common relationships between tables.
For example, a single customer may have multiple orders. Parent tables have primary keys. Child
tables have foreign keys, which are values from the primary key that show how the child table
records are linked to the parent table. These keys are linked by a relationship.
What is good database design? - CORRECT ANSWER - Avoid duplicate information (also
called redundant data).
Ensure that data is correct and complete.
Steps of Database Design? - CORRECT ANSWER - Step 1: Determine the purpose of
your database
Step 2: Find and organize required information
Step 3: Divide information into tables
Step 4: Turn information items into columns
Step 5: Specify primary keys
