Q 01/05

Microsoft Access has only ever been released for which operating system, unlike Excel and PowerPoint?

A) Mac OS

B) Linux

C) Windows

D) ChromeOS

Answer · why

C) Windows

Windows is the only home Access has ever had: its forms and reports do not run anywhere else, so Office for Mac has never included it.

Q 02/05

Access 2007 introduced which file extension for its databases, replacing the older .mdb format?

A) .accdb

B) .mdbx

C) .adp

D) .sqlite

Answer · why

A) .accdb

.accdb arrived with Access 2007 and brought new abilities, including fields that hold several values at once and links to SharePoint lists.

Q 03/05

In an Access table, which field must hold a unique value for every record, such as a customer number?

A) Calculated field

B) Foreign key

C) Lookup field

D) Primary key

Answer · why

D) Primary key

Primary key is the name for that field, and Access marks it with a small key icon in Design view; a table can have only one.

Q 04/05

Which Access data type fills in a unique value by itself each time a new record is saved?

A) Calculated

B) AutoNumber

C) Large Number

D) Currency

Answer · why

B) AutoNumber

AutoNumber fields fill themselves in when a record is first saved, which is why Access suggests one whenever a table has no obvious unique field.

Q 05/05

In an Access query, which wildcard character stands in for any number of unknown characters?

A) Asterisk

B) Question mark

C) Number sign

D) Ampersand

Answer · why

A) Asterisk

Asterisk is the catch-all wildcard: the criterion wh* finds what, white and why, while a question mark stands for just one character.