MICROSOFT ACCESS BUNDLED
EXAM SCRIPT 2026 TEST PAPER
QUESTIONS AND SOLUTIONS
GRADED A+
◉ Database Management System.
Answer: is software system that provides the tools needed to create,
maintain, and use a database.
◉ Microsoft Access.
Answer: is the database management system included in professional
editions of the office 2016 suite.
◉ Object.
Answer: objects include tables, queries, forms, and reports, and can be
found in the navigation pane.
◉ Navigation pane.
Answer: the navigation pane is an access interface element that
organizes and list the objects in an access database. The navigation pane
appears on the left side of the screen, and displays all objects.
◉ Table.
, Answer: A table is where all data is stored in your database, and thus can
be said to be the foundation of each database. Tables organize data into
columns and rows.
◉ Field.
Answer: Each column represents a field, a category of information we
store in a table. For example, in Northwind database, a table containing
customers information would include fields such as Customer ID,
Company name, and City.
◉ Record.
Answer: Each row in a table contains a record, a complete set of all the
fields about one person, place, event, or concept. A customer record, for
example, would contain all of the fields about a single customer,
including the customer ID, Company Name, Contact Name, Contact
Title, Address, City, ect.
◉ Primary Key.
Answer: is a field (combination of fields) that uniquely identifies each
record in a table. Common primary keys are driver's license number,
government ID number (such as a social security number), passport
number, and student ID.
◉ Query.
Answer: A query (or queries, plural) is a question you ask about the data
in your database. Notice the word query is similar to the word inquiry,
which means question.
EXAM SCRIPT 2026 TEST PAPER
QUESTIONS AND SOLUTIONS
GRADED A+
◉ Database Management System.
Answer: is software system that provides the tools needed to create,
maintain, and use a database.
◉ Microsoft Access.
Answer: is the database management system included in professional
editions of the office 2016 suite.
◉ Object.
Answer: objects include tables, queries, forms, and reports, and can be
found in the navigation pane.
◉ Navigation pane.
Answer: the navigation pane is an access interface element that
organizes and list the objects in an access database. The navigation pane
appears on the left side of the screen, and displays all objects.
◉ Table.
, Answer: A table is where all data is stored in your database, and thus can
be said to be the foundation of each database. Tables organize data into
columns and rows.
◉ Field.
Answer: Each column represents a field, a category of information we
store in a table. For example, in Northwind database, a table containing
customers information would include fields such as Customer ID,
Company name, and City.
◉ Record.
Answer: Each row in a table contains a record, a complete set of all the
fields about one person, place, event, or concept. A customer record, for
example, would contain all of the fields about a single customer,
including the customer ID, Company Name, Contact Name, Contact
Title, Address, City, ect.
◉ Primary Key.
Answer: is a field (combination of fields) that uniquely identifies each
record in a table. Common primary keys are driver's license number,
government ID number (such as a social security number), passport
number, and student ID.
◉ Query.
Answer: A query (or queries, plural) is a question you ask about the data
in your database. Notice the word query is similar to the word inquiry,
which means question.
