Chapter 1 - Microsoft Access And MIS

39 Questions | Total Attempts: 210

SettingsSettingsSettings
Please wait...
Microsoft Access Quizzes & Trivia

Microsoft access is mostly used by small businesses to create applications on their computers for data applications. This product has been known to help the user analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheets and the application helps to keep and manage databases. Have you chapter one on Microsoft access and MIS course? Take the review test below and see what you recall.


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. 
    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

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

      Forms

    • B. 

      Relationships

    • C. 

      Tables

    • D. 

      Reports

    • E. 

      Spreadsheets

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

      True

    • B. 

      False

  • 10. 
    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

  • 11. 
    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

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

      Datasheet

    • B. 

      Design view

  • 13. 
    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

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

      Collect

    • B. 

      Process

    • C. 

      Store

    • D. 

      Distribute information

    • E. 

      Soft skills

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

      True

    • B. 

      False

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

      True

    • B. 

      False

  • 17. 
    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

  • 18. 
    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

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

      Operational Management

    • B. 

      Executive Management

    • C. 

      CEO

    • D. 

      Nonmanagement Employees

    • E. 

      President Obama

  • 20. 
    (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.

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

      Argument

    • B. 

      Relevance

    • C. 

      Meaningful format

    • D. 

      Accessible

    • E. 

      Timely

  • 22. 
    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

  • 23. 
    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

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

      True

    • B. 

      False

  • 25. 
    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

  • 26. 
    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

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

      CIO

    • B. 

      System design

    • C. 

      Software design

    • D. 

      Database and internet

    • E. 

      Electrician

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

      Forms

    • B. 

      Tables

    • C. 

      Queries

    • D. 

      Information

    • E. 

      Report

  • 30. 
    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.

  • 31. 
    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

  • 32. 
    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

  • 33. 
    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

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

      True

    • B. 

      False.

  • 35. 
    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

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

      Forms

    • B. 

      Reports

    • C. 

      Queries

    • D. 

      Tables

    • E. 

      B and C

  • 37. 
    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

  • 38. 
    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

  • 39. 
    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