MS - Access Exam

The _________ operator will cause a record to be selected only if two or more conditions are satisfied

1 Mark(s)

Or
If or
Range
And

Which of the following functions CANNOT be used in the Totals row?

1 Mark(s)

Average
Count
Maximum
Round

This key uniquely identifies each record

1 Mark(s)

Primary key
Key record
Unique key
Field name

The __________ is used to access one record at a time.

1 Mark(s)

Query
Filter
Form
Report

Which of the following is a condensed form of standard generalized markup language?

1 Mark(s)

HTML
XML
XSD
XSL

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

1 Mark(s)

Forms
Reports
Queries
Tables

In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

1 Mark(s)

Datasheet
Tabular
Justified
Columnar

Which of the following statements about PivotChart View is NOT true?

1 Mark(s)

It is used to graphically summarize and analyze data in a table, query, or form.
It can be used to view different levels of detail or to specify custom layout.
It displays field values that can be switched for different views of data.
It displays the same information as a crosstab query, except for the counts and sums of numeric fields.

What is the process of eliminating redundant fields by separating data into tables called?

1 Mark(s)

Renormalizations
Filtering
Normalization
Sorting

Which of the following options is NOT a part of an option group?

1 Mark(s)

Option button label
Option group frame
Option group label
Option group button

Which field type will you select when creating a new table if you require to enter long text in that field?

1 Mark(s)

Text
Memo
Currency
Hyperlink

In Access 2007, to set a table to open as a document tab, you need to go to the ____.

1 Mark(s)

Microsoft Office button
Navigation Pane
Quick Access toolbar
Database Tools command tab

What data type should yo choose for a zip code field in a table?

1 Mark(s)

Text
Number
Memo
All of above

Which of the following statements regarding charts is incorrect?

1 Mark(s)

It can be inserted into a form only.
It can be designed as a stand-alone object.
It can be linked to the object in which it is placed.
It is a control linked to a data source.

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

1 Mark(s)

First Page
Previous
Next
Last Page

To enter the input mask wizard

1 Mark(s)

Click on the three dots to the right of the caption entry field
Click on the three dots to the right of the format entry field
Click on the input mask toolbar
Click on the three dots to the right of the input mask entry field

To create queries in access

1 Mark(s)

You can drag and drop fields on query builders
You can type the sql command in sql view
You can use query wizard or design view
All of above

The file extension for an access 2003 database is

1 Mark(s)

Exe
Doc
Exc
Mdb

The complete picture of data stored in database is known as

1 Mark(s)

Record
Scheme
System flowchart
Dbms

What is an index?

1 Mark(s)

A wizard that creates a functional database structure based on the user\’s selections
A widely recognized naming convention for database objects
A sort order for records, which is identified in the table design
A set of relationship rules that enforce defined database relationships

Which is not an option for customizing a datasheet window?

1 Mark(s)

Change one row\’s height
Hide one column
Change one column\’s width
Freeze one column

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

1 Mark(s)

Memo
Data/time
Number
All of above

It is a query that when run displays its own dialog box prompting you for information, such as

1 Mark(s)

Select
Crosstab
Parameter
Append

A Smart Tag can be set using the _____ tab in the property sheet.

1 Mark(s)

Format
Tag
View
Data

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

1 Mark(s)

Neter a value less or more than 1,195
Value must be less than 95 characters
Enter a date before 1995
All of above

Which of the following queries modifies fields not records?

1 Mark(s)

Append
Delete
Make-Table
Update

Cascade update option

1 Mark(s)

Means do not change the value in the primary key field if that record has related records in another table
Means change all the related records in child tables if the record in parent table is changed
Both of the above
None of above

The ascending order of data hierarchy is?

1 Mark(s)

Bit – byte – field – record – file – databse
Bit – byte – record – field – file – database
Byte – bit – field – record – file – database
Bit – byte – field – record – database – file

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

1 Mark(s)

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
None of above

In table design view what are the first column of buttons used for

1 Mark(s)

Indicate Primary Key
Indicate Current Row
Both of above
None of above

In table design view, which key can be used to switch between the field names and properties panels?

1 Mark(s)

F3
F4
F5
F6

Which data type is better to use for storing phone number in the following format “977-1-1234567”?

1 Mark(s)

Text
AutoNumber
Number
Currency

Which of the following components has a property sheet that includes settings for the frame and the option group?

1 Mark(s)

Option group label
Option group frame
Option button
Option button labels

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

What determines a table’s sort order?

1 Mark(s)

AutoNumber field
Index field
Field order
Primary key

Which of the following statements about PivotChart View is NOT true?

1 Mark(s)

It is used to graphically summarize and analyze data in a table, query, or form.
It can be used to view different levels of detail or to specify custom layout.
It displays field values that can be switched for different views of data.
It displays the same information as a crosstab query, except for the counts and sums of numeric fields.

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

1 Mark(s)

Num
Count
Sum
Total

Which of the following statements about criteria in a query is NOT true?

1 Mark(s)

Criteria can contain wildcard characters.
Criteria in a query selects or excludes certain records.
Criteria cannot be specified as an expression.
Multiple criteria can be specified using AND, OR, and relational operators.

What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

1 Mark(s)

Display all customers with CustID from 10 to 100
Display all customers with CustID above 10
Display all customers with CustID below 100
Display all customers with CustID from 11 to 99

The complete information about an entity in a database is called

1 Mark(s)

Data
Information
Field
Record

MS - Access Exam : Question 1 of 40