Database Management Programs Quiz

34 Questions | By Bmorris_sayre | Updated: Mar 21, 2022 | Attempts: 433

Questions

Settings

What do you know about database management programs? A database is an organized collection of data, usually stored and retrieved electronically from a computer system. Database systems are more involved; they are often established using formal design and modeling techniques. The database management system interacts with end-users, applications, and the database to capture and analyze the data. This technological quiz is ideal for anyone who is learning about computers.

Questions and Answers

1.

Access is a database program.
- A.
  
  True
- B.
  
  False
2.

The Access screen is similar to other Office 2007 applications.
- A.
  
  True
- B.
  
  False
3.

You can open multiple databases at a time in an Access window.
- A.
  
  True
- B.
  
  False
4.

Objects are organized into categories in the Navigation Pane.
- A.
  
  True
- B.
  
  False
5.

When you create a new database, the first step is to name the database file.
- A.
  
  True
- B.
  
  False
6.

You cannot use the Save As command to name and save objects in the database.
- A.
  
  True
- B.
  
  False
7.

You can create as many tables as you need to store the information for a database.
- A.
  
  True
- B.
  
  False
8.

You can only add fields in Design view.
- A.
  
  True
- B.
  
  False
9.

Unlike Word and Excel, Access does not have a standard document view.
- A.
  
  True
- B.
  
  False
10.

Once you have deleted a record, you can use the Undo command to restore it.
- A.
  
  True
- B.
  
  False
11.

A ____ is an object that stores data in columns and rows.
- A.
  
  Table
- B.
  
  Form
- C.
  
  Report
- D.
  
  Query
12.

A ____ makes it easy for you to view, enter, and edit data in a table.
- A.
  
  Table
- B.
  
  Form
- C.
  
  Report
- D.
  
  Query
13.

In ____ view, the table looks much like a spreadsheet.
- A.
  
  Design
- B.
  
  Datasheet
- C.
  
  Field
- D.
  
  Print
14.

____ is the shortcut for creating a new blank database.
- A.
  
  CTRL+D
- B.
  
  CTRL+N
- C.
  
  CTRL+B
- D.
  
  CTRL+A
15.

The ____ determines what type of data the field can store, such as text or numbers.
- A.
  
  Record
- B.
  
  Field name
- C.
  
  Data type
- D.
  
  Field properties
16.

____ define the characteristics and behavior of a field, such as the number of characters allowed.
- A.
  
  Data types
- B.
  
  Primary keys
- C.
  
  Entries
- D.
  
  Field Properties
17.

When you work in ____ view, the changes are saved as they are made.
- A.
  
  Design
- B.
  
  Form
- C.
  
  Datasheet
- D.
  
  Report
18.

Access stores cut or copied text in the ____.
- A.
  
  Navigation Pane
- B.
  
  Clipboard
- C.
  
  Field
- D.
  
  Entry
19.

____ is the illegal copying or use of programs.
- A.
  
  Intellectual Property
- B.
  
  The Copyright Act
- C.
  
  Shareware
- D.
  
  Software Piracy
20.

____ is software that can be accessed for free.
- A.
  
  Software piracy
- B.
  
  Shareware
- C.
  
  The honor system
- D.
  
  Intellectual Property
21.

The Next record button is located in the ____.
- A.
  
  Navigation Pane
- B.
  
  Navigation Bar
- C.
  
  Ribbon
- D.
  
  Status Bar
22.

The default data type for a field is ____.
- A.
  
  Number
- B.
  
  Text
- C.
  
  Currency
- D.
  
  Yes/No
23.

The Blank Database button is located in the ____.
- A.
  
  Home Tab
- B.
  
  Create Tab
- C.
  
  Navigation Pane
- D.
  
  Getting Stated With Microsoft Access Window
24.

Fields appear as columns, and each column has a ____.
- A.
  
  Datasheet
- B.
  
  Record
- C.
  
  Field name
- D.
  
  Primary key
25.

The ____ key moves the insertion point to the first field in the current record.
- A.
  
  Home
- B.
  
  End
- C.
  
  Up Arrow
- D.
  
  Down Arrow