Microsoft Access Terms UPDATED Exam Questions and CORRECT Answers

Microsoft Access Terms UPDATED Exam
Questions and CORRECT Answers
Database - CORRECT ANSWER - A file that consists of one or more tables and the
supporting objects used to get data into and out of the fields


Flat or non-relational data - CORRECT ANSWER - data contained in a single page or
sheet


Relational database - CORRECT ANSWER - A database with more than one table or sheet
of data, which is linked together, e.g. sheet of personal data linked to sheet of exam results


Relational database software - CORRECT ANSWER - a computer application, such as
Microsoft Access, that is used to store data and convert it into information


Field - CORRECT ANSWER - a basic data element, or category, e.g. firstname or last
name or gender


Record - CORRECT ANSWER - a complete set of all of the data about one person, place,
event, or idea. Example: All the fields on my class roster about one student.


Table - CORRECT ANSWER - a collection of records



Primary key - CORRECT ANSWER - the field that makes each record in a table unique;
ex. Student ID number. Every table must have one primary key


Query - CORRECT ANSWER - Ask questions about the data in a database to return
answers, e.g search the database for all females in Lisburn


Form - CORRECT ANSWER - an interface that enables you to enter or modify record data