Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Grade 8 Final Revision

Total questions: 25

Worksheet time: 9mins

Name
Class
Date
1.

______________ view is used to enter data in a table.

a)

Design View

b)

Layout View

c)

Datasheet View

d)

Report View

2.

A ____________________ is an attribute that defines the field's appearance or behavior within a database.

a)

Field Name

b)

Field Property

c)

Table Name

d)

Table Property

3.

To show or hide Navigation Pane press ________________ key.

a)

F8

b)

F9

c)

F10

d)

F11

4.

____________________ datatype stores numeric information that you can use for calculations.

a)

Text

b)

Number

c)

Currency

d)

Date/Time

5.

___________________ is used to embed an object created in another application, such as Microsoft Word document, Excel spreadsheet etc.

a)

Hyperlink

b)

Attachment

c)

OLE

d)

Lookup Wizard

6.

By default, each field in Design View is assigned a _______________ data type.

a)

Text

b)

Number

c)

AutoNumber

d)

Date/Time

7.

Click on the ________________ button on the Design tab in the Tools tab.

a)

Delete Column

b)

Delete Rows

c)

Delete Field

d)

Delete All

8.

To select the field that you want to move, click on its field _______________.

a)

Selector

b)

Footer

c)

Header

d)

Column

9.

Columns can be temporarily hidden by using the _______________ option.

a)

Delete

b)

Move

c)

Hide

d)

Freeze

10.

To sort the alphanumeric data in a table field, select the __________________ option.

a)

Sort A to Z

b)

Sort Smallest to Largest

c)

Both a and b

d)

None of the above

11.

To import data from another application, click on Excel option in the ____________________ group on the External Data tab.

a)

Import & Link

b)

Export

c)

Collect Data

d)

Tools

12.

To perform arithmetic operation on a table, click on ____________ tab in the ribbon.

a)

Totals

b)

Transaction

c)

Calculation

d)

Autosum

13.

To display the specific fields of a column, _____________ option is used.

a)

Freeze

b)

Filter

c)

Sorting

d)

Hiding

14.

You can specify the filter for a query in the design view in the _________________

a)

Criteria Row

b)

Condition Row

c)

Criteria Pane

d)

Criteria Column

15.

__________________ property can be used to set multiple criteria in a query.

a)

And

b)

Sort

c)

Or

d)

Criteria

16.

___________________ property is used to filter the data either in the ascending or descending order.

a)

Or

b)

Criteria

c)

Sort

d)

Field Row

17.

The bottom pane of the Query Design view window displays the ________________________.

a)

Columns

b)

Design Grid

c)

Table Relationships

d)

Fields

18.

_____________ view is used to enter or edit data.

a)

Form view

b)

Design View

c)

Layout View

d)

Datasheet View

19.

You can set the properties of a form by clicking on the _____________ button in the Tools group on the Design tab.

a)

Property Box

b)

Property Pane

c)

Property Sheet

d)

Property grid

20.

A database object which allows data entry to table in an interactive manner is called ________________________.

a)

Query

b)

Report

c)

Table

d)

Form

21.

_____________ view is used to adjust the design of your form.

a)

Form View

b)

Design View

c)

Layout View

d)

Datasheet View

22.

The ____________________ is an effective way to organise and summarise data.

a)

Queries

b)

Tables

c)

Reports

d)

Forms

23.

Which key is to pressed from the keyboard to select multiple fields from the available field's columns?

a)

Ctrl

b)

Enter

c)

Esc

d)

Alt

24.

The _____________ section displays the records that appear between page header and page footer.

a)

Detail

b)

Report Header

c)

Report Footer

d)

Page Header

25.

The _________________ pane will be displayed on the right side of the Access window.

a)

Navigation

b)

Property

c)

Field List

d)

Report