MSC312 - Advanced Business Software Applications

Outline info
Last revision date 2018-09-24 01:00:26.799
Last review date 2018-11-05 09:56:45.416

Subject Title
Advanced Business Software Applications

Subject Description
Students will expand their knowledge of relational database management systems as tools for business decision making. They will design and create microcomputer database systems which incorporate more advanced features, and then use the data structures to achieve advanced queries, custom forms and reports, and integration with other software systems.

Credit Status
One full credit.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Perform file management in Windows, and database management tasks in Access.
2. Apply database concepts by creating a document outlining a database's design.
3. Use a Database Management system to:
(a) Create a well-designed database to hold a collection of related data.
(b) Use complex queries to group and summarize data to meet business operational needs.
(c) Create a system of forms for the input and editing of the data.
(d) Effectively present data in printed form, using appropriate layouts and formatting, customized as necessary.
4. Integrate database data with whichever program is best suited for a given business task.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

SMS210 Microcomputer Applications for Business

Topic Outline

  •     Database design
  •     Table relationships
  •     Table design techniques: Lookup fields, Input Masks, Data Validation
  •     Table field properties
  •     Queries using advanced criteria
  •     Crosstab queries
  •     Auditing table data
  •     Custom forms
  •     Custom reports
  •     Basic web pages created from Access data
  •     Integrating Access with Word and/or Excel

Mode of Instruction

A combination of teaching methods will be utilized which may include lectures, case studies, discussions, group and individual work.


This subject is delivered online. This may involve the use of digital materials and/or a text, group discussions, interaction with your instructor and online activities.

Prescribed Texts
Title:  New Perspectives  Microsoft Office 365 & Access 2016: Comprehensive
Edition: 1st
Author: Shellman/Vodnik
Publisher: Cengage Learning
ISBN-13: 9781305880139


Title:  New Perspectives  Microsoft Office 365 & Access 2016: Comprehensive
Edition: 1st
Author: Shellman/Vodnik
Publisher: Cengage Learning
ISBN-13: 9781305880139


Reference Material

Required Supplies
This subject requires MS Office 365 software installed on student's computer - specifically: Word 2016, Access 2016 and Excel 2016.

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online ( or at Seneca's Registrar's Offices.

Modes of Evaluation
Assignments are due on the dates specified. Should extenuating circumstances arise, please contact your instructor prior to the assignment due date so that an appropriate course of action can be established. Late assignments may be subject to a penalty of up to 10% per week and will not generally be accepted beyond two weeks from the due date.

In cases of cheating or plagiarism, the College Academic Policy will prevail. Please ensure that all assignments and reports are properly documented.

Students are referred to the following website for Seneca College Library style guides, Academic Honesty Policy and Copyright guidelines:


Dates for evaluations are specified in the weekly schedule addendum to this outline. The evaluation process may include, but is not limited to, tests, exams, assignments or presentations. Any absences or missed submissions due to medical or other reasons must be supported by medical or other appropriate documentation within one (1) week of the due date. The faculty and program area must be notified immediately in the event of a missed evaluation. Upon acceptance of the documentation, the weighting of the missed deliverable will normally be applied to the final exam.

English Competency

The ability to communicate effectively is essential for success in business. Therefore, you must demonstrate English competency in this subject in both oral and written work. Ensure your written work includes correct sentence structure, spelling and punctuation. Always spell check, edit and proofread your work.

Grading is based on the following marking scheme:


Lab Test 1 25%
Lab Test 2 25%
Final Exam  50 %

Discussion Assignments:  4 @ 5% each 20%
Project 1 20%
Project 2 20%
Final Exam* 40%

* Final Exams: The final exam for online subjects must be written at the Test Centre of the College at which you registered. If you are unable to do so, please make alternative arrangements through the College at which you registered. All the academic policies of the College at which you registered apply. This includes, but is not limited to policies related to grading, supplemental exams, deferred exams and accommodations.

Please retain this course outline document for future educational and/or employment use.

Program Coordinator
Cynthia Duncan

Approved by: Chair - Business Studies Danielle Mercier