Sheridan Course Outlines

APPL15738
Database Management

I: Administrative Information II: Course Details III: Topical Outline(s) Printable Version

Section I: Administrative Information

Total hours: 42.0
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Fall 2014
Prerequisites: N/A
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: N/A

Program(s): Office Admin - Executive
Program Coordinator(s): Lisa Mendez
Course Leader or Contact: Kellie Hayward
Version: 2.0
Status: Approved - Under Rev (AREV)

Section I Notes: N/A

Section II: Course Details

Detailed Description
Students learn the fundamental concepts of planning and designing a relational database. Students design, create and customize basic to advanced tables, queries, forms and reports. Students use advanced features to design and build relationships, validate data, create indices, create calculated fields and logical functions. Maintenance of databases are explored by students through compact, repair and backup functions. Students learn advanced tools to analyze, sort, filter, link, merge, import and export data.

Program Context

Office Admin - Executive

Program Coordinator: Lisa Mendez

This is a required course of the Office Administration Executive program. Students establish foundation skills and knowledge required in future core courses. The skills and knowledge acquired and refined in this course are essential to perform effectively in the workplace.

Course Critical Performance and Learning Outcomes

 
Critical Performance
By the end of this course, students will have demonstrated the ability
to design, create and maintain a relational database system using 
database software.

Learning Outcomes
To achieve the critical performance, students will have demonstrated
the ability to: 

1.  Design database tables including necessary properties in 
    design and datasheet view.
2.  Build one-to-one, one-to-many many-to-many relationships, and 
    indices.
3.  Generate Select and Action queries with logical operators and 
    calculated fields.
4.  Create customized reports, subreports and labels.
5.  Integrate data through linking, merging, importing, exporting and 
    summarizing functions. 
6.  Produce customized forms, main forms, subforms and splitforms. 
7.  Apply advanced features such as validation rules, text/input 
    masks and lookup fields.
8.  Maintain a database through compact, repair, backup and 
    restore functions.
9.  Create customized embedded charts. 
10. Publish database reports in PDF or XPS file formats.

Evaluation Plan
Students demonstrate their learning in the following ways:

25%   Practical Skills Test 1
25%   Practical Skills Test 2
10%   Online Tutorials
10%   Online Quizzes
30%   Projects
 
100%	Total

Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

Essential Employability Skills
Essential Employability Skills emphasized in the course:

	Communication	X	Critical Thinking & Problem Solving		Interpersonal
X	Numeracy	X	Information Management	X	Personal

Notes: N/A

Prior Learning Assessment and Recognition
PLAR Contact (if course is PLAR-eligible) : Office of the Registrar
Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous relevant work/life experience, service, self-study and training on the job. This course is eligible for challenge through the following method(s):

Challenge Exam	Portfolio	Interview	Other	Not Eligible for PLAR
X

Notes: N/A

Section III: Topical Outline

Some details of this outline may change as a result of circumstances such as weather cancellations, College and student activities, and class timetabling.
Effective term: Fall 2014
Professor: Multiple Professors
Textbook(s):

On-line tutorials and assessments:  A Skills Assessment Manager (SAM) 
PIN is required in order to complete Tutorials, Exams and Projects. 
Purchasing instructions will be provided in class.

E-book:  New Perspectives on Microsoft Access 2013, Custom e-book 
access. Purchasing instructions will be provided in class.

RESOURCES:
Cengage Learning Student Textbook Companion Site Cengage Learning 
Skills Assessment Manager (SAM 2013) - http://sam.cengage.com//

Applicable student group(s): Office Administration Executive Year 1 Students
Course Details:

ORIENTATION 
Introduction to course
Use of SLATE
Introduction to Skills Assessment Manager (SAM 2013)
Course assignments and deadlines

Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Practice Training Session, Exam, Project

MODULE 1: CREATING A BASIC ACCESS DATABASE (TABLE/FIELD
DESIGN)
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #1A and B (3.75%)
 

MODULE 2: BUILDING A DATABASE AND DEFINING TABLE RELATIONSHIPS
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #2A and B (3.75%)

MODULE 3: MAINTAINING AND QUERYING A DATABASE
Assessment and Activities:
Skills Assessment Manager (SAM2013) 
- Online Training (1.25%) 
- Online Quiz (1.25%)
- Project #3A and B (3.75%)

MODULE 4: CREATING FORMS AND REPORTS
Assessment and Activities:
Skills Assessment Manager (SAM2013): 
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #4A and B (3.75%)

Test #1 - Creating basic tables, queries, forms and reports (25%)

MODULE 5: CREATING ADVANCED QUERIES AND ENHANCING TABLE DESIGN
Assessment and Activities:
Skills Assessment Manager (SAM2013): 
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #5A and B (3.75%)

MODULE 6: USING FORMS TOOLS AND CREATING CUSTOM FORMS
Assessment and Activities:
Skills Assessment Manager (SAM2013): 
- Online Training  (1.25%)
- Online Quiz (1.25%)
- Project #6A and B (3.75%)

MODULE 7: CREATING CUSTOM REPORTS
Assessment and Activities:
Skills Assessment Manager (SAM2013):
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #7A and B (3.75%)


MODULE 8: SHARING, INTEGRATING AND ANALYZING DATA
Assessment and Activities:
Skills Assessment Manager (SAM2013) 
- Online Training (1.25%)
- Online Quiz (1.25%)
- Project #8A and B (3.75%)

Test #2 - Enhancing and Customizing queries, forms and reports (25%)

Sheridan Policies

All Sheridan policies can be viewed on the Sheridan policy website.

Academic Integrity: The principle of academic integrity requires that all work submitted for evaluation and course credit be the original, unassisted work of the student. Cheating or plagiarism including borrowing, copying, purchasing or collaborating on work, except for group projects arranged and approved by the professor, or otherwise submitting work that is not the student's own, violates this principle and will not be tolerated. Students who have any questions regarding whether or not specific circumstances involve a breach of academic integrity are advised to review the Academic Integrity Policy and procedure and/or discuss them with the professor.

Copyright: A majority of the course lectures and materials provided in class and posted in SLATE are protected by copyright. Use of these materials must comply with the Acceptable Use Policy, Use of Copyright Protected Work Policy and Student Code of Conduct. Students may use, copy and share these materials for learning and/or research purposes provided that the use complies with fair dealing or an exception in the Copyright Act. Permission from the rights holder would be necessary otherwise. Please note that it is prohibited to reproduce and/or post a work that is not your own on third-party commercial websites including but not limited to Course Hero or OneNote. It is also prohibited to reproduce and/or post a work that is not your own or your own work with the intent to assist others in cheating on third-party commercial websites including but not limited to Course Hero or OneNote.

Intellectual Property: Sheridan's Intellectual Property Policy generally applies such that students own their own work. Please be advised that students working with external research and/or industry collaborators may be asked to sign agreements that waive or modify their IP rights. Please refer to Sheridan's IP Policy and Procedure.

Respectful Behaviour: Sheridan is committed to provide a learning environment that supports academic achievement by respecting the dignity, self-esteem and fair treatment of every person engaged in the learning process. Behaviour which is inconsistent with this principle will not be tolerated. Details of Sheridan's policy on Harassment and Discrimination, Academic Integrity and other academic policies are available on the Sheridan policy website.

Accessible Learning: Accessible Learning coordinates academic accommodations for students with disabilities. For more information or to register, please see the Accessible Learning website (Statement added September 2016)

Course Outline Changes: The information contained in this Course Outline including but not limited to faculty and program information and course description is subject to change without notice. Any changes to course curriculum and/or assessment shall adhere to approved Sheridan protocol. Nothing in this Course Outline should be viewed as a representation, offer and/or warranty. Students are responsible for reading the Important Notice and Disclaimer which applies to Programs and Courses.

[ Printable Version ]