MS - Access Exam

An application that executes on separate PCs like this is called a(n) __________ application.

1 Mark(s)

Enterprise
Distributed
Tier
Global

What is a form in MS Access?

1 Mark(s)

It is a printed page where users will write their data to fill it up
It is an input screen designed to make the viewing and entering data easier
This is an important part of database used by analysts to draw conclusions
All of above

What determines a table’s sort order?

1 Mark(s)

AutoNumber field
Index field
Field order
Primary key

This type of database contains multiple tables that are connected to produce combined output from all tables.

1 Mark(s)

Bound
Linked
Relational
Joined

In access, the best types of queries to use for data analysis are:

1 Mark(s)

Select queries
Parameter queries
Action queries
All of the above

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

1 Mark(s)

Dashes
Asterisks
Semicolons
Commas

Any report, including a basic report, can be modified in __.

1 Mark(s)

Form View
Layout View
Print Preview
Report View

Following is not a database model

1 Mark(s)

Network database model
Relational database model
Object Oriented database model
None

Each record is constituted by a number of individual data items which are called

1 Mark(s)

Fields
Data Types
Relations
Tables

Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

1 Mark(s)

Foreign key
Native key
Composite key
Primary key

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

1 Mark(s)

Tuple
Field
Record
All of above

The Search tool CANNOT be used on which major Access object?

1 Mark(s)

Forms
Queries
Reports
Tables

You can enclose the prompt within square braces in criteria to create

1 Mark(s)

Parameter query
Select query
Action query
Crosstab query

What are the columns in a Microsoft Access table called?

1 Mark(s)

Rows
Fields
Cells
Records

To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?

1 Mark(s)

Datasheet
Justified
Stacked
Tabular

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 database objects extracts information from one or more tables or queries?

1 Mark(s)

Forms
Queries
Reports
Tables

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

A primary key in any table has the properties

1 Mark(s)

Not Null
No Duplicates
Both of above
None of above

The complete information about an entity in a database is called

1 Mark(s)

Data
Information
Field
Record

A ____ often display summary data such as totals or counts.

1 Mark(s)

Group Header
Group Footer
Report Header
Page Footer

The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.

1 Mark(s)

Primary, foreign
Primary, common
Foreign, primary
Foreign, common

We can remove a relationship defined between two tables by

1 Mark(s)

From edit menu choose delete relationship
Select the relationship line and press delete
Choose delete option from relationship menu
All of above

In MS Access, Field Value may contain

1 Mark(s)

Text
Date & Time
Picture
All of the Above

When increasing the Control Padding, space is added where?

1 Mark(s)

Between the content of the controls and the outside edge of then controls
Between all controls
Between the control and the Form\’s edge
Between controls and gridlines

If a piece of data is stored in two places in the database, then a

1 Mark(s)

Storage space is wasted
Changing the data is one spot will cause data inconsistency
It can be more easily accessed
Both a and b

Which of the following is invalid field name?

1 Mark(s)

Student.Address
Student\’sAddress
Student_Address
Student Address

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

1 Mark(s)

Picture
OLE Object
Memo
Picture cannot be stored

Which of the following statement is true?

1 Mark(s)

Reports can be used to retrieve data from tables and calculate
Queries can be printed in well formatted manner and presented as the information
Queries can include calculated fields that do not exist in table
Reports and forms are similar but forms are use to print but reports to display on screen only

The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.

1 Mark(s)

Primary, foreign
Primary, common
Foreign, primary
Foreign, common

Which of the following database object is created first before any other created?

1 Mark(s)

Table
Form
Report
Query

Which do you click to display the table\’s primary key and indexes in a separate window?

1 Mark(s)

Indexes button
Primary key button
View datasheet button
View design button

Which of the following queries modifies fields not records?

1 Mark(s)

Append
Delete
Make-Table
Update

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.

In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

1 Mark(s)

Zipcode, firstname, lastname
Firstname, lastname, zipcode
Zipcode, lastname, firstname
Can’t sort by multiple fields

Which of the following database object hold data?

1 Mark(s)

Form
Reports
Queries
Table

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

1 Mark(s)

Form
Form Wizard
Multiple Item Form
Split Form

A composite key is

1 Mark(s)

Required when a table does not have any unique fields in it
The primary key with AutoNumber as the field type
Made up of two or more fields to uniquely identify records
Is a foreign key that uniquely identifies records

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

1 Mark(s)

Line
Relationship
Primary key
Records

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

1 Mark(s)

First Page
Previous
Next
Last Page

MS - Access Exam : Question 1 of 40