Software Applications B1 (MS Access)

30 Questions | Total Attempts: 62

SettingsSettingsSettings
Software Application Quizzes & Trivia

Database Concepts Creating a Database Making Changes to a Database Database Forms Information Retrieval Database Reports Database Printing


Questions and Answers
  • 1. 
    What is a database? 
    • A. 

      A file that stores and organises large amounts of related data.

    • B. 

      An application that allows you to carry out general book-keeping tasks.

    • C. 

      A file that stores your computer’s configuration details.

    • D. 

      A device used to store deleted files.

  • 2. 
    Tables are the basic components of a database in that they store all the information contained in the database. A column in a database is called a__________________. 
    • A. 

      Garden

    • B. 

      Stage

    • C. 

      Field

    • D. 

      Storage

  • 3. 
    Microsoft Access provides different views of tables, queries, forms, and reports. Which view do you use to edit a record in a table? 
    • A. 

      Design view.

    • B. 

      Datasheet view.

    • C. 

      Table view.

    • D. 

      Layout Preview.

  • 4. 
    You can update records in a database at any time. 
    • A. 

      True

    • B. 

      False

  • 5. 
    What is a database index? 
    • A. 

      A list of keywords that indicates the location of files or records.

    • B. 

      A list of keywords that display in your PC’s BIOS.

    • C. 

      A list of keywords that compile when you open a database.

    • D. 

      A list of keywords that display on your desktop.

  • 6. 
    Your database is not made up of tables and records. 
    • A. 

      True

    • B. 

      False

  • 7. 
    When planning a database, which of the following should you determine first? 
    • A. 

      The attributes and properties of each field.

    • B. 

      An appropriate name for the database.

    • C. 

      How many tables to create.

    • D. 

      What fields to create?

  • 8. 
    Access provides three different ways to create a new database table. If you select the “Create table in Design view” option, how will the table be created? 
    • A. 

      A simple table with no fields or attributes will be automatically created.

    • B. 

      A predefined wizard will assign fields names and attributes to the table.

    • C. 

      You will manually enter the name and attributes of each field in the table

    • D. 

      An existing table stored on your computer will be used.

  • 9. 
    Once you have assigned a primary key for a table, you can enter duplicate data in any field of the table. 
    • A. 

      True

    • B. 

      False

  • 10. 
    Why might you want to change the attributes of a field in a database table? 
    • A. 

      To change the order in which fields appear in the table.

    • B. 

      To assign a primary key.

    • C. 

      To set a character limit for that field.

    • D. 

      To change the data in a certain field.

  • 11. 
    How do you select an entire record in a database table in Datasheet view? 
    • A. 

      Click the primary key field for that record.

    • B. 

      Click the grey box to the left of that record.

    • C. 

      Click any field in that record.

    • D. 

      Click and indexed field in that record.

  • 12. 
    Table relationships work by matching data in key fields-usually a field with the same name in both tables. 
    • A. 

      True

    • B. 

      False

  • 13. 
    One-to-one table relationship is the most common database relationship. 
    • A. 

      True

    • B. 

      False

  • 14. 
    Access provides four different layout options database forms. Which layout option displays one record at a time, with each field displayed on a separate line? 
    • A. 

      Tabular.

    • B. 

      Justified.

    • C. 

      Datasheet.

    • D. 

      Columnar.

  • 15. 
    In Design view, you can select a group of controls in a form and modify them collectively. To select more than one control on a form, which key do you need to press? 
    • A. 

      Alt key

    • B. 

      Esc Key

    • C. 

      Shift key

    • D. 

      Ctrl key

  • 16. 
    You need to retrieve and display records in your database based on search criteria. Which of the following do you create? 
    • A. 

      A form.

    • B. 

      A query.

    • C. 

      A report

    • D. 

      A macro.

  • 17. 
    Once created, you cannot add additional fields to a query. 
    • A. 

      True

    • B. 

      False

  • 18. 
    Which one of the following is a common operator used to select specific data in a sort? 
    • A. 

      Less than or equal to.

    • B. 

      If.

    • C. 

      @.

    • D. 

      Including.

  • 19. 
    What is the function of a database report? 
    • A. 

      To display database records on a document in a logical and effective manner.

    • B. 

      To display a list of the different queries in a database.

    • C. 

      To display the different fields in a database and their attributes.

    • D. 

      To list the changes made to a database since it was originally created.

  • 20. 
    You are creating a report and have selected the Landscape option. How will this affect the presentation of your report? 
    • A. 

      It will be presented vertically.

    • B. 

      It will be presented horizontally

    • C. 

      It will be presented with graphics.

    • D. 

      It will be printed on a larger paper size.

  • 21. 
    Which toolbar do you use to add a control, such as a label, to your report? 
    • A. 

      Formatting (Datasheet)

    • B. 

      Formatting (Form/Report)

    • C. 

      Toolbox

    • D. 

      Task Pane

  • 22. 
    It is possible to print database tables, reports and queries, but it is not possible to print an entire datasheet. 
    • A. 

      True

    • B. 

      False

  • 23. 
    Before printing your database information, it is not possible to preview your work in Microsoft Access. You need to do this in Microsoft Word. 
    • A. 

      True

    • B. 

      False

  • 24. 
    What happens when you apply a filter to a database query? 
    • A. 

      Only the query results that meet certain additional criteria are displayed

    • B. 

      All query results are displayed

    • C. 

      The query can only search specific tables in the database.

    • D. 

      A new query is created to display the new results.

  • 25. 
    Your form is displayed on a grid. Which view are you using? 
    • A. 

      Design view.

    • B. 

      Form view.

    • C. 

      Datasheets view.

    • D. 

      Normal view.

Back to Top Back to top