Access Chapter 2: The Database Table

Multiple Choice:

1.Opening a table in Datasheet View enables:

  1. adding and editing fields.
  2. choosing the data type of each field.
  3. entering data into a field.
  4. entering a description of a field.

Answer: CDifficulty: DifficultObjective:Creating a New Table

Reference: Creating a New Table

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

2.In order to open a blank table in Design View:

  1. click on File, and then click on New.
  2. click the Table Design Icon.
  3. click on the Table Icon.
  4. press Ctrl-N on the Keyboard.

Answer: BDifficulty:ModerateObjective:Creating a New Table

Reference: Creating a New table

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

3.The first row of each column has the name of the:

  1. Database.
  2. Table.
  3. Data type.
  4. Field.

Answer: DDifficulty:EasyObjective:Creating a New Table

Reference: Creating a New Table

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

4.Each ______should have a unique ______.

  1. ID, Record
  2. Record, ID
  3. ID, Field
  4. Field, ID

Answer: BDifficulty:DifficultObjective:Creating a New Table

Reference: Creating a New Table

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

5.All of the following are examples of data types EXCEPT:

  1. Number.
  2. Currency.
  3. Date/Time.
  4. Noun.

Answer: DDifficulty: EasyObjective:Field Names, Data Types, and Field Properties

Reference: Field Names, Data Types, and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

6.All of the following are examples of field sizes for Number data types EXCEPT:

  1. Short.
  2. Long.
  3. Double.
  4. Single.

Answer: ADifficulty: ModerateObjective:Field Names, Data Types, and Field Properties

Reference: Field Names, Data Types, and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

7.After defining the ______, you will need to define the ______.

  1. Data types, field names
  2. Field names, index
  3. Records, descriptions
  4. Page size, fields

Answer: BDifficulty: ModerateObjective:Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

8.In order to define the number of decimal places, the field size option can be located in the ______.

  1. field properties box
  2. datasheet view
  3. descriptions
  4. customer data field

Answer: ADifficulty: ModerateObjective: Field Names, Data Types, and Field Properties

Reference: Field Names, Data Types, and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

9.A ______can be set on the fields that make each record ______.

  1. Primary Key, the same
  2. Tertiary Key, the same
  3. Primary Key, unique
  4. Tertiary Key, unique

Answer: CDifficulty: ModerateObjective: Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

10.The purpose of a primary key is to ensure:

  1. Organization Management.
  2. Entity Integrity.
  3. Field Designation.
  4. Record Repetition.

Answer: BDifficulty: ModerateObjective:Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

11.After data is entered into a cell, you can press all of the following to advance to another cell, EXCEPT:

  1. Ctrl.
  2. Enter.
  3. Tab.
  4. Arrow key.

Answer: ADifficulty: EasyObjective:Entering and Formatting Data

Reference: Entering and Formatting Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

12.If a cell is activated and then the bold button on the formatting toolbar is pressed, which of the following results will happen?

  1. Only the data in the cell will be bolded.
  2. Only the data in the row will be bolded.
  3. Only the data in the column will be bolded.
  4. All data in the table will be bolded.

Answer: DDifficulty: ModerateObjective:Entering and Formatting Data

Reference: Entering and Formatting Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

13.To hide a column:

  1. adjust the size of the column to less than .08.
  2. activate a cell and press delete.
  3. change the background and text to white.
  4. use the More icon in the Home tab.

Answer: DDifficulty: ModerateObjective:Adjusting and Hiding Columns and Rows

Reference: Adjusting and Hiding Columns and Rows

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

14.Of sorting and filtering, which provides more analytical power and why?

  1. Sorting, because it allows seeing things in alphabetical or numerical order
  2. Filtering, because it allows for calculations to be taken
  3. Filtering, because it only displays data that meets conditions set by the user
  4. Sorting, because more than one column can be sorted

Answer: CDifficulty: DifficultObjective:Sorting and Filtering

Reference: Sorting and Filtering

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

15.In order to find the highest value of one field, the ______technique is the easiest; in order to see multiple records with a field above a certain level, the ______technique is best.

  1. Sorting, Sorting
  2. Filtering, Filtering
  3. Filtering, Sorting
  4. Sorting, Filtering

Answer: DDifficulty: DifficultObjective:Sorting and Filtering

Reference: Sorting and Filtering

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

16.It is most common to change the ______data type to ______.

  1. Double, Integer
  2. Date, Double
  3. Text, Memo
  4. Memo, Long Text

Answer: CDifficulty: ModerateObjective: Changing Data Types and Field Properties

Reference: Changing Data Types and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

17.Changing the sequence of fields may be done by:

  1. clicking in the box next to the field name in the datasheet view and dragging.
  2. clicking the field name in the Design View and dragging.
  3. sorting the field names.
  4. clicking in the box next to the field name in the Design View and dragging.

Answer: DDifficulty: ModerateObjective: Changing the Sequence of Field

Reference: Changing the Sequence of Field

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

18.If you want to separate the field “Beginning to Ending Inventory,” which is currently a range of two numbers, to two different fields, your first step should be to:

  1. change the primary key.
  2. insert a field.
  3. delete the field.
  4. click the “Separate field” button.

Answer: BDifficulty: DifficultObjective:Changing the Sequence of Field

Reference: Changing the Sequence of Field

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

19.Deleted records or fields:

  1. can be undone by the “undo” box.
  2. can be undone by the “re-add” box
  3. can be undone by the “reverse warning” box
  4. cannot be undone.

Answer: DDifficulty: ModerateObjective:Deleting Fields and Records

Reference: Deleting Fields and Records

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

20.A table can be created from all of the following EXCEPT:

  1. Text files.
  2. Other Access databases.
  3. Excel spreadsheets.
  4. PowerPoint Files.

Answer: DDifficulty: EasyObjective: Importing Data

Reference: Importing Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

21.If the first row contains column headings, then:

  1. data will only be taken from the second row onward.
  2. data will only be taken from the third row onward.
  3. all data will be taken and the first row will be converted to field names.
  4. access column headings will be directly linked to the imported data.

Answer: CDifficulty: ModerateObjective: Importing Data

Reference: Importing Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

22.Using the import spreadsheet wizard enables you to define:

  1. no primary keys.
  2. one primary key.
  3. two primary keys.
  4. as many primary keys as desired.

Answer: BDifficulty: ModerateObjective: Importing Data

Reference: Importing Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

23.All of the following are caveats of linking tables EXCEPT:

  1. the linked table will overwrite the database.
  2. transfer of data is only one way.
  3. it is impossible to change the imported file.
  4. linking tables only update once every five minutes.

Answer: DDifficulty: DifficultObjective: Linking Data

Reference: Linking Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

24.The symbol that precedes the table name in the Navigation Pane indicates:

  1. the type of file that the database is linked to.
  2. the type of file that the database is imported from.
  3. the valid files that can be exported.
  4. the valid types of files that the database can be saved as.

Answer: ADifficulty: ModerateObjective: Linking Data

Reference: Linking Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

25.A useful way for separate divisions of a company to communicate quickly and automatically is through:

  1. shared databases.
  2. linking tables.
  3. emailing updates of access files.
  4. attaching videos into the access file.

Answer: BDifficulty: DifficultObjective: Linking Data

Reference: Linking Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

26.The Navigation Pane will show all of the following EXCEPT:

  1. the symbol of a linked table.
  2. table names.
  3. the term “All Access Objects.”
  4. the formatting toolbar.

Answer: DDifficulty: DifficultObjective: Creating Tables

Reference: Creating Tables

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

27.When importing data, it is easier to define fields and make adjustments to the data by using:

  1. Datasheet View.
  2. Design View.
  3. Import Spreadsheet Wizard.
  4. Navigation Pane.

Answer: BDifficulty: ModerateObjective: Importing and Linking Data

Reference: Importing and Linking Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

28.You cut a dictionary in half. In Access terms, you are ______the data.

  1. Sorting
  2. Filtering
  3. Cutting and Pasting
  4. Organizing

Answer: BDifficulty: DifficultObjective: Sorting and Filtering

Reference: Sorting and Filtering

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/DesignViewAB.gif"<br<br>

29.In the above image, A is ______and B is ______.

  1. Description, Field Properties
  2. Field Name, Field Properties
  3. Field Name, Description
  4. Description, Field Name

Answer: CDifficulty: ModerateObjective: Creating a Table

Reference: Creating a Table

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Number.gif"<br<br>

30.The above image demonstrates Field Sizes for which type of Data Type?

  1. Date/Time
  2. Number
  3. Currency
  4. Text

Answer: BDifficulty: EasyObjective: Creating a Table

Reference: Creating a Table

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Index.gif"<br<br>

31.The above image matches with which of the following terms?

  1. Indexes
  2. Property Sheet
  3. Builder
  4. Copy and Paste

Answer: ADifficulty: EasyObjective: Indexing and Primary Keys

Reference: Indexingand Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Primary Key.gif"<br<br>

32.Which of the following fields follows the rules of being a primary key in the image?

  1. Sales Date
  2. Category Number
  3. Category Description
  4. Daily Sales Dollars

Answer: DDifficulty: DifficultObjective: Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Primary Key.gif"<br<br>

33.Which of the following fields would be the most feasible as a primary key in the image?

  1. Sales Date
  2. Category Number
  3. Daily Unit Sales
  4. Daily Sales Dollars

Answer: ADifficulty: EasyObjective: Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

34.The number of records in the table is listed:

  1. in “All Access Objects.”
  2. in the “Records Number” dialog box.
  3. in the status bar of the access file.
  4. in the bar at the bottom of the table in datasheet view.

Answer: DDifficulty: ModerateObjective: Creating Tables

Reference: Creating Tables

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Home.gif"<br<br>

35.These icons (above) can be found in:

  1. the Home tab.
  2. the Create tab.
  3. the External Data tab.
  4. the Database Tools tab.

Answer: ADifficulty: EasyObjective: Creating Tables

Reference: Creating Tables

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Activation.gif"<br<br>

36.By observing the above image, it is possible to deduce that:

  1. one record is activated.
  2. no records are activated.
  3. the entire table is activated.
  4. one field is activated.

Answer: DDifficulty: DifficultObjective: Creating Tables

Reference: Creating Tables

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

37.Where is NOT the place to observe if a filter has been placed on the datasheet?

  1. In Design View
  2. In the Filter area on the Home tab
  3. On the right side of the filtered field in the Datasheet View
  4. At the bottom of the table in Datasheet View

Answer: ADifficulty: DifficultObjective: Sorting and Filtering

Reference: Sorting and Filtering

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/MoveField.gif"<br<br>

38.By observing the above image, it is possible to deduce that:

  1. the user is trying to add a field.
  2. the user is trying to move a field.
  3. the user is trying to change a field.
  4. the user is trying to delete a field.

Answer: BDifficulty: ModerateObjective: Changing the Sequence of Field

Reference: Changing the Sequence of Field

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/ExternalData.gif"<br<br>

39.These icons (above) can be found in:

  1. the Home tab.
  2. the Create tab.
  3. the External Data tab.
  4. the Database Tools tab.

Answer: CDifficulty: EasyObjective: Importing Data

Reference: Importing Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Text.gif"<br<br>

40.It is evident from the above image that data is being imported from a(n):

  1. Access file.
  2. Text file.
  3. Excel file.
  4. Macro.

Answer: BDifficulty: DifficultObjective: Importing Data

Reference: Importing Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

<img src="images/Text.gif"<br<br>

41.It is evident from the above image that imported data will have:

  1. four fields.
  2. five fields.
  3. four records.
  4. five records.

Answer: BDifficulty: DifficultObjective: Importing Data

Reference: Importing Data

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

True/False:

42.When a new table is opened using the table icon, automatically a blank Access table in Design View appears. T F

Answer:FDifficulty:EasyObjective:Creating a New Table

Reference: Creating a New Table

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

43.In order to change the field names, data types, and to type descriptions of fields, you must be in Design View. T F

Answer:TDifficulty:EasyObjective: Field Names, Data Types, and Field Properties

Reference: Field Names, Data Types, and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

44.Text data types may contain a decimal number. T F

Answer:TDifficulty: ModerateObjective: Field Names, Data Types, and Field Properties

Reference: Field Names, Data Types, and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

45.Text data types may contain a decimal number that can be used in calculations. T F

Answer:FDifficulty: DifficultObjective: Field Names, Data Types, and Field Properties

Reference: Field Names, Data Types and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

46.For all data types, the field size property is listed in the first row of the field properties box. T F

Answer:FDifficulty: ModerateObjective: Field Names, Data Types, and Field Properties

Reference: Field Names, Data Types, and Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

47.Indexing a table should only be used for very small databases. T F

Answer:FDifficulty: EasyObjective: Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

48.The index is used to determine how data is organized or sequenced in a table. T F

Answer:TDifficulty: EasyObjective: Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

49.The storage capacity and format for each data type can be adjusted in the Field Property box. T F

Answer:TDifficulty: EasyObjective: Field Names, Data Type, Field Properties

Reference: Field Names, Data Type, Field Properties

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

50.The best field to be used as an index is the first field. T F

Answer:FDifficulty: ModerateObjective: Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

51.An index can only be created in the Design View. T F

Answer:TDifficulty: ModerateObjective: Indexing and Primary Keys

Reference: Indexing and Primary Keys

Chapter: 2

Application: Access

Textbook: Microsoft Office Access 2007 In Business, Core , 1/e

52.A primary key could be placed on the Last Name field of a database that marks an extended family tree. T F