SMS515 - Systems Studies IV
This paper deals with the system studies in which the students would gain the skills and knowledge of contemporary and important day-to-day office productivity tools used in businesses including Microsoft Excel and Microsoft Access. You are required to emphasise on the following key aspects:
The detailed comprehension of MS Excel such as creating, sorting, editing query tables
How to create a worksheet group and operate with multiple worksheets & workbook simultaneously
How to combine information from multiple worksheets and workbooks
The use of MS Excel to perform different functions like queries, forms and reports
The application of logical and physical database methodologies in design and build phases of a relational database
The implementation of professional database methodologies to perform requirement analysis
The development of query by example statements
The introduction and application of process modeling in an accounting information system
Systems Studies IV
This is the last of the Systems subjects in the ACF program. This course will employ important day-to-day office productivity tools used in businesses at present. Focusing on Database and Spreadsheeting, students will develop advanced skills in Microsoft Excel and Microsoft Access. Along with advanced spread sheeting techniques, and good analytical methodologies, emphasis will be placed on error detection and error prevention in model building. Students gain experience integrating real business needs using Microsoft Access. In-class team assignments and hands-on projects include requirement analysis, entity relationship diagrams, relational tables, Structured Query Language, and database administration.
This subject is a required subject in the Accounting and Finance Diploma program.
Upon successful completion of this subject the student will be able to:
1.Use MS Excel to:
a) Create, sort, edit and query tables
b) Create a worksheet group and work with multiple worksheets & workbook at the same time
c) Consolidate information from multiple worksheets and workbooks.
d) Summarize data using pivot tables, pivot charts, IF, COUNTIF, SUMIF, AVERAGEIF and database functions
e) Create formulas using logical functions to solve problems
f) Create lookup tables and apply the lookup function
g) Add validation and other rules to improve data integrity
h) Create and edit macros
i) Create variable data tables and scenarios
j) Solve complex business problems using the Solver feature
k) Import data from several sources*
l) Interpret results.
m) Explain concepts covered and discuss their application in a business environment.
2. Use MS Access to:
a) Create tabkesm queries, forms and reports
b) Integrate with the Web and other programs*
c) Design macros to automate tasks
d) Explain and apply database management and security
3. Explain the logical and physical database methodologies used in the design and build phases of a relational database.
4. Apply professional database methodologies to perform requirement analysis, and construct an operational database using MS Access.
5. Build query by example statements to retrieve data necessary to make effective decisions.
6. Discuss and apply process modeling in an accounting information system
100% Plagiarism Free & Custom Written,
Tailored to your instructions