WorksheetsUSING TABLES IN MS ACCESS
Total questions: 11
Worksheet time: 6mins
A table is also called a ___________ .
Object
Relation
Records
____________ help you to perform routine tasks by automating them into a single command.
Report
Modules
Macros
It is a collection of information about one person or thing, such as the name, phone number and address of one student.
Record
Table
Field
A ____________ is a field with values that are unique for each record throughout a table.
foreign key
primary key
candidate key
____________ is a label to identify a field in a database.
Record
Field
Field Name
It is a string of characters used to store alphanumeric data.
Short text
Long text
Autonumber
Number
We use the___________ property to customize how the number, date, time and text are to be displayed and printed.
Visual
Format
Caption
The file extension for database in MS Access 2007/2010 is
.acddb
.acdbb
.accdb
________________ is used to define the fields, data types and description of the field.
Datasheet view
Design View
Table view
_____________data lets you hide unimportant data and focus only on the data you're interested in.
Filtering
Sorting
Validation
We use the ____________ Property to provide helpful information to the user through the labels telling about the object
Format
Validation
Caption
