Access MCQs (Chapterwise Multiple Choice Questions)

A field in an access database table that has no value is determined by access to have a ____ value.

Custom

Zero

Null

Number

Null

Answer & Explanation

Correct Answer: Null

Note: This Question is unanswered, help us to find answer for this one

Which of the following helps to study the information in a table and then make changes to streamline the data?

Table Data Wizard

Sync Table Contents

Evaluate Data

Table Analyzer Wizard

Access Analyzer Wizard

Answer & Explanation

Correct Answer: Table Analyzer Wizard

Note: This Question is unanswered, help us to find answer for this one

In Design View, what is the first step to create a query?

Database Tools->Relationships->Query

Create->Query Design->Split Form

Create->Query Design-> Double-click on table name

Data->Create-> Query

Answer & Explanation

Correct Answer: Create->Query Design-> Double-click on table name

Note: This Question is unanswered, help us to find answer for this one

After opening a table in Datasheet View in Microsoft Access 2016 database. which of the following keyboard shortcuts is used to display the Field List pane?

Ctrl+F6

Ctrl+F8

Alt+F8

Alt+F

Answer & Explanation

Correct Answer: Alt+F8

Note: This Question is unanswered, help us to find answer for this one

A modem is required for ________________ internet access.

Tethering

Point-to-Point

Fiber-optic cables

All of the above

Answer & Explanation

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

With a(n) ____, you can enter a value either by typing the value or by selecting it from a list.

Combo box

Page Order

Text Box

Property Sheet

Answer & Explanation

Correct Answer: Combo box

Note: This Question is unanswered, help us to find answer for this one

Which of the following is not a Relationship and Lookup error?

Lookups require an associated Relationship to be compatible with the Web.

Limit to List must be set to True if Allow Multiple Values is set to True.

Enable Referential Integrity must be False if Allow Multiple Values is set to True for a lookup.

A table with more than 220 fields is incompatible with the Web.

Answer & Explanation

Correct Answer: A table with more than 220 fields is incompatible with the Web.

Note: This Question is unanswered, help us to find answer for this one

Which of the following is not included in the Access Built-In Functions for SQL Aggregate

Count(«expression»)

StDev(«expression»)

Median(«expression»)

Sum(«expression»)

VarP(«expression»)

Answer & Explanation

Correct Answer: Median(«expression»)

Note: This Question is unanswered, help us to find answer for this one

Why should you enter sample data in tables after creating them?

To create a preliminary list of fields

To identify primary and foreign keys

To review existing data

To check for potential data maintenance problems

Answer & Explanation

Correct Answer: To check for potential data maintenance problems

Note: This Question is unanswered, help us to find answer for this one

Access 2007/2010 theoretically allows how many concurrent users accessing the same .accdb database file?

256

255

100

1000

50

Answer & Explanation

Correct Answer: 255

Note: This Question is unanswered, help us to find answer for this one

Access Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.