Font size
WorksheetsQueries, Forms And Reports
Total questions: 20
Worksheet time: 11mins
In a database, a "form" allows you to...
Create a query
Enter data and edit it in a simple form that consists of the fields from a table
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
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
Which of the following is an easy way to enter and browse data in a large database?
Forms
Tables
Spreadsheets
Records
While you can always enter data directly into database tables, you might find it easier to use ________.
queries
tables
forms
Which of the following would you use to display the data from a query in a professional format?
Table
Form
Query
Report
You can create reports in Access Database in order to format data in user friendly way
True
False
In a TABLE, a column is known as a...
Record
Field
Row
Data
In a TABLE, a row is known as a...
Information
Column
Data
Record
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
In a database, all the information about one person or thing is called a
Worksheet
Presentation
Record
File
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
(a) must be common between two tables to create a relationship.
We can use (a) to answer, perform calculations, combine data from different tables, add, modify or delete data.
What is a foreign key?
A FOREIGN KEY is a field in one table that matches the PRIMARY KEY in another table.
A foreign key is a field in a table that uniquely defines every record uniquely
