APPL70054
Access, Advanced |
 |
|
|
|
Section I: Administrative Information
|
|
Total hours: 42.0
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Spring/Summer 2021
Prerequisites: APPL70053
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: N/A |
Program(s):
Database - Introductory, Geographic Information Systems, Microsoft Office Applications
Program Coordinator(s):
Greg Golding
Course Leader or Contact: N/A
Version: 20210517_00
Status: Approved (APPR)
Section I Notes:
Access to course materials and assignments will be available on Sheridan's Learning and Teaching Environment (SLATE). Students will need reliable access to a computer and the internet.
|
|
|
Section II: Course Details
|
Detailed Description
Build upon the skills learned in Microsoft Access Introduction to build and modify advanced tables, forms, queries and reports. Use advanced features to design and build relationships, validate data, create calculated fields and logical functions. Automate functions using macros including sub-macros, actions and logical functions. Integrate data with text files and other programs to further develop tables and create reports in various file formats. Create and edit customized Charts, PivotTables and PivotCharts.
Program Context
|
Database - Introductory |
Program Coordinator(s):
N/A |
This course is a required course in the Database - Introductory Recognition of Achievement Program, offered through the Faculty of Continuing and Professional Studies.
|
Geographic Information Systems |
Program Coordinator(s):
N/A |
This course is a required course in the Geographic Information Systems Recognition of Achievement Program, offered through the Faculty of Continuing and Professional Studies.
|
Microsoft Office Applications |
Program Coordinator(s):
Greg Golding |
This course is a required course in the Microsoft Office Applications Sheridan Certificate Program, offered through the Faculty of Continuing and Professional Studies.
|
|
Course Critical Performance and Learning Outcomes
|
Critical Performance: |
| Students will have demonstrated the ability to build and modify advanced tables, forms, reports and queries.
|
|
Learning Outcomes:
To achieve the critical performance, students will have demonstrated the ability to:
|
|
- Create, format, modify, save and print advanced databases with related tables, forms and reports.
- Create select queries, match queries, parameter queries, crosstab queries and Find Duplicates queries.
- Create and customize macros with sub-macros, actions and logic functions.
- Design and build one-to-one, one-to-many and many-to-many relationships, and create indexes.
- Apply advanced features such as validation rules and text, input masks and lookup fields.
- Apply formatting features such as fonts, graphic images, headers, footers and page numbering.
- Embed a customized chart into forms and reports including Pivot Charts and Pivot Tables.
- Integrate with other programs by linking, importing and export data.
- Publish database reports in PDF or XPS file formats.
- Apply effective file management skills when creating folders, and copying, moving, deleting and renaming files.
|
Evaluation Plan
Students demonstrate their learning in the following ways:
| Evaluation Plan: ONLINE
| Training (12 Total) | 24.0% | | Exams (12 Total) | 24.0% | | Projects (12 Total) | 52.0% | | Total | 100.0% |
Evaluation Notes and Academic Missed Work Procedure: Students are encouraged to complete all online work for assessment and preparation for the tests.
SAM 2019: Online Training Tutorials: Online training tutorials are marked. There are an unlimited number of attempts permitted for each training tutorial.
SAM 2019: Online Exams: Online Exams are based on skills learned and practiced in the Online Training Tutorials. If a student does not complete an online exam, they will receive a mark of zero. The actual score for each online exam is recorded.
SAM 2019: Projects: Projects are completed in the application software and submitted through SAM 2019. Projects summarize each section's skills learned. Projects are due as per the assignment schedule. A student's actual score on the assignment will be recorded.
In situations where a student knows, in advance, that s/he will not be able to submit by the scheduled due date, the student must contact the instructor, in writing, prior to the scheduled due date providing an explanation, and a request to submit the project on an alternate date. In these situations, the project must be submitted in advance of the scheduled due date.
All training/exams/projects must be completed as individual efforts unless the instructor states otherwise in writing.
Evaluation Plan: IN-CLASS
| Training (12 Total) | 24.0% | | Exams (12 Total) | 24.0% | | Projects (12 Total) | 52.0% | | Total | 100.0% |
Evaluation Notes and Academic Missed Work Procedure: Students are encouraged to complete all online work for assessment and preparation for the tests.
SAM 2019: Online Training Tutorials: Online training tutorials are marked. There are an unlimited number of attempts permitted for each training tutorial.
SAM 2019: Online Exams: Online Exams are based on skills learned and practiced in the Online Training Tutorials. If a student does not complete an online exam, they will receive a mark of zero. The actual score for each online exam is recorded.
SAM 2019: Projects: Projects are completed in the application software and submitted through SAM 2019. Projects summarize each section's skills learned. Projects are due as per the assignment schedule. A student's actual score on the assignment will be recorded.
In situations where a student knows, in advance, that s/he will not be able to submit by the scheduled due date, the student must contact the instructor, in writing, prior to the scheduled due date providing an explanation, and a request to submit the project on an alternate date. In these situations, the project must be submitted in advance of the scheduled due date.
All training/exams/projects must be completed as individual efforts unless the instructor states otherwise in writing.
|
Provincial Context
The course meets the following Ministry of Colleges and Universities requirements:
|
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):
|
|
|
|
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.
|
All Sheridan policies can be viewed on the Sheridan policy website.
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.
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.
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.
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 coordinates academic accommodations for students with disabilities. For more information or to register, please see the Accessible Learning website (Statement added September 2016)
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. . 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 ]
|
Copyright © Sheridan College. All rights reserved. |