Font size
WorksheetsMicrosoft Access - Grade 11
Total questions: 20
Worksheet time: 29mins
A database is
A group of unrelated files
A collection of related information stored in an organized way
A computer program for drawing
A type of virus
In Microsoft Access, a table is used to
Enter, store, and manage data
Create animations
Design websites
Display pictures
A field is
A single piece of data about a record
A whole collection of records
A database file
A type of form
To create a new database, you would
Open an existing database
Click File -> New
Restart your computer
Install a new version of Windows
Data Type refers to
The format of the database file
The size of the table
The kind of data a field can store
The design of the user interface
The primary key
Allows duplicate values
Uniquely identifies each record
Is always a text field
Must be a date
Which module allows viewing stored records?
Tables
Queries
Views
All of the above
Which are data types?
Medium Text
Number
Date/Time
Color
Currency
Elements of a database include
Tables
Forms
Queries
Antivirus software
When modifying table structure, you can
Change field names
Add fields
Delete fields
Change data types
Restart your computer
Define database
What is the purpose of a select query?
Why analyze project before creating a table?
What happens if two records use the same primary key?
Give an example of field + data type.
What is a record in a database?
What happens when you enter data that does not match a field’s data type?
A field of "First Name", what should its data type be?
Long Text
Number
Date/Time
Currency
None of the above
A field of "Phone Number" what should its data type be?
Number
Date/Time
Lookup Wizard
Short Text
Which naming convention is correct for fields? (Suppose the field name is for First Name)
first_name
FirstName
firstName
1stName
