Microsoft Access Exam
Questions & Answers
database management system (DBMS) - ANSWERSa software program used to create a
database and its structures, process the database, and assist in the administration of the
database
relational database - ANSWERSstructures data in the form of tables
byte - ANSWERSsingle character of data
fields - ANSWERSbytes are grouped into columns
records - ANSWERSfields are grouped into rows, collection of information about a certain thing
table (a table is a relation in relational database) - ANSWERSa group of similar rows or records
primary key - ANSWERSa field or group of fields that uniquely identifies a record
foreign key - ANSWERSa field in one table that is also stored in different table as a primary key
primary key value - ANSWERSmakes each record in the table unique-no other record can have a
duplicate primary key
navigation pane - ANSWERSare of the database window which lists all the tables, on the left side
of the screen
, tables - ANSWERSgroup of records, contains the information in the database
datasheet view - ANSWERSshows the content of your table, it's a grid-like view in which you can
add, enter, edit, and delete records in a table
design view - ANSWERSshows only the structure to the table, it provides a grid that can be used
to add, rearrange, or remove fields, but it cannot be used to add or edit records
short text - ANSWERSthe most common, all-purpose data type, accepts numbers, letters, and
symbols (names, addresses, zip codes, phone numbers)
long text - ANSWERSlarge amounts of text, (memos, notes, articles)
number - ANSWERSa wide variety of numbers, including those with decimal points, negatives,
and percent's (any number except currency)
date/time - ANSWERSa calendar date, time of day, or both (birthdates, due dates, flight dates
and times)
currency - ANSWERSsimilar to the number type but specially designed to represent money
values (prices, payments)
autonumber - ANSWERSautomatically installed by Access to ensure every number is
unique(provide unique ID number, most often used in a primary key field)
yes/no - ANSWERScan be either yes/no (useful for fields with two options)
Questions & Answers
database management system (DBMS) - ANSWERSa software program used to create a
database and its structures, process the database, and assist in the administration of the
database
relational database - ANSWERSstructures data in the form of tables
byte - ANSWERSsingle character of data
fields - ANSWERSbytes are grouped into columns
records - ANSWERSfields are grouped into rows, collection of information about a certain thing
table (a table is a relation in relational database) - ANSWERSa group of similar rows or records
primary key - ANSWERSa field or group of fields that uniquely identifies a record
foreign key - ANSWERSa field in one table that is also stored in different table as a primary key
primary key value - ANSWERSmakes each record in the table unique-no other record can have a
duplicate primary key
navigation pane - ANSWERSare of the database window which lists all the tables, on the left side
of the screen
, tables - ANSWERSgroup of records, contains the information in the database
datasheet view - ANSWERSshows the content of your table, it's a grid-like view in which you can
add, enter, edit, and delete records in a table
design view - ANSWERSshows only the structure to the table, it provides a grid that can be used
to add, rearrange, or remove fields, but it cannot be used to add or edit records
short text - ANSWERSthe most common, all-purpose data type, accepts numbers, letters, and
symbols (names, addresses, zip codes, phone numbers)
long text - ANSWERSlarge amounts of text, (memos, notes, articles)
number - ANSWERSa wide variety of numbers, including those with decimal points, negatives,
and percent's (any number except currency)
date/time - ANSWERSa calendar date, time of day, or both (birthdates, due dates, flight dates
and times)
currency - ANSWERSsimilar to the number type but specially designed to represent money
values (prices, payments)
autonumber - ANSWERSautomatically installed by Access to ensure every number is
unique(provide unique ID number, most often used in a primary key field)
yes/no - ANSWERScan be either yes/no (useful for fields with two options)
