Computer & IT

note!Answer: A) primary key
A primary key is a field whose value uniquely identifies each record in a table.

note!Answer: A) text
The Text data type stores letters, numbers, and special symbols.

note!Answer: A) memo
The Memo data type stores up to 65,535 characters, while Text is limited to 255.

note!Answer: B) Select
A Select query is the most common query type. It retrieves records from one or more tables and displays them.

note!Answer: C) Parameter
A Parameter query displays its own dialog box asking the user for criteria when it runs.

note!Answer: C) crosstab
A crosstab query summarizes and restructures data, calculating sums, counts, or averages in a grid.

note!Answer: C) expression
An expression combines operators, values, and fields to produce a result.

note!Answer: A) Cross tab Queries
Crosstab queries summarize and analyze data in a row-and-column format, which makes them best for analysis.

note!Answer: C) Oracle
Oracle is a database management system. MS Word, MS Excel, and Lotus 1-2-3 are not.

note!Answer: B) Make Table Query
A Make Table query selects data from one or more tables and creates a new table from the results.

note!Answer: A) Bound Control
A bound control is linked to a field in a table or query, so it displays that data.

note!Answer: C) Summary Section
Access report sections are Report Header, Page Header, Detail, Page Footer and Report Footer. There is no Summary section.

note!Answer: D) None of the above
Access can import dBase files, Excel spreadsheets and comma-delimited text files, so none of these is excluded.

note!Answer: D) All Of Above
A table can be viewed in Datasheet, Design, PivotTable and PivotChart views.

note!Answer: D) Lookup Wizard
The Lookup Wizard creates a combo box field that gives a drop-down list of values.

note!Answer: A) Database Window
The Database Window is the central control panel listing all objects in an Access database.

note!Answer: A) Relationship
In database design, the third stage is establishing relationships between the tables.

note!Answer: B) Field
A field is a column that stores one category of information. A record is a row.

note!Answer: A) Primary Key
A primary key uniquely identifies each record in a table and cannot contain duplicates.

note!Answer: B) Relationship
A relationship is an association between tables based on common fields.