NEW
Font size
WorksheetsBTT - Database
Total questions: 38
Worksheet time: 37mins
What is a database?
Organized collection of information that cannot be accessed, updated, and managed
Collection of data or information without organizing
Organized collection of data or information that can be accessed, updated, and managed
Organized collection of data that cannot be updated
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
1. Data software for working with the database
DB
DBMS
BZ
Tables in databases are designed to:
to store database data
for the selection and processing of database data
to enter database data and view them
to automatically execute a group of commands
What program can we use to create a database?
DBMS is...
database management systems
data block management systems
complex management databases
Main database objects?
tables
queries
forms
reports
word
number
picture
image
table
data
These are key objects in a database. They contain the data that is stored in the database and are made up of rows and columns.
Table
Report
Query
Form
A request for data results from a database or for action on the data.
query
table
file
record
A database object that you can use to create a user interface for a database application.
form
report
record
field
This can offer a way to view, format, and summarize the information in your Microsoft Access database.
query
table
form
report
record
A group of fields, such as a telephone number, address and name, which are pertinent to a particular item. These are also known as rows.
query
field
report
records
A piece of information related to a single person or thing; also known sometimes as columns.
table
query
form
field
A field or set of fields with values that are unique throughout a table.
primary key
foreign key
database
record
The properties of a field describe the characteristics and behavior of data added to that field.
database
data type
field
record
An organized collection of structured information, or data, typically stored electronically in a computer system.
database
record
primary key
foreign key
In a database, the rows are also known as
fields
records
tables
forms
A table is divided into __________________
field and form
fields and records
datasheet and design
record and form
In Microsoft Access, a field labelled “Price” must be created as
Currency
Primary Key
Number
Short Text
Microsoft Excel uses columns while Microsoft Access uses _________
Fields
Records
Tables
Movement
Records in a table can be updated any time.
True
False
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
How would you define a Query?
Created to see tables better
Allow you to retrieve data from tables
The wizard allows you to go step by step
Why are reports created in access databases?
They are produced to analyse and print queries or tables for presenting
Just to print
To collect more information
What is a database form?
A column in a table that stores a piece of data for a record.
Stores information about one specific kind of item in a database.
Forms are a way to view and browse information in a database.
An organized collection of related data.
Does Microsoft Access need to be told about relationships between tables?
No, relationships are automatically detected
No, relationships are not supported
Yes, relationships need to be defined.
Yes, only when the fields have different names.
A query for a report can come from multiple tables.
True
False
It is a database object that allows you to retrieve data from a table, modify it and even store the result in another table.
Entity
Reports
Forms
Queries
What are the two ways Access provides for me to design a query?
Query Layout and Datasheet View
Query wizard and query design
Datasheet Design and Query Wizard
Data Design and Design Wizard
a component of a database, such as a table, query, form, or report
Object
Query
Table
Form
A characteristic of a field that determines what kind of data it can store.
Primary Key
Data Type
Relationship
Table
A column (or combination of columns) to uniquely identify each record in a table.
Record
Relationship
Primary Key
Query
A set of data values in a column of a specific data type.
Field
Report
Record
Object
Sometimes called a row, it is a group of fields within a table specific to one entity.
Object
Field
Record
Query
