GIS107 - Access Expert

Outline info
Last revision date 2018-07-26 12:43:13.756
Last review date 2018-07-26 12:43:13.757

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 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.

 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
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

Students using MS Office 2013 should purchase: The Benchmark Series: Microsoft Access 2013 Level 2 by Davidson Seguin EMC Paradigm  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

Required Supplies
Microsoft Access 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)
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
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:

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

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 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.


Approved by: Sharon Estok