Programs: Microsoft Access: Multiple Choice


Access Multiple Choice


1.            Which sequence categorizes these terms from largest to smallest?

               a)            Table, database, record, field

               b)            Database, table, record, field

               c)            Database, table, field, record

d)                Field, record, table, database


2.            An Access database contains which of the following:

               a)            Queries and reports

               b)            Tables and forms

               c)            Macros and Modules

               d)            All of the above


3.            What does GIGO stand for?

               a)            Great I Got One

               b)            Good Input Goes Out

               c)            Garbage In, Garbage Out

d)                Global Indexing, Global Order


4.            In what view can you add, edit and delete records in a table?

               a)            The Datasheet view

               b)            The Design view

               c)            A and B

               d)            None of the above


5.            Which of these statements applying to the Open Database command is FALSE?

               a)            It opens the selected table from the Database window

               b)            It can be utilized from the File menu

               c)            It saves a database to memory

d)                It can be carried out by clicking the Open button on the Database toolbar


6.            A basic fact or data element such as the name of an employee is called a:

a)                table

b)                field

c)                database

d)                record


7.            A database consists of one or more:

a)                records

b)                fields

c)                tables

d)                windows


8.            A _______ provides a more efficient and attractive way to enter, display, and/or print

the data in a table.

a)                query

b)                report

c)                page

d)                form


9.            A table in access is displayed in which two (2) of the following views?

a)                plain view

b)                datasheet view

c)                design view

d)                rear view


10.          The current record is best described as the

a)                record you are working on

b)                record you already saved

c)                the pencil icon

d)                none of the above


11.          Which of the following is NOT a record selector symbol?

a)                triangle

b)                calculator

c)                pencil

d)                asterisk


12.          Which record selector symbol indicates that the record has been saved?

a)                triangle

b)                calculator

c)                pencil

d)                asterisk


13.          A flashing vertical bar that appears at the point where text is being entered is called the

a)                primary key

b)                current record

c)                module

d)                insertion point


14.          The command that enables you to locate a specific record by searching a table for a particular value is called the

a)                Replace command

b)                Search command

c)                Find command

d)                Match command


15.          Access is built to anticipate errors you might make and reject those errors before accepting the data.  This process is known as

a)                filtering

b)                sorting

c)                data validation

d)                reporting


16.          A________ displays a subset of records from a table according to specified criteria.

a)                filter

b)                sort

c)                form

d)                query


17.          A ________ lists a subset of records in a specific order such as alphabetically.

a)                filter

b)                sort

c)                form

d)                query


18.          The Remove Filter Button will

a)                let you choose multiple sets of criteria

b)                will sort fields in ascending order

c)                will sort fields in descending order

d)                will return you to the original complete table


19.          A _________ database creates one-to-many relationships between multiple tables.

a)                relational

b)                business

c)                personal

d)                multiple


20.          If you wanted to sort a field of last names from A-Z you would click the _________button.

a)                Filter by form

b)                Sort descending

c)                Sort ascending

d)                Filter by selection


21.          A(n) ________ appears next to the blank record at the end of every table.

a)                bullet

b)                asterisk

c)                arrow

d)                star


22.          A ________ presents the data in a table or query in attractive fashion on the printed page.

a)                table

b)                from

c)                report

d)                module


23.          What object is used to automate the performance of any repetitive task?

a)                page

b)                module

c)                form

d)                macro


24.          The database window is used to

a)                create tables

b)                edit tables

c)                view open tables

d)                display various objects in the database


25.          Which of the following is not displayed from the database window?

a)                record selector symbol

b)                form

c)                query

d)                report


Back to Main Page



Programs: Microsoft Access: Multiple Choice