MS Access Practice Set-1 | Free MCQ Quiz - ComputerKite

MS Access Practice Set-1 covers tables, queries, forms, and the basics of building a database in Access, useful for Loksewa, computer operator exams, and database fundamentals courses.

Start the quiz below and see where you stand.

For more practice, try Computer Fundamentals, MS Word, or check the full list of MCQ categories.

/50

Created by

Lavdev Awasthi

MS Access Practice Set-1

Welcome to MS Access Practice Set-1

Quiz सुरु गर्न Start मा Click गर्नुहोला र सकिएपछि Submit गर्नुहोला ।

यो Quiz Unlimited दिन पाएनेछ ...

***Best of Luck***

1 / 50

How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

Look up Wizard

Report Wizard

Query Wizard

Form Wizard

2 / 50

What is the corresponding text for the <#1/1/95# validation rule setting?

Value must be less than 95 characters

Enter a value less or more than 1,195

Enter a date before 1995

All of above

3 / 50

Unlike text data type, this can store up to maximum of 65, 535 characters.

number

memo

data/time

All of above

4 / 50

In a database table, the category of information is called ____________

field

record

tuple

All of above

5 / 50

According to access help, what’s a good way to design a database?

Use the table analyzer to reverse-engineer your flat source data.

Start from data access pages and work backward

Sketch the design of your database using a pencil and paper

None of above

6 / 50

Which of the following is not a legitimate section for form objects?

Page footer

Form header

Form detail

Group header

7 / 50

The three parts of an IIF function are separated by _____.

commas

asterisks

dashes

semicolons

8 / 50

Which of the following queries modifies fields not records?

Update

Delete

Make-Table

Append

9 / 50

What is the use of Cascade Delete Option in MS Access?

It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted

It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted

It makes sure that all the records from the parent table and child table is deleted from selected database

None of above

10 / 50

Which of the following expresses correct order?

Databases, Tables, Files, Records, Field, Character

Characters, Fields, Records, Tables, Database, Files

Characters, Fields, Records, Tables, Files, Databases

Files, Databases, Tables, Records, Fields, Characters

11 / 50

A file containing relatively permanent data is

Sequential file

Random file

Master file

Transaction file

12 / 50

It is an association established between common fields of two tables.

relationship

line

records

primary key

13 / 50

Which of the following Data Type is used to store picture in MS Access

OLE Object

Picture

Memo

Picture cannot be stored

14 / 50

__________ is the clear leader for personal databases.

MySQL

Borland dBase

Microsoft FoxPro

Microsoft Access

15 / 50

When entering field name, how many characters you can type in maximum?

Any number of character

16 / 50

The result of a query is displayed in a

Record

Query datasheet

Form

Query table

17 / 50

You can move between fields in a form by using any of these keys except

Shift+tab

Tab

Enter

Page up

18 / 50

To create queries in Access

You can drag and drop fields on query builders

You can use query wizard or design view

you can type the SQL command in SQL view

All of above

19 / 50

Which of the following database objects can have more than one Group Header/Footer section?

Forms

Queries

Reports

Tables

20 / 50

Data can be import into Access Database from

HTML Files

Word Files

Excel Files

PowerPoint Files

21 / 50

Which Form tool creates a new form that show both a form and datasheet views?

Split Form

Multiple Item Form

Form

Form Wizard

22 / 50

In access, this displays the results of a calculation in a query

Source field

Calculated field

Child field

Lookup field

23 / 50

Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

Right-click, choose from the shortcut menu Copy and Paste.

Press [Ctrl]+[+] and [Ctrl]+[-].

Press [Ctrl]+[C] and [Ctrl]+[V].

From the ribbon, select Copy and Paste.

24 / 50

When creating a new table which method can be used to choose fields from standard databases and tables

Create table in Design View

Create Table using wizard

Create Table by Entering data

None of above

25 / 50

A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?

None

26 / 50

What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?

The object is deleted from the Project pane.

The associated code is displayed in the Code pane.

The associated code is displayed in a new window.

The object’s property sheet opens.

27 / 50

You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting record set have?

Not enough information to tell

28 / 50

In Access 2007, to make changes in the Trust Center, you need to go to the ____.

Database Tools command tab

Quick Access toolbar

Navigation Pane

Microsoft Office button

29 / 50

Which of the following is not a view for interacting with a form object?

Form view

Design view

Layout view

Datasheet view

30 / 50

Which data type is better to use for storing the price of an item?

AutoNumber

Number

Text

Currency

31 / 50

Which major database object stores all data?

Record

Field

Query

Table

32 / 50

To create primary key for a table when in design view

Mark the Primary check box in field name of required field

Click the Primary Key button in Design ribbon when the cursor is in required field

Type PRIMARY in field type box when creating required field

None of the above

33 / 50

A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.

criteria row

format layout

format row

aggregate function

34 / 50

An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.

n-tier

2-tier

4-tier

3-tier

35 / 50

What is the maximum length a text field can be?

265

255

120

36 / 50

The page count of a report can be determined by clicking the _______ button.

First Page

Last Page

37 / 50

Both conditions display on the same row in the design grid when ___operator is in use

AND

38 / 50

What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?

Nothing happens

A relationship is created

Error occurs

Edit relationship dialog box appears

39 / 50

What is the first step in creating a form or report with the form wizard or report wizard?

Reading several screens of mostly useless information and clicking next

Selecting the fields that you want to appear in the form or report

Selecting how the form or report should be formatted

Selecting the underlying table or query on which you want to base the form or report

40 / 50

Which of the following Format supports for Data Type Yes/No?

True/False

On/Off

Yes/No

All of Above

41 / 50

Which control does access use to link data access page components to Access data?

Microsoft dynamic data control

Microsoft data connection control

Microsoft office data source control

None of the above

42 / 50

A part of database that stores only one type of data is

Record

Query

Report

Field

43 / 50

Queries can be created in Access by

Typing Queries in SQL View

Drag and Drop fields on Query Builder

Using Query Wizard

All of the Above

44 / 50

Which of the following data types automatically generates a consecutive number?

AutoNumber

Memo

Text

Number

45 / 50

A database can be best described as

Organized collection of data

Graphical representation of data

Useful presentation of data

All of above

46 / 50

What is the propose to a sub datasheet?

To display summarized data.

To provide a hierarchical view of related tables or queries in a single window

To display grouped data in a report

All of the above

47 / 50

Query design window has two parts. The upper part shows

Criteria

Name of fields, field type and size

Sorting check boxes

Tables with fields and relationships between tables

48 / 50

Which of the following methods CANNOT be used to delete records from a table?

Selecting records and pressing [Delete]

From the ribbon, selecting Delete Record

Pressing [Ctrl]+[']

Clicking the Delete Record button

49 / 50

Which of the following is not a valid Data Type in MS Access?

AutoNumber

Picture

Memo

Currency

50 / 50

In a module, a(n) _______ is a series of commands and properties that perform a specific task.

procedure

macro

property

event

Your score is

Post Views: 23

MS Access Practice Set-1 | Free MCQ Quiz – ComputerKite

Start the quiz below and see where you stand.

Welcome to MS Access Practice Set-1

Leave a Comment Cancel Reply