Access Database Test UPDATED ACTUAL Exam Questions and CORRECT Answers

Access Database Test UPDATED ACTUAL
Exam Questions and CORRECT Answers
Table - CORRECT ANSWER - An Access table contains all the data in a database.
Hint:(What is the first thing you had to create when you began both Access Database projects?)


Query - CORRECT ANSWER - An object that performs create, read, update, and delete
operations on the database. Hint:(You have to Run this.)


Form - CORRECT ANSWER - Records filled with data. Hint:(You had to create your
records in this.)


Report - CORRECT ANSWER - an object in a database designed for formatting,
calculating, printing, and summarizing data. Hint(You had to print one.)


Short Text - CORRECT ANSWER - Text or combinations of text and numbers that have a
max size of 255 characters


Long Text - CORRECT ANSWER - Lengthy text or combinations of text and numbers
that have a max size of 63,999 characters


Number - CORRECT ANSWER - Numeric data used in mathematical calculations.
Hint:(The answer is in this definition.)


AutoNumber (ID Number) - CORRECT ANSWER - A unique sequential number
(incremented by 1) or a random number assigned to a new record in a table. Hint: (Each record
has one of this automatically generated.)


Yes/No - CORRECT ANSWER - Yes and No values and fields that contain only one of
two values (Yes/No, True/False, On/Off, 0/1, etc.)