GIS107 - Access Expert

Outline info
Semester
School
Last revision date 2017-05-29 00:40:13.964
Last review date 2017-07-17 00:16:19.931


Subject Title
Access Expert

Subject Description
Learn to use the advanced features of MS Access for Windows. Upon completion, you will enhance tables by creating lookups, create various types of advanced queries, create advanced forms, create relationships between tables to ensure data accuracy, work with form controls, understand macro concepts, create, run, & test Access macros, create & use switchboard forms, set Access defaults and apply Startup options.

Credit Status
One credit towards the Geographic Information Systems (GIS) Certificate

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

1. Apply knowledge acquired about relational databases.

2. Create databases suitable for course work, professional purposes and personal use.

3. Use macros and wizards supported in Access.

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 http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

Discrimination/Harassment
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 student.conduct@senecacollege.ca.

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.

Prerequisite(s)
 Access - Core/Specialist (or equivalent) and familiarity with Windows XP Operating system or higher.

Topic Outline
Creating relational databases

Establishing table relationships and implementing referential integrity

Working with related tables

Relating tables to create lookup fields

Defining data entry rules

Creating input masks and setting field properties

Using advanced query features

Creating joins in tables, calculating fields and using action queries

Creating advanced queries

Sum and group values, creating crosstabs and use parameter queries and more

Advanced form design

Enhancing forms using graphics, combo boxes and unbound controls and more

Advanced report features

Creating custom headers and footers, adding calculated values and working with subreports

Creating charts

Creating charts in forms and reports

Switchboards and hierarchical forms

Creating custom switchboards and hierarchical forms

Macros and command buttons

Creating macros and custom buttons to automate your database objects

Exchanging data

Linking and embedding object, using Access web capabilities

Mode of Instruction
Online
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.
Platform:  Blackboard

Prescribed Texts
Online

Students using MS Office 2010 version should purchase: Benchmark Series: Access 2010 Level 2 by Denise Seguin  EMC Paradigm ISBN:  978-0-76384-307-6 OR ebook via ground mail ISBN:  978-0-76383-936-9 or via email ISBN:  978-0-76384-668-8

Students using MS Office 2013 should purchase: The Benchmark Series: Microsoft Access 2013 Level 2 by Denise Sequin EMC Paradigm www.emcp.com  ISBN: 978-0-76385-394-5 OR ebook – via ground mail ISBN:  978-0-76385-416-4 or via email ISBN:  978-0-76385-373-0


Reference Material
None

Required Supplies
Microsoft Access Version 2010 or 2013
Course does not support MAC users. Access not available for MAC.

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)
OR
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.


Modes of Evaluation
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.

Grading is based on the following marking scheme:

Online  
Assignment(s) 8 16%
Midterm Project  9%
Final Project  15%
Midterm Test  25%
Final Exam Online - no invigilation 35%



MINIMUM PERFORMANCE FOR GRADUATION
No student will be eligible to graduate with a Seneca College certificate or diploma if, in more than 30% of the subjects required for graduation, the student has received a "D" grade.


Assignments
  • Assignments are due on the date given by the instructor.
  • A late penalty of 10% per day is assessed for late assignments, including those not handed in at the beginning of class when due.
  • Material will not be accepted after one week following the due date and/or when the marked material is returned to students, whichever comes first.
  • Assignments are to be prepared by computer.

Absenteeism and Exams
  • Students who are absent for an examination due to an emergency (e.g., motor vehicle accident, hospitalization or death in the family) may provide official documentation within five days of the missed exam and be provided a deferred exam at a later date.  Official documentation includes a death notice or an original doctor’s certificate identifying the date, length of time expected absence and the specific reason for the absence.  Examinations missed without official documentation and approval result in a grade of zero.
  • There are no deferred options for missed tests.  

English Proficiency
  • All written work should demonstrate the following characteristics for clarity and conciseness:
-writing is consistent with the rules of English grammar
-spelling and punctuation are correct
-sentences are structured correctly
-main ideas are supported with specific, relevant examples and reasons
-work flows logically through supporting statements/paragraphs
-work is arranged in correct format (e.g., as a report, essay)
-up to 10% of the final grade may be deducted on all work if the above English competencies are not met.


PLEASE RETAIN THIS SUBJECT OUTLINE FOR POSSIBLE FUTURE USE IN SUPPORT OF CREDIT APPLICATIONS AT OTHER EDUCATIONAL INSTITUTIONS

Approved by: Sharon Estok