1 / 10

Miscellaneous Topics

This guide delves into the concepts of scenarios in Microsoft Excel, which are powerful tools for what-if analysis, allowing users to save and substitute groups of values for forecasting outcomes in worksheets. It explains the creation of scenarios through the Tools menu, helping to visualize different results effortlessly. Additionally, we explore database applications, their components, and categories, highlighting their importance in managing data. The application of Microsoft Access as a prototyping tool and its integration with other systems is also discussed.

amora
Télécharger la présentation

Miscellaneous Topics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Miscellaneous Topics ISYS 363

  2. Scenario • Scenarios are part of a suite of commands sometimes called what-if-analysis tools. A scenario is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.

  3. Creating a Scenario • Tools/Scenarios • Add scenario • Changing cells • Resulting cells • Demo: benefit.xls

  4. Database Application • Database application is a program that interacts with the database at some point in its execution. • It consists of an organized set of menus, forms, reports, business rules, and the database it operates on.

  5. The three components in a database application 1. Presentation – user interface • Menus, forms, reports, etc 2. Processing logic • Business rules 3. Database

  6. Categories of Database Applications • One-Tier • Legacy online transaction processing • PC database application • Two-Tier client/server • Client-based presentation. • Processing logic is buried either inside the user interface on the client or within the database on the server, or both.

  7. Access’s Role • One-tier PC database application • As a server of a two-tier client/server database application • Windows-based or web-based system • As a client of a client/server system. • As a prototyping tool in developing new system • Rapid application development tool

  8. Access Integrated with Other Systems ADO/SQL Other data sources Access Database Excel/ Decision Support

  9. Rapid Application Development Tools • Wizards: • Form wizards • Switchboard form • Database form • Control wizards • Macro

  10. Do you blogging? • What is a blog? • Blogger.com

More Related