GIS106 - Access Core

Outline info
Last revision date 2018-07-26 12:42:53.475
Last review date 2018-07-26 12:42:53.478

Subject Title
Access Core

Subject Description
Learn to use MS Access for Windows. Access is a relational database management system in a user - friendly environment. This course is designed for students who wish to establish an understanding of Microsoft Access, including the skills necessary to create a new databse, construct data tables, design forms and reports, and create queries.

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

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

1. Discuss uses of Access in GIS applications.

2. Discuss relational databases and their relevance in GIS applications.

3. Design a database that addresses defined needs.

4. Create, manipulate, retrieve and output data accurately and quickly.

5. Explain the use of multiple tables.

6. Create and use forms, reports and queries.

7. Use various functions of Access for specific applications.

8. Design, administer and manage databases and effectively use a Database Management System (DBMS).

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.

Familiarity with Windows Operating Systems as well as file management concepts.

Topic Outline
Data concepts (an overview of Access and the concept of a relational database) and getting help

Access basics, exploring database objects

Creating databases and tables

Working with fields and records, entering and editing existing data and adding new records

Querying tables, creating and modifying queries as well as using calculations in queries

Creating and using forms, creating, modifying and printing reports

Creating and using reports, creating, modifying and printing reports

Importing and exporting data, importing data from other programs and prepare Access databases for exporting

Graphic images, insert images on forms and reports. Linking and embedding graphics into forms and use the graph wizarding

Relational databases, creating relational databases and database normalization concepts

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
Computer Software Requirements:  Microsoft Access Version 2010, 2013.  Course does not support MAC users.

Prescribed Texts

Students using MS Office 2013 version should purchase: The Benchmark Series: Microsoft Access 2013 Level 1  by Rutkosky, Roggenkamp, Rutkosky EMC Paradigm ISBN:  978-0-76385-393-8 OR ebook: via ground delivery ISBN: 978-0-76385-415-7 or via email 978-0-76385-372-3
No substitutions.  Students to purchase text according to their version of software.  eBook available at:
Benchmark Series: Microsoft Access 2013 Level I - eBook, 180-day online access (code via ground delivery) ISBN: 978-0-76385-415-7
Benchmark Series: Microsoft Access 2013 Level I - eBook, 180-day online access (code via email) ISBN: 978-0-76385-372-3

Textbooks are the same for Monthly and Semester intakes.
Access not available for MAC

Reference Material

Required Supplies
Microsoft Access 2013. Course does not support MAC users.

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.

Minimum Pass Detail: 50%

Grading is based on the following marking scheme:

User Profile 1%
Assignment(s) 8 16%
Midterm Project 9%
Final Project 15%
Midterm Test 24%
Final Exam On-line, 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