Take Another Quiz

Chapter 1 - Microsoft Access And MIS

42 Questions
Microsoft Access Quizzes & Trivia

Microsoft Access and MIS Chapter 1

Questions and Answers
  • 1. 
    Which of the following is not a database object?
    • A. 

      Design view

    • B. 

      Tables

    • C. 

      Queries

    • D. 

      Forms

    • E. 

      Reports

  • 2. 
    The best way to remember is to see and hear the information.
    • A. 

      True

    • B. 

      False

  • 3. 
    Which of the following is not a typical description of a database?
    • A. 

      Store all kinds of data

    • B. 

      Are always high tech

    • C. 

      Are highly structured and organized

    • D. 

      Somewhat analogous to multiple spreadsheets linked together

    • E. 

      Designed to allow easy extraction and use of stored data

  • 4. 
    Which of the following would represent the order of database concepts from narrowest to broadest?
    • A. 

      1)Fields 2)Tables 3)Records 4)Database

    • B. 

      1)Database 2)Table 3)Records 4)Information

    • C. 

      1)Table 2)Form 3)Records 4)Database

    • D. 

      1)Fields 2)Records 3)Table 4)Database

    • E. 

      1)Fields 2)Tables 3)Records 4)Database

  • 5. 
    How are fields and records displayed?
    • A. 

      Fields-Columns Records-Rows

    • B. 

      Fields-Horizontal Records-Vertical

    • C. 

      Fields-Design View Records-Database

    • D. 

      Fields-Rows Records-Colums

  • 6. 
    What type of file does Microsoft Access 2007 save under?
    • A. 

      .exe

    • B. 

      .aacdb

    • C. 

      .html

    • D. 

      .doc

    • E. 

      None of the above

  • 7. 
    What are the characteristics of a "table" in Microsoft Access?
    • A. 

      Store the data in a database - even better than a spreadsheet, datasheet view vs. design view, has field properties: input masks, validation rules, data type, format, primary key, etc.

    • B. 

      Allow you to ask questions

    • C. 

      Allow you to design various functions to bring in revenue, data, and to store information for operational managers

    • D. 

      Send information to forms and is the key most important aspect of all Access* functions

    • E. 

      Tables do not exist in Access

  • 8. 
    Queries allow you to ask questions about data in the database to extract information.
    • A. 

      True

    • B. 

      False

  • 9. 
    Which form and report view allows you to immediately see the design changes you're making?
    • A. 

      Datasheet

    • B. 

      Design

    • C. 

      Print Preview

    • D. 

      Layout

    • E. 

      Tables

  • 10. 
    -------- are used for entering data, displaying data or for building a menu system.
    • A. 

      Forms

    • B. 

      Relationships

    • C. 

      Tables

    • D. 

      Reports

    • E. 

      Spreadsheets

  • 11. 
    REPORTS in a system dictate what data must be stored in the database
    • A. 

      True

    • B. 

      False

  • 12. 
    Macros are large programs that perform elementary operations.  A special macro named "autorec" will run automatically when the database is opened.
    • A. 

      True

    • B. 

      False

  • 13. 
    The real power of access:
    • A. 

      Is its ability to process and store information

    • B. 

      Is taking data and utilizing generated information for decisions

    • C. 

      Is derived from multiple tables and the relationships between those tables

    • D. 

      Is from the design view

  • 14. 
    Which view is used to add, edit, and delete records in a table?
    • A. 

      Datasheet

    • B. 

      Design view

  • 15. 
    What is the best definition of MIS?
    • A. 

      Management Infrastructures

    • B. 

      Creating technology from business

    • C. 

      Using technology to create business value

    • D. 

      The management of information from data to decision making

  • 16. 
    What is not related to (IS) Information Systems?
    • A. 

      Collect

    • B. 

      Process

    • C. 

      Store

    • D. 

      Distribute information

    • E. 

      Soft skills

  • 17. 
    Data is output, information is input.
    • A. 

      True

    • B. 

      False

  • 18. 
    Once we generate output we apply feedback.
    • A. 

      True

    • B. 

      False

  • 19. 
    Executive Management is where you make strategic decisions. Which of the following is not a typical executive position?
    • A. 

      CEO

    • B. 

      CIO

    • C. 

      President

    • D. 

      Manager

    • E. 

      VP

  • 20. 
    A person who makes tactical decisions. Ex: Director of Public Relations
    • A. 

      Nonmanagement Employee

    • B. 

      Middle Management

    • C. 

      Order Entry Clerk

    • D. 

      Executive Management

    • E. 

      Operational Management

  • 21. 
    Who monitors the firm's daily activities?
    • A. 

      Operational Management

    • B. 

      Executive Management

    • C. 

      CEO

    • D. 

      Nonmanagement Employees

    • E. 

      President Obama

  • 22. 
    (Select the best answer) To make good decisions...
    • A. 

      You must consult with your accountant to verify the your cash flow statement is in balance.

    • B. 

      You must retrieve information to create an output.

    • C. 

      You must retrieve accurate data for processing to be transformed into information for storage and distribution for feedback

    • D. 

      None of the above.

  • 23. 
    Which is not a characteristic of good information?
    • A. 

      Argument

    • B. 

      Relevance

    • C. 

      Meaningful format

    • D. 

      Accessible

    • E. 

      Timely

  • 24. 
    Which of the following is not a functional area of business?
    • A. 

      Sales and Marketing

    • B. 

      Manufacturing/Service

    • C. 

      Finance and Accounting

    • D. 

      Human Resource

    • E. 

      All of the above are functional areas of business

  • 25. 
    The (IS) history timeline would look like this:
    • A. 

      Technical changes-managerial control-vendors, customers- institutional core activities

    • B. 

      Technical changes-vendors,customers-managerial control

    • C. 

      Vendors-core activities-technical changes-managerial control

    • D. 

      Technical changes-managerial control-institutional core activities-vendors, customers, beyond the enterprise

    • E. 

      None of the above

  • 26. 
    Technical skills are more important than soft skills. Analytical skills are a good example of soft skills.
    • A. 

      True

    • B. 

      False

  • 27. 
    Which of the following is not an (IS) oppotunity?
    • A. 

      Improve team collaboration

    • B. 

      Security breaches

    • C. 

      Enhance decision making

    • D. 

      Support corporate strategy

    • E. 

      Rapidly changing technology

  • 28. 
    What is a common challenge in (IS)?
    • A. 

      Too many jobs

    • B. 

      The salaries of IS employees are going down

    • C. 

      The increase in technology is creating robots which replaces human relations

    • D. 

      Things are becoming too easy to build

    • E. 

      None of the above

  • 29. 
    Which of the following is not an (IS) job?
    • A. 

      CIO

    • B. 

      System design

    • C. 

      Software design

    • D. 

      Database and internet

    • E. 

      Electrician

  • 30. 
    A ----- provides a convenient and attractive way to enter, display, and/or print the data in a table.
  • 31. 
    Input is to data as output is to
    • A. 

      Forms

    • B. 

      Tables

    • C. 

      Queries

    • D. 

      Information

    • E. 

      Report

  • 32. 
    When dealing with databases and decision making we start with forms which give data to tables which processes data through queries and the ouput (information) turns into a report that supports decision making.
    • A. 

      True

    • B. 

      False. Queries store information and process the input.

    • C. 

      False. Tables process the information.

  • 33. 
    GIGO stands for:
    • A. 

      Great independence, great organization

    • B. 

      Great Institution Guiding Orders

    • C. 

      Goods in goods out

    • D. 

      Garbage out garbage in

    • E. 

      Garbage in garbage out

  • 34. 
    What is important to the success of (IS) information systems?  Select the best answer.
    • A. 

      Forms

    • B. 

      Reports for information to track data

    • C. 

      Queries for tables

    • D. 

      Database design because if built properly could track Kobe and Shaq's stats.

    • E. 

      GIGO

  • 35. 
    Data should be split into smallest parts:
    • A. 

      True. Birth dates should be tracked by age.

    • B. 

      True. Last name and first name should have separate fields.

    • C. 

      False. Macros should be as large as possible according to network guidelines

    • D. 

      False. The can be small or large

    • E. 

      None of the above

  • 36. 
    You SHOULD use the table wizard.
    • A. 

      True

    • B. 

      False.

  • 37. 
    Which of the following best describes Primary Keys:
    • A. 

      Use an existing field

    • B. 

      Use a combination of fields (concatenated key) i.e. (car make, car model)

    • C. 

      Create a new field using the auto number data type

    • D. 

      MUST be unique

    • E. 

      All of the above

  • 38. 
    Where would you determine GPA?
    • A. 

      Forms

    • B. 

      Reports

    • C. 

      Queries

    • D. 

      Tables

    • E. 

      B and C

  • 39. 
    Which field appears as a check box in a table?
    • A. 

      Text Field

    • B. 

      Number Field

    • C. 

      Yes/No Field

    • D. 

      All of the above

    • E. 

      None of the above

  • 40. 
    A better storage field on the database would be:
    • A. 

      Hyperlink over textfield

    • B. 

      Attachment over subfield

    • C. 

      Currency over field size

    • D. 

      Field size over validation text

    • E. 

      Date of birth over age

  • 41. 
    Which of the following is not a field data type:number, text, memo, date/time, link, currency, yes/no, OLE object, Autonumber, hyperlink, attachment, lookup wizard
    • A. 

      Lookup wizard

    • B. 

      OLE object

    • C. 

      Yes/no

    • D. 

      Currency

    • E. 

      Link

  • 42. 
    Field size, format, validation rule, format, input mask, caption, default value, validation text, required, allow, length, indexed are ALL field properties
    • A. 

      True

    • B. 

      False