WorksheetsAccess Tables Forms and Queries
Total questions: 20
Worksheet time: 10mins
A ____________ is a unique identifier for a record in the table.
line item
data type
primary key
property field
The _____________ defines the type of data stored in a field.
query grid
field name
record type
data type
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
In a database, all the information about one person or thing is called a
Worksheet
Presentation
Record
File
This is specified as a condition in a query.
option
data type
criteria
From which tab we can generate Reports and Queries?
File Tab
Home Tab
Create Tab
Database Tools
We can generate Reports and Queries from:
Tables
Form
Cells
Where are the previous, first, next and last record buttons are located?
Title bar
Menu Bar
Navigation Bar
____________ is a user friendly way of entering, editing and viewing the information in the table.
Query
Form
Report
Form object has three views. Form View, Layout view and
________________.
Design View
Edit view
Format View
Any changes made to the tables will be reflected in queries and changes applied to the data in the query are also altered in the table. Is given statement is true or false.
True
False
Which datatype can store both text and numbers
Boolean
Image
Number
Text
In database , we can
Add the record
Delete the record
Amend the record
All the above
Which of the following is an easy way to enter and browse data in a large database?
Forms
Tables
Spreadsheets
Records
We can use (a) to answer, perform calculations and combine data from different tables.
At least one (a) must be common between two tables to create a relationship.
