Computer & IT

note!Answer: C) Queries
Queries store commands that retrieve data from one or more tables.

note!Answer: B) Reports
Reports format data for printing or presentation as the final output.

note!Answer: D) All Of Above
Access provides Design View, the Table Wizard and Datasheet entry as ways to create a table.

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.