Database System

note!Answer: B) Create Table Using Wizard
The Table Wizard lets you pick sample fields from standard database and table templates.

note!Answer: D) F6
In Access Table Design View, F6 moves between the upper field names pane and the lower field properties pane.

note!Answer: A) 50 And 255 Characters
In Access, a Text field defaults to 50 characters and can hold a maximum of 255 characters.

note!Answer: A) 1 Bit
A Yes/No field stores a single bit of data, representing one of two values.

note!Answer: B) Memo
The Memo data type is designed to store long text, up to 64,000 characters.

note!Answer: B) 64
Access field names can be up to 64 characters long.

note!Answer: D) Select The Third Row In Table Design View Then Delete
In Table Design View, you select the field's row selector and press Delete to remove that single field.

note!Answer: A) Input Mask
An Input Mask with a password format displays asterisks as the user types.

note!Answer: C) Select Insert > Picture from the menu
In Access, you add a picture to a report through the Insert menu by choosing Picture.

note!Answer: D) The background of the selected control
The Fill/Back Color button sets the background color of the selected control, while Font/Fore Color changes the text color.

note!Answer: B) A make-table query
A make-table query selects data and creates a new table to store the results. Parameter, update, and crosstab queries do not create separate tables.

note!Answer: A) A conditional expression
An IF expression returns one value when a condition is true and another when it is false, so it is a conditional expression.

note!Answer: A) The control source property
The Control Source property sets the field or expression whose value the control displays.

note!Answer: D) All of the above
Access can import tables, queries, forms, reports, macros, and modules from one database into another.

note!Answer: B) OLE
The OLE Object field type stores embedded objects such as pictures.

note!Answer: A) A parameter query
A parameter query asks the user for a value when run and then displays only the matching records.

note!Answer: B) Summary section
Access report sections include Report Header, Page Header, Group Header, Detail, Group Footer, Page Footer, and Report Footer. There is no Summary section.

note!Answer: B) Selecting the database object and clicking the design button on the database window
Selecting an object in the Database window and clicking the Design button opens it in Design view.

note!Answer: D) A cross tab query
Cross tab queries summarize data in a grid with row and column headings, such as regions and months.

note!Answer: A) Table
Tables store the data, so they must exist before forms, reports, or queries that work on that data.