MS - Access Exam

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

1 Mark(s)

Lookup field
Calculated field
Source field
Child field

A __________ enables you to view data from a table based on a specific criterion

1 Mark(s)

Form
Query
Macro
Macro

Query can be use to select data from

1 Mark(s)

Single Table
Single Table
Both A & B

What is the difference between ‘open’ and ‘open exclusively’

1 Mark(s)

Open statement opens access database files and open exclusively opens database files of other program like oracle
Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
Both open and open exclusively are same
Open exclusive command does not exist in MS Access

Which of the following store command to retrieve data from database?

1 Mark(s)

Forms
Reports
Queries
Tables

Query design window has two parts. The upper part shows

1 Mark(s)

Name of fields, field type and size
Tables with fields and relationships between tables
Criteria
Sorting check boxes

This query wizard will create a select query.

1 Mark(s)

Crosstab
Find duplicates
Simple
Design view

Which of the following database objects extracts information from one or more tables or queries?

1 Mark(s)

Forms
Queries
Reports
Tables

In MS Access “Hyperlink” Data Type can store

1 Mark(s)

Web Address
Email Address
Path of a File
All of Above

Which of the following database objects asks a question of information in a database and then displays the result?

1 Mark(s)

Tables
Reports
Queries
Forms

In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______

1 Mark(s)

Child , Parent
Parent , Child
Brother , Sister
Father , Son

Which criteria return only those addresses beginning with the letter “K”?

1 Mark(s)

Address = “K”
Address = “K*”
Address = “K?”
Address = “K#”

______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.

1 Mark(s)

Design View
Layout View
Print Preview
Report View

Which of the following may not be a database?

1 Mark(s)

Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary

Which of the following is the DBMS type

1 Mark(s)

Flat File System
Hierarchical DBMS
Relational DMBS
All of the Above

The ______ is a wild card that represents one or more characters.

1 Mark(s)

Question mark
Asterisk
Exclamation mark
Dollar sign

Which major database object stores all data?

1 Mark(s)

Field
Query
Record
Table

The complete information about an entity in a database is called

1 Mark(s)

Data
Information
Field
Record

Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

1 Mark(s)

File menu
View manu
Database Tab
Tools manu

You can not import data into access database from

1 Mark(s)

Dbase iii database files
Excel spreadsheets
Comma delimited text files
None of the above

What is the full form of SQL?

1 Mark(s)

Sophisticated Question List
Structured Question List
Structured Query Language
Small Query Length

Saving a database in access is done

1 Mark(s)

At the beginning of the database
The first time you save data
When closing the application
During auto save

What is the purpose of the description column in table design view?

1 Mark(s)

To define the data type applied to each field within the table
To describe the data that should be entered in each field
To enter lookup data that the field should refer to.
None of the above

Referential integrity cannot be set for _______________ relationships.

1 Mark(s)

One-To-One
Indeterminate
One-To-Many
Many-To-Many

If you write criteria values vertically (one in a row) it will mean

1 Mark(s)

Or conditions
And conditions
Not condition
None of above

To create a new table, in which method you don’t need to specify the field type and size?

1 Mark(s)

Create table in Design View
Create Table using wizard
Create Table by Entering data
All of above

Following is not a database model

1 Mark(s)

Network database model
Relational database model
Object oriented database model
None

The __________ is the software tool to store or access data.

1 Mark(s)

Table
DBMS
Query
Report

This key uniquely identifies each record

1 Mark(s)

Primary key
Key record
Unique key
Field name

A __ name must be unique within a database

1 Mark(s)

Table
Field
Record
Character

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 any key of a table into any key of another table
All of the above

What it is called to present information in a particular order based on numeric or alphabetical value?

1 Mark(s)

Sorting
Searching
Arranging
Cropping

A(n) ____ in the Record Selector indicates a new record.

1 Mark(s)

Check mark
Pencil
Asterisk
Arrow

Which of the following functions is used to all the values in a numeric field?

1 Mark(s)

Num
Count
Sum
Total

What does the show check box in query design window indicate

1 Mark(s)

It indicates whether the field is to be used or not
It indicates whether the field is to be displayed in query result or not
It indicates whether the field names to be displayed in query result or not
None of above

The______button on the tool box display data from a related table

1 Mark(s)

Sub form sub report
Relationships
Select objects
More controls

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

The quickest way to add a field to the selected fields list is to double-click its field name in this list.

1 Mark(s)

Find fields
Search fields
Search record
Available fields

Which of the following database object produces the final result to present?

1 Mark(s)

Forms
Reports
Queries
Tables

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

1 Mark(s)

Memo
Picture
Currency
AutoNumber

MS - Access Exam : Question 1 of 40