Have an account?
Skip to Content
Build your own quiz
Suggestions for you
50 questions
Show Answers
See Preview
- 1. Multiple Choice
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.
- 2. Multiple Choice
A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.
Query
Report
Database
Spreadsheet
- 3. Multiple Choice
Microsoft's version of a Database Management System
Excel
Access
Word
PowerPoint
- 4. Multiple Choice
A Primary Key is a code that uniquely identifies
a _____________ in a Database.
Record
Field
Text
Number
- 5. Multiple Choice
Tables are set up to contain columns and rows of information. In a database table, the columns are called __________.
Cell
Field
Column
Record
- 6. Multiple Choice
The restrictions or conditions applied on data are known as ______________
Constraints
Key word
Scheme
Term
- 7. Multiple Choice
n a database table, rows are called __________
Fields
Records
Primary Keys
Foreign Keys
- 8. Multiple Choice
What is refined data
Knowledge
Information
Statistics
None
- 9. Multiple Choice
How many records are shown here?
5
7
11
35
- 10. Multiple Choice
How many fields are shown here?
5
7
11
35
- 11. Multiple Choice
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
- 12. Multiple Choice
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
- 13. Multiple Choice
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.
- 14. Multiple Choice
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
- 15. Multiple Choice
Robert needs to create a database of all his friends. In a table,
what is the last name considered?
Field
Record
Table
Entry
- 16. Multiple Choice
Repetition of data is called data ..............
dependence
redundancy
inconsistency
isolation
- 17. Multiple Choice
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
- 18. Multiple Choice
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
- 19. Multiple Choice
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
- 20. Multiple Choice
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
- 21. Multiple Choice
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
- 22. Multiple Choice
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
- 23. Multiple Choice
It is the association between two tables through a common field also known as a key or primary key.
Control
Management
Relationship
Entity
- 24. Multiple Choice
n the following figure, identify what type of relationship it is:
Many to many
One to one
one to many
None of the above
- 25. Multiple Choice
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
- 26. Multiple Choice
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
- 27. Multiple Choice
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
- 28. Multiple Choice
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
- 29. Multiple Choice
One of the options to be able to filter the information when choosing the information from the table.
By filter
Selection
Advanced
Form
- 30. Multiple Choice
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
- 31. Multiple Choice
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
- 32. Multiple Choice
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
- 33. Multiple Choice
Types of queries with which we can extract and
display data when certain criteria are met.
Action
Selection
Upgrade
Elimination
- 34. Multiple Choice
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
- 35. Multiple Choice
What does this image show
creating tables
creating queries
creating reports
creating fields
- 36. Multiple Choice
It is an element within the grid grid as it will be useful for
defining queries based on multiple tables.
Order
Show
Criteria
Tables
- 37. Multiple Choice
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
- 38. Multiple Choice
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
- 39. Multiple Choice
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
- 40. Multiple Choice
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
- 41. Multiple Choice
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
- 42. Multiple Choice
Object used to define a screen for editing the records of a table or query.
Form
Reports
Entity
Consultation
- 43. Multiple Choice
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
- 44. Multiple Choice
What is the primary key in this database?
MIDDLE NAME
GIVEN NAME
SURNAME
Employee ID
All of the ablove
- 45. Multiple Choice
"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
- 46. Multiple Choice
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
- 47. Multiple Choice
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
- 48. Multiple Choice
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
- 49. Multiple Choice
Forms, queries, and reports are created based on the data in the _________
Forms
Tables
Reports
Spreadsheets
- 50. Multiple Choice
Which data type would be most suitable for the 'Age' field?
Currency
Date & Time
Number
Memo
- Answer choicesTagsAnswer choicesTags