Font size
WorksheetsMICROSOFT ACCESS SPRING TERM
Total questions: 14
Worksheet time: 8mins
Information we post online is stored in a ______________
Table
Record
Database
Form
A table is divided into __________________
field and form
fields and records
datasheet and design
record and form
A __________ helps us to keep the information in our database structured
Primary Key
Record
Autonumber
Field
Which of these options is the best to use for a primary key?
Number
Currency
Short Text
Autonumber
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 (a) view.
A collection of words, numbers or pictures with meaning is known as (a)
When moving from top to bottom in a database, you are on a (a)
Which view can be used to enter data into 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 field type?
Picture
Short Text
Date and Time
Yes/No
1. Data _____________ refers to ensuring accuracy and consistency of data.
Integrity
Collation
Assessment
System
Microsoft Excel uses columns while Microsoft Access uses _________
Fields
Records
Tables
Movement
Records and Fields make up a database _______________
System
Record
Primary Key
Security
