GCOM-Microsoft Access Test -9

In MS Access, Field Value may contain?

1 Mark(s)

Text
Date & Time
Picture
All of the Above

Which of the following is invalid field name?

1 Mark(s)

Student.Address
StudentsAddress
Student_Address
Student Address

In a table to insert User\'s Voice, Data field should be____________?

1 Mark(s)

OLE Object
SoundField
VoiceField
Memo

Primary key is_________?

1 Mark(s)

Uniquely identifies each record
Cannot be repeated
AutoNumber is example of Primary key
All of the above

Data can be import into Access Database from?

1 Mark(s)

Word Files
Excel Files
PowerPoint Files
HTML Files

Queries can be created in Access by__________?

1 Mark(s)

Typing Queries in SQL View
Drag and Drop fields on Query Builder
Using Query Wizard
All of the Above

Query can be use to select data from?

1 Mark(s)

Single Table
Multiple Tables
Both A & B
None of above

Which of the following is use to get data from user?

1 Mark(s)

Query
Pages
Form
Report

Relationship can be establish between two tables by_____________?

1 Mark(s)

Drag Primary key of a table into Foreign key of another table
Drag Foreign key of a table into Primary key of another table
Drag Foreign key of a table into Primary key of another table
All of the above

Which of the following is use to view or print the data in organized manner?

1 Mark(s)

Query
Report
Table
Form

What is the use of Referential Integrity in MS Access?

1 Mark(s)

It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
None of above

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

1 Mark(s)

It makes sure that all the records from the parent table and child table is deleted from selected database
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
None of above

Macros can recover from ___________ in a controlled manner.

1 Mark(s)

events
modules
arguments
errors

A collection of related tables is called__________?

1 Mark(s)

Row
Record
Database
File

After creating the table which of the following is correct?

1 Mark(s)

Fields cannot be added
Fields cannot be deleted
Fields can added but only once
Fields can added and deleted as needed

Validation Rule in a field will?

1 Mark(s)

Checks the value entered when user leaves the field
Displays the value in specified format when user leaves the field
Defines the appearance for the text
There is no option of Validation Rule

Which of the following relationship is not valid in MS Access ?

1 Mark(s)

Many to Many
Many to Null
One to One
One to Many

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

1 Mark(s)

Yes/No
True/False
On/Off
All of Above

To create a table in Access?

1 Mark(s)

Database should be created before create table
Table can be created using Table Templates
There must be at least one Primary key in a table
All of the above

Which of the following is the DBMS type?

1 Mark(s)

Flat File System
Hierarchical DBMS
Relational DMBS
All of the Above

GCOM-Microsoft Access Test -9 : Question 1 of 20