GCFLearnFree.org

I wish I would have found you ages ago.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2003
  • Quiz

Access 2003

Quiz

Question 1
True or False: A table is made up of several records.
A. True
B. False
Question 2
Microsoft Access is what type of program?
A. Spreadsheet
B. Word processor
C. Database
D. Internet browser
Question 3
True or False: A query lets you find and retrieve information from only one table.
A. True
B. False
Question 4
True or False: Columns or fields in a table cannot be moved.
A. True
B. False
Question 5
True or False: A table in a database cannot be related to another table in the same database.
A. True
B. False
Question 6
A primary key is:
A. a field that uniquely identifies a particular record in a table
B. the mechanism by which you relate different tables and combine information for viewing or printing
C. both A and B
D. neither A nor B
Question 7
A database is __________
A. a collection of information that can be managed and shared with other tables and databases
B. the same thing as a file
C. the same thing as the hard drive on your computer
D. the same thing as a primary key
Question 8
A record in Access is composed of ________.
A. a series of databases
B. a series of fields
C. a series of keys
D. several Word files
Question 9
A database wizard is used to ______.
A. create a new database
B. add records to an existing database
C. create a new record in an existing database
D. assist the primary key in opening the needed files
Question 10
Which of the following is not a database object?
A. Tables
B. Queries
C. Reports
D. Records
Question 11
True or False: A record cannot be changed after it has been added to a table.
A. True
B. False
Question 12
True or False: A table record cannot be edited in Datasheet view.
A. True
B. False
Question 13
A table record can be displayed ______.
A. by selecting a record from the Edit menu
B. by selecting a record from the File menu
C. by selecting a record from the View menu
D. by selecting a table in Datasheet view
Question 14
Records can be added to a table using ______________.
A. only the Datasheet view
B. only the Form view
C. neither A nor B
D. both A and B
Question 15
The status area has all of the following buttons EXCEPT:
A. First record
B. Next record
C. All records
D. New record
Question 16
Sorting is ________________.
A. a method that helps you locate information quickly in a database
B. the same thing as performing a query
C. neither A nor B
D. both A and B
Question 17
A report is run instead of a query when ______.
A. a query has not been created
B. the table contains more than 10 records
C. you want a formatted and visually appealing printout
D. you want to delete records from a table
Question 18
True or False: A Filter by Selection is used when you do not want to use a specific criterion in a filter.
A. True
B. False
Question 19
To search for a specific record in a table, select the field to search and then click the ______ button on the toolbar.
A. Find
B. Search
C. Locate
D. Query

Answers:

  • 1) A. True
  • 2) C. Database
  • 3) B. False
  • 4) B. False
  • 5) B. False
  • 6) C. both A and B
  • 7) A. a collection of information that can be managed and shared with other tables and databases
  • 8) B. a series of fields
  • 9) A. create a new database
  • 10) D. Records
  • 11) B. False
  • 12) B. False
  • 13) D. by selecting a table in Datasheet view
  • 14) D. both A and B
  • 15) C. All records
  • 16) A. a method that helps you locate information quickly in a database
  • 17) C. you want a formatted and visually appealing printout
  • 18) B. False
  • 19) A. Find
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.