access

question

The maximum field size for a text field is: A) 25. B) 255. C) 15. D) 200.

A record is a row of all the categories of data pertaining to one person, place, thing, or event. A) True B) False

The purpose of the Navigation Pane is to: A) create a new blank database. B) display and organize your database objects. C) display the Ac

An Access feature that walks you step by step through the process of creating a form is the: A) Form Wizard. B) Form Header. C) Form Guide

A field in a table can have more than one data type. A) True B) False

A blank database has no data and no previously created forms or reports. A) True B) False

When a record is entered in a form, the new record is also added to the table that the form is based on. A) True B) False

Text that is variable in length and usually too long to be stored in a Text field, is stored in this data type. A) Memo B) Field C) Query

In a relational database, you can retrieve information from only one table. A) True B) False

The main purpose of a form is to: A) to organize your database objects. B) retrieve specific data from one or more tables or reports. C) d

If a form is based on a table, it is said to be ____ the table. A) configured with B) linked to C) dependant on D) related to

Each of the following is an Access data type, EXCEPT: A) Currency. B) Text. C) Data. D) AutoNumber.

If a relationship is established between two tables they will share a common: A) field. B) title. C) layout. D) record.

The wildcard characters are represented by which of the symbols listed below? A) Asterisk and question mark B) Exclamation mark and questio

The 348 exchange has been moved to the 704 area code. To quickly update all your records, use this feature. A) Find and Replace B) Cut and

Records stored on the disk are sorted in this order. A) by the first field B) in the order entered C) by primary key field D) by the firs

The records in a query result are displayed in the: A) Navigation Pane. B) Relationship window. C) Datasheet view. D) Design view.

Common fields can be defined as fields that contain the same: A) data in more than one table. B) aggregate functions. C) primary key. D)

Information in a database is typically stored in this, which consists of vertical columns and horizontal rows. A) Record B) File C) Field

Each row in a table contains a(n): A) record. B) view. C) object. D) field.

Which of the following would be appropriate for a field to hold a state abbreviation? A) a two character text field B) a two character memo

The maximum number of characters in a field is set using this property. A) Required B) Input Mask C) Default Value D) Field Size

If the table's column is not wide enough, the data could get truncated. A) True B) False

This field property is used to specify the way numbers, dates, times and text are displayed and printed. A) Expression B) Criteria C) Form

This field property will specify whether or not a value must be entered in a field. A) Field Size B) Validation Rule C) Default Value D)

Which of the following is a primary key? A) A Student ID in a college registration system B) A car model in a Motor Vehicle Dept database

Which of the following views is used for entering records? A) Design B) Query C) Datasheet D) Preview

The smallest unit of information about a record in a database is called a: A) record B) field C) cell D) query

If most of your customers were in the 90210 zip code, then it would make sense to enter 90210 as the zip code field's: A) Default Value prop

Changing the column width will change the: A) amount of data that is displayed B) amount of data that the field can hold C) field size D)

The Design view screen is used to define: A) table names and tab types. B) field names and data types. C) ID names and table types. D) re

If you want to sort a table by the price field with the highest prices coming first, you should sort on the: A) first field in descending or

The data type for a graphics file, such as a picture of a product is a(n): A) Memo. B) Lookup Wizard. C) Hyperlink. D) OLE Object.