Font size
WorksheetsAccess-Basic
Total questions: 20
Worksheet time: 10mins
What data will be stored in the database for a patient?
Choose 3 correct answers.
Date of Birth
Last Appointment
Favorite color
Middle_Initial
What type of field is the Agreement length allowed? field?
Lookup
Boolean logical
Numeric
Text
If you click on the shown icon, how many options would be listed about a table?
1
3
2
4
How many queries do you see in database?
5
3
8
Haven't any queries
Identify the primary key from the following
Name
Mark
Telephone
Gender
Collection of fields known as
key field
File
Table
Record
Which datatype can store both text and numbers
Boolean
Image
Number
Text
Alpha numeric is another word often used for a................ data type
Currency
Text
Image
Boolean
Whish datatype is used for yes/no
Text
Memo
Currency
Boolean
Which datatype is suitable for 5VS23G
Date/Time
Boolean
Memo
Text
Which datatype would be the best choice to store" have you passed your driving test.
Boolean
Text
Numeric
Date
Uniquely identifying a record is
Foreign Key
Primary Key
Key
All the above
In database , we can
Add the record
Delete the record
Amend the record
All the above
A sports club needs to store information about each member. The individual information about each member is called a:
Field
File
Record
Table
A gym has a database with all their members they want to include email addresses in the database, what will they do?
Add a record
Add a field
Edit a record
Change a field name
A health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' query criteria?
>3
<3
>=3
<=3
The school wants to sort the data by alphabetical order in Surname. How will they sort it?
Ascending order
Descending order
A telephone book is a good example of a database
True
False
What are the 4 main objects in a database?
Tables, Forms, Reports, Keys
Spell Check, Grammar, Ruler, Tools
Tables, Queries, Forms, Reports
Cells, Columns, Rows, Sheet
How many records are in this database?
5
8
9
10
