WorksheetsGrade 8 Final Revision
Total questions: 25
Worksheet time: 9mins
______________ view is used to enter data in a table.
Design View
Layout View
Datasheet View
Report View
A ____________________ is an attribute that defines the field's appearance or behavior within a database.
Field Name
Field Property
Table Name
Table Property
To show or hide Navigation Pane press ________________ key.
F8
F9
F10
F11
____________________ datatype stores numeric information that you can use for calculations.
Text
Number
Currency
Date/Time
___________________ is used to embed an object created in another application, such as Microsoft Word document, Excel spreadsheet etc.
Hyperlink
Attachment
OLE
Lookup Wizard
By default, each field in Design View is assigned a _______________ data type.
Text
Number
AutoNumber
Date/Time
Click on the ________________ button on the Design tab in the Tools tab.
Delete Column
Delete Rows
Delete Field
Delete All
To select the field that you want to move, click on its field _______________.
Selector
Footer
Header
Column
Columns can be temporarily hidden by using the _______________ option.
Delete
Move
Hide
Freeze
To sort the alphanumeric data in a table field, select the __________________ option.
Sort A to Z
Sort Smallest to Largest
Both a and b
None of the above
To import data from another application, click on Excel option in the ____________________ group on the External Data tab.
Import & Link
Export
Collect Data
Tools
To perform arithmetic operation on a table, click on ____________ tab in the ribbon.
Totals
Transaction
Calculation
Autosum
To display the specific fields of a column, _____________ option is used.
Freeze
Filter
Sorting
Hiding
You can specify the filter for a query in the design view in the _________________
Criteria Row
Condition Row
Criteria Pane
Criteria Column
__________________ property can be used to set multiple criteria in a query.
And
Sort
Or
Criteria
___________________ property is used to filter the data either in the ascending or descending order.
Or
Criteria
Sort
Field Row
The bottom pane of the Query Design view window displays the ________________________.
Columns
Design Grid
Table Relationships
Fields
_____________ view is used to enter or edit data.
Form view
Design View
Layout View
Datasheet View
You can set the properties of a form by clicking on the _____________ button in the Tools group on the Design tab.
Property Box
Property Pane
Property Sheet
Property grid
A database object which allows data entry to table in an interactive manner is called ________________________.
Query
Report
Table
Form
_____________ view is used to adjust the design of your form.
Form View
Design View
Layout View
Datasheet View
The ____________________ is an effective way to organise and summarise data.
Queries
Tables
Reports
Forms
Which key is to pressed from the keyboard to select multiple fields from the available field's columns?
Ctrl
Enter
Esc
Alt
The _____________ section displays the records that appear between page header and page footer.
Detail
Report Header
Report Footer
Page Header
The _________________ pane will be displayed on the right side of the Access window.
Navigation
Property
Field List
Report
