Microsoft Office Software Training

Skills Tests

If you are unsure about which level course you should be taking, click on the appropriate link below and answer the simple questions to be given a guide.
Microsoft Word Skills Test
Microsoft Excel Skills Test
Microsoft Access Skills Test
Microsoft Powerpoint Skills Test
Microsoft Outlook Skills Test

Microsoft Access Skills Test

Please answer the following questions:
What is a calculated control?
A limit set on values entered
0

A field that displays a value worked out from information given it
2

A calculated value in a table
0

Don't know
0

To provide printed information summarizing data we would use
Reports
2

Forms
1

Sheets
0

Don't know
0

What kind of query can change entries in a table?
Action Query
1

Update Query
2

Append Query
1

Change Query
0

A field in a table can contain
Any type of data
1

Only one type of data
2

A mixture of types of data
0

Don't know
0

A table contains records for staff, and each staff member is in one of 6 department. To print information about the staff listed by department we would use.
Page break forms
0

Grouping levels
2

Parameters in queries
0

Filters, and print 6 reports
1

If I’ve got 24 staff, and a table listing their favourite drinks, what kind of relationship should the tables have:-
Drinks to staff
0

One to many
2

First to last
0

Staff to query/drinks
0

What is the correct formula to use in a table to multiply the widgets field by the quantity field?
=sum([widgets]*[quantity])
1

=(quantity)*(widgets)
0

=multiply[widgets],[quantity]
0

Can't be done
2

We control the way tables interact with
The tables panel
0

The relationships button
2

The interactivity console
0

They can't interact
0

Filtering means
Getting rid of problem data
0

Finding just the data you need
2

Reducing larger tables into smaller ones
1

Don't know
0

Data in access can be held in
Tables
2

Queries
0

Forms
0

Reports
0

A parameter query might
Ask the user for input
2

Adjust the operating parameters of the database
0

Filter data to preset parameters
1

Don't know
0

A primary key may contain
Only unique values
2

Only important values
0

Only key values
0

No values, only text
2

Intec Business Colleges plc, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net