NEW
Font size
WorksheetsCSEC IT - 03 DATABASE
Total questions: 50
Worksheet time: 50mins
What is database?
Collection of organized data that allows access, retrieval of that data.
A storage bin in which data is kept for any type of usage
Collection of organized data that allows access, retrieval, and use of that data.
Collection of organized data that allows retrieval, and use of that data.
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
Query
Report
Database
Spreadsheet
Microsoft's version of a Database Management System
Excel
Access
Word
PowerPoint
A Primary Key is a code that uniquely identifies
a _____________ in a Database.
Record
Field
Text
Number
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
Cell
Field
Column
Record
The restrictions or conditions applied on data are known as ______________
Constraints
Key word
Scheme
Term
n a database table, rows are called __________
Fields
Records
Primary Keys
Foreign Keys
What is refined data
Knowledge
Information
Statistics
None
How many records are shown here?
5
7
11
35
How many fields are shown here?
5
7
11
35
When Using Paper Manual Database
Paper Files Can get lost
You can easily Find the file you are looking for
you can easily sort file alphabetically
you can make easily make changes
An advantage of a computerized database is that
You can query it and obtain specific data that is relevant to your requirements
You can enter lots and lots of data and never run out of space
Anybody can access the data and use it
It's easy to use and you never need to worry about it again
Primary key is
A field that uniquely identifies each field in a file.
A field that uniquely identifies each record in a file.
A record that uniquely identifies each record in a file.
A record that uniquely identifies each field in a file.
Juan needs to create a database of all his friends. In a table, what is all the information about one friend considered?
Field
Record
Table
Entry
Robert needs to create a database of all his friends. In a table,
what is the last name considered?
Field
Record
Table
Entry
Repetition of data is called data ..............
dependence
redundancy
inconsistency
isolation
What objects can we import into MS-Access?
Tables, fields, records, and forms
Tables, queries, reports, and forms
Fields, queries, texts and forms
Parameters, Queries, Reports, and Records
Steps to import a text file into MS-Access are:
External - Link - From File - Text File - Import Wizard
External Data - Import and Link - From File - Text File - Import Wizard
External Data - Import and Export - From File - Text File - Export Wizard
External Data - Import - From File - HTML File - Import Wizard
It is that table that is in a different database but acts as if it were in our database.
Related table
Indexed table
Linked table
File table
What is the name of the command that allows me to update the location of linked tables in a database in MS-Access?
Show linked tables
Linked tables manager
Import linked table
None of the above
It is the sending of the information from our database to another database or to a file of another type.
Import
Link
Export
None of the above
What are the steps to export data from MS-Access to another application?
External Data - Import - Choose Application - Import Wizard
Data - Export - Choose Application - Import Wizard
External Data - Export - Choose Application - Export Wizard
External data - Export - Choose application - Import wizard
It is the association between two tables through a common field also known as a key or primary key.
Control
Management
Relationship
Entity
n the following figure, identify what type of relationship it is:
Many to many
One to one
one to many
None of the above
type of relationship that is the most common in a database, a table or a record found in it, it can be linked to many other records in another table or tables.
One to many
One to one
Many to many
None of the above
It is a relationship that occurs when many records in a table are linked to several records in another or other tables.
One to many
One to one
Many to many
None of the above
These are some of the activities that we can
perform in a table in the datasheet view
Search - Sort - Filter
Sort - Filter - Format
Search - Clear - Filter
Add - Clear - Format
What types of ordering can we do to the records within the datasheet view?
Ascending and Selection
Ascending and Descending
Selection and Advanced
Descending and Advanced
One of the options to be able to filter the information when choosing the information from the table.
By filter
Selection
Advanced
Form
What are the options for filtering within tables in MS-Access?
Selection, Text Filter, Form and Advanced
Selection, Filter, Report and Advanced
Selection, Filter, Form and Advanced
Selection, Report, Form and Advanced
Window where the tables of a Database that are going to be related and show said link ordered between them are presented.
Design Window
Relationships Window
Query Grid
Datasheet View
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
Types of queries with which we can extract and
display data when certain criteria are met.
Action
Selection
Upgrade
Elimination
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
What does this image show
creating tables
creating queries
creating reports
creating fields
It is an element within the grid grid as it will be useful for
defining queries based on multiple tables.
Order
Show
Criteria
Tables
inside the grid, it is used to specify a search, it is a condition that the records that will appear in the result must meet.
Criteria
Order
Show
Field
Element that works similar to a table field, but the value it stores is entered by the user when the query is run.
Criteria
Parameters
Totaled
Search
When creating a query with parameters, when placing the name of the parameter it is important to place it in:
Parenthesis
Quotation marks
Brackets
Apostrophes
When we want to classify a query it is necessary that more than one of the fields is organized. this type of classification is called:
Criterion
Aggregation
Multilevel
Selection
Q.
It is an expression that Access compares with query field values to determine whether to include the record that contains each value.
Parameter
Criterion
Indexed
Search
Object used to define a screen for editing the records of a table or query.
Form
Reports
Entity
Consultation
Steps to create a report or report in MS-Access.
Create - Reports - Report Wizard - Table or Object Selection - Fields - Add Levels - Sort - Report Name - Finish
Create - Forms - Form Wizard - Table or Object Selection - Fields - Add Levels - Sort - Report Name - Finish
Create - Forms - Form Wizard - Table or Object Selection - Fields - Add Levels - Sort - Report Name - Finish
None of the above
What is the primary key in this database?
MIDDLE NAME
GIVEN NAME
SURNAME
Employee ID
All of the ablove
"In a college database, each department that need the students' information accesses it from the same set of data."
This statement is referring to __________________ concept.
data integrity
data redundancy
normalization
data centralization
Two students take the same course, but two different
course names appear in a database that refers to the same course.
This mistake is known as ______________.
data integrity
data redundancy
data inconsistency
data centralization
What are the two views that you can use when putting data in Access?
Datasheet View and Design View
Column View and Row View
Field View and Record View
Row View and Field View
What is data integrity
It is the data contained in database that is not redundant
It is the data contained in database that is accurate and consistant
It is the data contained in database that is secured
It is the data contained in database that is shared
Forms, queries, and reports are created based on the data in the _________
Forms
Tables
Reports
Spreadsheets
Which data type would be most suitable for the 'Age' field?
Currency
Date & Time
Number
Memo
