MS - Access Exam

Which leads you through the process of creating a table?

1 Mark(s)

Wizard
Assistant
Relation
Coach

_______is used to build ‘intuitive’ queries.

1 Mark(s)

SQL
Xbase
QBE
XML

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 two form layout types will display multiple records at one time are tabular and ___________.

1 Mark(s)

Columnar
Justified
Date sheet
Pivot table

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

After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

1 Mark(s)

You need to delete the whole table. There is no method to remove a particular field only.
Delete all the fields from third downwards and reenter the required fields again.
Select the third column in datasheet view then delete
Select the third row in table design view then delete

A primary key in any table has the properties

1 Mark(s)

Not Null
No Duplicates
Both of above
None of above

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

1 Mark(s)

Query
Filter
Form
Report

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

Database Management Systems are featured with:

1 Mark(s)

The facility to easy editing, spelling check, auto pagination, lay out and printing reports
The ability to store large amount of data to facilitate easy update, sort and retrieval
The ability to calculate efficiently with the help of built-in functions and analyze
All of above

This is the stage in database design where one gathers and list all the necessary fields for the database project.

1 Mark(s)

Data definition
Data refinement
Establishing relationship
None of the above

Which of the following is NOT possible when printing Forms?

1 Mark(s)

Print page 1, 3, and 5
Print pages 1 through 5
Print selected records
Print only the third record

In a query, which row do you need to place wildcards to affect a parameter?

1 Mark(s)

Arguments
Criteria
Fields
Tables

Which is NOT an option of the Picture Size Mode property?

1 Mark(s)

Clip
Fit
Stretch
Zoom

This data type allows alphanumeric characters and special symbols.

1 Mark(s)

Text
Memo
Auto number
None of these

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

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

1 Mark(s)

Microsoft dynamic data control
Microsoft data connection control
Microsoft office data source control
None of the above

Which query do you use to answer the question “What is the average salary of the employees”?

1 Mark(s)

Search query
Cross tab query
Select query
Update query

The insertion point looks like a(n) ____.

1 Mark(s)

H-pointer
I-pointer
H-beam
I-beam

A file containing relatively permanent data is

1 Mark(s)

Random file
Transaction file
Master file
Sequential file

A database object in MS Access that stores a question about the data in database?

1 Mark(s)

Table
Form
Query
Report

Data can be import into Access Database from

1 Mark(s)

Word Files
Word Files
PowerPoint Files
HTML Files

Which of the following is NOT true about background images?

1 Mark(s)

They are similar to watermarks in Word.
They are displayed behind the controls in a form.
They do not print when a form or a report is printed.
They can be inserted on a form or a report.

Which is not an option for Filter on a text field?

1 Mark(s)

Begins With
Between
Contains
End With

According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?

1 Mark(s)

Cbo
Cob
Cmb
Cbx

Which of the following is not a data type

1 Mark(s)

Picture/graphic
Data/time
Texst
Number

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

1 Mark(s)

Yes/No
True/False
On/Off
All 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

How can you display pivot table report summary data in a currency format?

1 Mark(s)

Use custom calculation
Type in the currency symbol
Modify the field settings
None of the above

To remove all Sorts in a table you can click the ______ command.

1 Mark(s)

Clear All Sorts
Delete All Sorts
Eliminate All Sorts
Remove All Sorts

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

1 Mark(s)

Forms
Reports
Queries
Tables

Which of the following expresses correct order?

1 Mark(s)

Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters

What is the maximum length a text field can be?

1 Mark(s)

120
255
265
75

Which is not a command that is selectable from right click menu of a field column?

1 Mark(s)

Hide columns
Rename columns
Freeze columns
Sort descending

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

1 Mark(s)

A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens

The expression builder is an access tool that controls an expression___ for entering an expression

1 Mark(s)

Table
Box
Cell
Palette

A ____ is a major database object used to display information in an attractive, easy-to-read screen format.

1 Mark(s)

Form
Query
Report
Table

A(n) _____ is a control that, when clicked, executes an action or series of actions.

1 Mark(s)

Combo box control
AutoFormat
Conditional Format
Command button

What type of controls are text boxes when data from the recordset is visible?

1 Mark(s)

Align
Bound
Calculated
Unbound

Collection of related records in a database is known as

1 Mark(s)

File
Bench
Table
Relationship

MS - Access Exam : Question 1 of 40