Intro to Microsoft Access
Save
Edit
Host a game
Live GameLive
Homework
Solo Practice
Practice
25 QuestionsShow answers
  • Question 1
    30 seconds
    Q.

    A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?

    answer choices

    Database

    Database Management Software

    Data Integrity

    Forms

  • Question 2
    30 seconds
    Q.

    A database contains a Customer table. What would be stored in a record of the Customer table?

    answer choices

    Information about one customer

    Information about all the customers

    Information about one order

    Information about every order

  • Question 3
    30 seconds
    Q.

    Is it OK to have a database of unrelated data?

    answer choices

    Yes

    No

  • Question 4
    30 seconds
    Q.

    Why does data inside a database need to be organized?

    answer choices

    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

  • Question 5
    30 seconds
    Q.

    A store tracks customers and their orders in a database. Which table would NOT be part of this database?

    answer choices

    Customers table

    Orders table

    Reviews table

    Inventory table

  • Question 6
    30 seconds
    Q.

    A store tracks customers and their orders in a database. What can be created to store this collection of related data?

    answer choices

    Database Management System

    Database

    Table

    Record

  • Question 7
    30 seconds
    Q.

    You discover many errors in a database table. What has been lost?

    answer choices

    Data Integrity

    Database Management System

    Fields and Records

    Primary Key

  • Question 8
    30 seconds
    Q.

    Which of the following is an easy way to enter and browse data in a large database?

    answer choices

    Forms

    Tables

    Spreadsheets

    Records

  • Question 9
    30 seconds
    Q.

    What is a database?

    answer choices

    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.

  • Question 10
    30 seconds
    Q.

    What is a database table?

    answer choices

    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.

  • Question 11
    30 seconds
    Q.

    What is a database record?

    answer choices

    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.

  • Question 12
    30 seconds
    Q.

    4. What is a database field?

    answer choices

    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.

  • Question 13
    30 seconds
    Q.

    What is a database form?

    answer choices

    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.

  • Question 14
    30 seconds
    Q.

    What is data integrity?

    answer choices

    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.

  • Question 15
    30 seconds
    Q.

    What tools does Access have to help manage large amounts of data?

    answer choices

    Foreign key

    Sorting and filtering

    A relationship

    Report Design View

  • Question 16
    30 seconds
    Q.

    What is ascending order?

    answer choices

    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

  • Question 17
    30 seconds
    Q.

    What is descending order?

    answer choices

    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.

  • Question 18
    30 seconds
    Q.

    What is filtering?

    answer choices

    To find a specific item in the table.

    A relationship

    Changing which records are displayed on the screen.

    Sorting

  • Question 19
    30 seconds
    Q.

    What view should you use to adjust and format a report?

    answer choices

    Print Preview

    Report Design View

  • Question 20
    30 seconds
    Q.

    A primary key field from one table appears in a second table. What is the field in the second table called?

    answer choices

    A primary key

    A foreign key

    A relationship key

    A linked key

  • Question 21
    30 seconds
    Q.

    Does Microsoft Access need to be told about relationships between tables?

    answer choices

    No, relationships are automatically detected

    No, relationships are not supported

    Yes, relationships need to be defined.

    Yes, only when the fields have different names.

  • Question 22
    30 seconds
    Q.

    You cannot change the order of fields on a report.

    answer choices

    True

    False

  • Question 23
    30 seconds
    Q.

    A query for a report can come from multiple tables.

    answer choices

    True

    False

  • Question 24
    30 seconds
    Q.

    Filters can be used on query results.

    answer choices

    True

    False

  • Question 25
    30 seconds
    Q.

    Queries can only use data from one table at a time.

    answer choices

    True

    False

Report Quiz
Join a game