NEW
Font size
WorksheetsAccess quiz by Simar Brahma :D
Total questions: 10
Worksheet time: 5mins
What is Primary Key?
It is one (or more) column(s) whose value uniquely identify every row in a table.
It is one method that helps you find information quickly and easily in a database.
They are requests for information. They can sort, calculate, filter, update data and more based on the results you are looking for.
It is a database object that can be used to create a user interface for a database application.
Which data type would be most suitable for the 'Age' field?
Currency
Date & Time
Number
Yes/No
Memo
How do you define a field in a database?
A omplete set of fields
A collection of records
Single piece of information
A firstname
These are examples of field names:
First Name, Surname, Address, Position
Malcom, Sandra, Position, Zipcode
State, moon, wave, potatoes, sick
The best data type to choose for date of birth would be
Number
Text
Date/Time
Currency
A ‘required field’ is a form of
Validation
Verification
Data Entry
Data Output
