Microsoft Access MCQs for Competitive Exams

201

What does "Referential Integrity" ensure?

A That all data in a table is spelled correctly B That the relationships between tables remain consistent and valid C That the primary key is always a number D That the database is backed up regularly

Answer & Solution Discuss Save Report

202

The most common type of relationship between two tables in a relational database is:

A One-to-One B One-to-Many C Many-to-Many D No relationship

Answer & Solution Discuss Save Report

203

What is a "Foreign Key"?

A A key that is not from your country B A primary key from one table that is placed into a second table to form a relationship C A key that is used to encrypt the database D Another name for the primary key

Answer & Solution Discuss Save Report

204

What is a "Primary Key" in a database table?

A A field used to sort the data in a table B A field, or combination of fields, that uniquely identifies each record in the table C The first field that is created in a table D A field that links to another table

Answer & Solution Discuss Save Report

205

A "Module" in Access is an object that contains:

A A list of database security settings B A backup copy of a table C Custom programming code written in Visual Basic for Applications (VBA) D A collection of macros

Answer & Solution Discuss Save Report

206

When you first open an Access table, you are in _________ View.

A Design B Datasheet C Form D Layout

Answer & Solution Discuss Save Report

207

In a report's Design View, controls in the "Report Header" section will appear:

A At the top of every page B Only at the very beginning of the entire report C At the bottom of every page D At the end of the entire report

Answer & Solution Discuss Save Report

208

The "AutoNumber" data type is useful for:

A Performing currency calculations B Storing phone numbers C Automatically generating a unique number for each new record, often used as a primary key D Storing automatic timestamps

Answer & Solution Discuss Save Report

209

To combine data from two separate tables that have a common field, you would use a:

A Form B Report C Query D Macro

Answer & Solution Discuss Save Report

210

The object that is considered the "engine" that retrieves and processes data behind the scenes for forms and reports is the:

A Table B Query C Macro D Module

Answer & Solution Discuss Save Report