Reference no: EM132417761

ISE 2034 Data Management for IEs

1. Many factors, such as type of data, must be considered in developing an effective data management application.  List and briefly describe (1 sentence each)threeother factors that should be considered.

2. (a)  What are the two components of database systems?  Briefly define the role of each.

(b) What is the main difference between the database approach and file-based methods, in terms of how data is modeled and stored?

3. What is a manual filing system?  How is the data structured?  Are such systems still in use today?  List two reasons why or why not.

4. List two advantages of file-based systems, such as Excel, over manual filing systems.

5. If you are recording an Excel macro to ensure users cannot select or update a group of cells on a worksheet, what steps are necessary?  Assume the worksheet is currently Protected.

6. In Excel applications, a List Box is generally used to choose between multiple items in a list (e.g. for selecting capacity items in the Anjoca application).  When navigating between worksheets in an Excel workbook, what two form control (user interface control) elementsare most commonly utilized?

7. List, and briefly describe the ways used to test a data management application.