WorksheetsDBMS Quiz No. 1
Total questions: 30
Worksheet time: 7mins
True or False: In order to save changes to a database, you must save the objects individually.
True
False
Sets of related data.
Tables
Forms
Queries
Reports
User-friendly interfaces for entering and viewing data.
Tables
Forms
Queries
Reports
Data resulting from questions you ask of one or more tables.
Tables
Forms
Queries
Reports
Formatted summaries of data suitable for printing
Tables
Forms
Queries
Reports
You want to use the table below to find which orders were specifically placed for a party. Which of the following should you do?
Use a text filter on the Notes field
Use a number filter on the Notes field
Sort the table
Create a report
Which of the following are advantages of using Access over Excel? Check all that apply.
Access handles numerical data better than Excel
Access handles non-numerical data better than Excel
Access uses PivotTable to summarize data
Access is a relational database, which makes it easier to find connections in your data
Suppose you created the following query, but later you realize that you really wanted to find the total number of cakes sold instead of cookies. What is the best way to solve this problem?
Use the find feature to search for Cake
Switch to design view and edit the criteria
Delete the query and re-create it
Use a filter on the Product type field
The following table has more than 100 records. You want to change all instances of the phrase "half-dozen" to "baker's dozen." What's the fastest way to do this?
Re-type the records
Use the Find and Replace feature
Sort the Sales Unit field, scroll to Half-dozen, then use copy and paste
Apply a filter to the Sales Unit field, then retype the records
What does the following image show?
Using a form to create a record
Using a table to create a report
Creating a query
Using a form to calculate a field
Why would you want to create a report?
Report allow you to present tables and query result in an easy-to-read format
Reports make it easy to add records to a table
Reports allow you to export a table as an excel file
Reports are used to add data collection fields to form
Let's say you've created a query to find only customers who have placed orders. But when you run the query below, it returns both customers who have and haven't placed orders. What could you do to fix this?
Apply an ascending sort to the Customer ID field
Include more fields from the Customers table
Change the table join to right to left instead of left to right
Add another table with a left-to-right join
Let's say our bakery wants to create a list of customer names and email addresses for customers who pre-ordered an item and picked it up during the month of December. The tables needed for the query are shown below. Aside from First Name and Last Name, what fields must be added to the query? Check all that apply.
Pre Order
Pickup Date
Paid
Notes
The following are the file extensions you will use the most when developing Access databases except?
.accdb
.xls
.mdb
.mde
Short Text is any string of text up to _____ characters long.
125
155
225
255
The unique identifier for the table.
Primary Key
Foreign Key
Composite Key
Child Field
A set of simple rules that specifies the format in which data can be entered into a field.
Lookup field
Relationship
Input Mask
Criteria
SQL stands for?
Structured Query Language
System Query Language
Syntax Query Language
Simple Query Language
A situation where multiple tables can contain related data that is linked by a common field
Queries
Relationship
Input Mask
Lookup Field
The parent's field is the _________?
Composite key
Primary key
Foreign key
None of the above
It will ensure that child records cannot reference a non-existent parent.
Data Integrity
Enforce Referential Integrity
Relationship
Queries
The following are the types of relationship except?
One-to-One
Many-to-Many
One-to-Many
One-to-Two
A table that contains data that is referenced by another table.
Lookup table
Relationship table
Input Mask table
Database table
A software tool that allow people to store, access and process data or facts into useful information.
File Maintenance
Record
Database Management System
Datbase
Data is organized in layers such as the following except?
File
Record
Field
Character
Database
It specifies the kind of data a field can contain and how the field is used.
Data type
Primary key
Field name
Properties
A group of related fields.
File
Record
Character
Field
It refers to the procedures that keep data current.
File maintenance
Garbage In Garbage Out (GIGO)
Hierarchy of Data
DBMS
It defines the maximum number of characters a field can contain.
Field name
Field size
Character size
Primary key
It points out the accuracy of a computer’s output depends on the accuracy of the input.
Data integrity
Relationship
File Maintenace
Garbage In, Garbage Out (GIGO)
