What software do you use to make databases?
  • Access
  • Excel
  • PowerPoint
  • Word
Which of the following is an old method of a database?
  • Address Book
  • Filing Cabinet
  • Fax Machine
  • Typewriter
In your database, information is stored in the ...
  • Table
  • Report
  • Query
  • Form
When working with a database application, what is the function of a wizard?
  • to complete a task for you
  • to guide you through the steps required to complete a task
  • to ensure all default settings are implemented
  • to suggest the most efficient way to complete a task
In a Table, a column is known as a ...
  • Record
  • Garden
  • Field
  • Stage
Records in a table can be updated any time.
  • True
  • False
Which object would you create to share the data from your database with others?
  • Form
  • Report
  • Query
  • Table
One example of a database would be ...
  • grocery list
  • stamp collection
  • movie collection
  • cell phone contact list
Access offers different views of objects. Which view do you use to edit a table?
  • Datasheet View
  • Design View
  • Table View
  • Print View
In a Table, a row is known as a ...
  • File
  • Field
  • Record
  • Stage
The best way to edit and update your data is in a ...
  • Report
  • Form
  • Query
  • Table
An organized collection of information about a subject is a ...
  • database
  • table
  • file
  • record
These store information in records and fields.
  • Tables
  • Forms
  • Queries
  • Reports
These provide printable views of table or query data that you can share.
  • Tables
  • Forms
  • Queries
  • Reports
Of the 4 Database Objects, which one does NOT include a wizard?
  • Tables
  • Forms
  • Queries
  • Reports
These provide data entry and lookup.
  • Tables
  • Forms
  • Queries
  • Reports
The most common way to look at a table in Access is ...
  • Datasheet View
  • Design View
  • Table View
  • Print View
These sort, filter, and summarize data.
  • Tables
  • Forms
  • Queries
  • Reports
Multiple tables that are related to each other is known as ...
  • Access Database
  • Relational Database
  • Database Tables
  • Informational Database
In Access, you can also share data with ...
  • your teachers.
  • your classmates.
  • Word and PowerPoint.
  • Word and Excel.
A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?
  • Database
  • Database Management Software
  • Data Integrity
  • Forms
A database contains a Customer table. What would be stored in a record of the Customer table?
  • Information about one customer
  • Information about all the customers
  • Information about one order
  • Information about every order
Is it OK to have a database of unrelated data?
  • Yes
  • No
Why does data inside a database need to be organized?
  • So the data is neat and tidy
  • So data integrity can be maintained
  • So the data can be searched from the Internet
  • So the data can be found when needed
A store tracks customers and their orders in a database. Which table would NOT be part of this database?
  • Customers table
  • Orders table
  • Reviews table
  • Inventory table
A store tracks customers and their orders in a database. What can be created to store this collection of related data?
  • Database Management System
  • Database
  • Table
  • Record
You discover many errors in a database table. What has been lost?
  • Data Integrity
  • Database Management System
  • Fields and Records
  • Primary Key
Which of the following is an easy way to enter and browse data in a large database?
  • Forms
  • Tables
  • Spreadsheets
  • Records
What is a database?
  • An organized collection of related data.
  • A record that stores all the information for one item in a table.
  • A table that stores information about one specific kind of item in a database.
  • A column in a table that stores a piece of data for a record.
What is a database table?
  • An organized collection of related data.
  • A column in a table that stores a piece of data for a record.
  • Stores all the information for one item in a table.
  • Stores information about one specific kind of item in a database.
What is a database record?
  • Stores information about one specific kind of item in a database.
  • Stores all the information for one item in a table.
  • An organized collection of related data.
  • A column in a table that stores a piece of data for a record.
What is a database field?
  • Stores all the information for one item in a table.
  • Stores information about one specific kind of item in a database.
  • An organized collection of related data.
  • A column in a table that stores a piece of data for a record.
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.
What is data integrity?
  • Maintaining and assuring accuracy and consistency of data in a database.
  • Stores all the information for one item in a table.
  • Stores information about one specific kind of item in a database.
  • Forms are a way to view and browse information in a database.
What tools does Access have to help manage large amounts of data?
  • Foreign key
  • Sorting and filtering
  • A relationship
  • Report Design View
What is ascending order?
  • Moving down the alphabet from Z to A.
  • To find a specific item in the table.
  • Moving up the alphabet from A to Z
  • sorting
What is descending order?
  • Moving up the alphabet from A to Z.
  • Sorting
  • To find a specific item in the table.
  • Moving down the alphabet from Z to A.
What is filtering?
  • To find a specific item in the table.
  • A relationship
  • Changing which records are displayed on the screen.
  • Sorting
What view should you use to adjust and format a report?
  • Print Preview
  • Report Design View
A primary key field from one table appears in a second table. What is the field in the second table called?
  • A primary key
  • A foreign key
  • A relationship key
  • A linked key
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.
You cannot change the order of fields on a report.
  • True
  • False
A query for a report can come from multiple tables.
  • True
  • False
Filters can be used on query results.
  • True
  • False
Queries can only use data from one table at a time.
  • True
  • False
0:0:1



Answered

Not Answered

Not Visited
Correct : 0
Incorrect : 0