WorksheetsYear 6 MS Access
Total questions: 10
Worksheet time: 50mins
Information we enter in MS Access is stored in the ______________ we created
Column
Row
Database
Data type
A table is divided into __________________
field and form
fields and records
datasheet and design
record and form
To delete or rename a field in Microsoft Access, the first thing to do is _________
Right click on the field
Delete the field
Double Click on the field
Open the field
We have two kinds of view in Access. Datasheet view and _____________ view.
Database
Datasheet
Design
Primary
When moving from top to bottom in a database, you are on a ___________
FIeld
Data
Row
Excel
Which view do we usually use to enter field and datatype in the database?
Design View
Record View
Field View
Form View
In Microsoft Access, a field labelled “Price” must be created as
Currency
Primary Key
Number
Short Text
Which of these is NOT an example of a data type?
Picture
Short Text
Date and Time
Yes/No
Microsoft Excel uses columns while Microsoft Access uses _________
Fields
Records
Tables
Movement
Records and Fields make up a _______________
Database Management System
Record
Primary Key
Security
