OCA403 - Office V: Access

Outline info
Last revision date 2018-11-01 12:21:05.692
Last review date 2018-11-01 12:21:05.694

Subject Title
Office V: Access

Subject Description
Students learn the basic features of Access 2016 for Windows by creating and maintaining a database file using design and datasheet views; produce complex spreadsheets and databases; and learn to work effectively in a simulated computerized business environment through case studies.

Credit Status
This is a credit subject towards certificates in the Office Administration programs offered through the Faculty of Continuing Education and Training.

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

1. Create a database and modify the structure of tables;

2. Create, modify and use relational databases;

3. Query a database;

4. Create a form that contains a sub-form;

5. Use data and memo fields in a query;

6. Create and design reports;

7. Create a report with grouping and subtotals;

8. Change headings in a report, move and re-size controls on reports and forms;

9. Place a calculated field on a form;

10. Publish database data to the Web;

11. Use data, memo and pictures in OLE fields;

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.

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.

Office Computer Applications - Excel OCA303

It is your responsibility to ensure that program requirements and subject prerequisites as outlined are met. Prerequisites are included for your academic protection. Subject content and your professor's teaching assumes that students are academically prepared and instruction will proceed accordingly. Students lacking prerequisites not only jeopardize their own ability to succeed but present unnecessary interruption. If you lack appropriate prerequisites (or advance standing for the prerequisite subject) you may be asked to withdraw or transfer to a more appropriate subject with the risk of academic/financial penalty. It is your responsibility to save documents, articles and notes that the instructor has provided on BlackBoard or in class. Students will not be able to access BlackBoard as of the last day of the student's class. 

Topic Outline
The order of the topics is at the discretion of the professor.  The content of one module does not have to be completed before another module is started, nor do the modules have to be taught in the order listed.  Rather by the end of the subject all the topics will have been covered.

Creating a Database Using Design and Datasheet Views

  • Describe databases and database management systems
  • Start Access and describe the Access screen
  • Create a database
  • Define the fields in a table
  • Open and close tables
  • Add records to empty and nonempty tables
  • Print the contents of a table
  • Use a form to view data
  • Create a custom report
  • Design a database to eliminate redundancy
Querying a Database Using the Select Query Window
  • State the purpose of queries
  • Create a new query
  • Use a query to display all records and all fields
  • Run a query
  • Print the results of a query
  • Clear and close a query
  • Use a query to display selected fields
  • Use text, numeric and wildcard data in a query
  • Use comparison operators
  • Use compound criteria involving AND & OR
  • Sort answers to queries
  • Join tables in a query
  • Restrict records in a join
  • Use calculated fields in a query
  • Calculate statistics in a query
  • Use groupings with statistics
  • Save a query
  • Use a saved query 
Maintaining a Database Using the Design and Update Features of Access
  • Add, change and delete records in a table
  • Locate records
  • Filter records
  • Change the structure of a database
  • Restructure a database
  • Add and change field characteristics
  • Update contents of a single field
  • Make changes to groups of records
  • Delete groups of records
  • Specify a required field, a range, a default value, legal values and formats
  • Update a table with validation rules
  • Specify referential integrity
  • Use sub-datasheets
  • Order records
Reports, Forms and Combo Boxes
  • Create query for a report
  • Use the Report Wizard to create a report
  • Use the Report window to modify a report design
  • Move between Design view and Print Preview
  • Recognize sections in a report
  • Save, print and close a report
  • Create a report with groupings and subtotals
  • Change headings in a report
  • Move and resize controls on a report
  • Use the Form Wizard to create a form
  • Use the Form window to modify a form design
  • Move fields on a form
  • Place a calculated field on a form
  • Change the format of a field on a form
  • View data using a form
Enhancing Form with OLE Fields, Hyperlinks, and Subforms
  • Use date, memo, OLE and Hyperlink fields
  • Enter data in the date, memo, and OLE fields
  • Enter Web page names for use in a hyperlink field
  • Change the row and column spacing in tables
  • Save the table properties
  • Create a form with a subform
  • Move and resize fields on the form
  • Change the styles and colours of a form
  • Use special effects on a form
  • Use a form that contains a subform
  • Use the date and memo fields in a query
  • Compact a database
Creating an Application System Using Macros, Wizards, and the Switchboard Manager
  • Use the Lookup Wizard to create a lookup field
  • Use the Input Mask Wizard to create an input mask
  • Update a field using an input mask
  • Add a control for a single field to a report
  • Add a calculated control to a report
  • Add a control for a single field to a form
  • Create and modify a macro
  • Add actions and comments to a macro
  • Run a macro
  • Create a switchboard
  • Modify a switchboard pages and items
  • Use a switchboard
Integrating Microsoft Office 2016
  • Open multiple programs
  • Us shortcut keys to switch between open programs
  • Merge data between Access and Word
  • Export an Access Table to Excel
  • Export an Access Table to Word 

Mode of Instruction
Students learn through classroom lectures, hands-on assignments during classroom hours, as well as homework assignments.

Blended models of delivery may also be available.

Students are required to complete assignments and practice the skills they have learned in the lab. 

Prescribed Texts
Benchmark Series: Microsoft Access 2016 Levels 1 & 2, EMC Paradigm, Latest Edition.

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 (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.

Modes of Evaluation
Since this is a professional credit subject, marking standards reinforce professional practice by demanding legible, tidy work. Written materials should be well organized, correctly formatted and grammatically correct, with proper spelling and punctuation.

Please Note

  • Assignments, tests and the final examination are evaluated on subject knowledge as well as correct language usage, organization, and mastery of the subject. 
  • In recognition of the significance of proper language skills in the workplace, marks are deducted, in accordance with departmental policy, for language errors on all tests, assignments and exams. (i.e. spelling, grammar, word usage, sentence, and paragraph structure, etc.) 
  • The student must retain a copy of all assignments.
  • If assignments are handed in late without sufficient medical or other reason, which must be documented and approved, two marks per day will be deducted for each day the assignment is late up to a maximum of 10 marks in total. 
  • Assignments will not be accepted after the return of graded assignments to the class and/or the provision to the class of the answers to the assignment.
  • Written assignments must be word processed. At the professor’s discretion, assignments that are not word processed, may be subject to mark deduction or not accepted. 
  • For particulars, please obtain standards, dates, etc. from your instructor.

Absenteeism and Tests
  • Students should be aware that absenteeism will impact on their ability to achieve satisfactory grades.
  • If you miss a test, you must provide the reason in writing to the instructor within one week.  If your reason is accepted, the weighting of that test will be added to that of the final exam.  Otherwise, you will be given a zero for the test.  You must submit an original doctor’s certificate identifying the date, length of time of expected absence and the specific reason for your absence,  or other appropriate documentation.
  • Progress tests and quizzes may not be announced in advance and details of the assignment requirements may be explained in class.

Final Exam/ Final Assignment
  • Students must attain a grade of at least 50% to pass the course.
  • For further information on evaluation and academic standing, see a copy if the Academic Policy available at Seneca Registration offices.

Field Placement Requirements

Students who do not successfully complete all professional subjects may not be eligible for placement. 

Academic Honesty

Students at Seneca College are expected to be honest and forthright in their academic endeavours.  When students cheat on an examination, steal the words or ideas of another, or falsify their research results, it corrupts the learning process. A Seneca College degree, diploma or certificate signifies to society mastery of a set of defined learning outcomes in a designated field of study. If academic credit is obtained dishonestly, the value of every graduate's diploma in the field of study is diminished, as is the reputation of the college as a whole.
Penalties for Academic Dishonesty
The penalty for a first offence is a grade of '0' on the assignment or examination. The penalty for the second offence is expulsion for a time period determined by the Academic Honesty Committee, normally for a minimum of three semesters.

For further information refer to the policies section of the Seneca College student handbook, or to the following website: http://library.senecacollege.ca/Academic_Honesty/. 

Grading is based on the following marking scheme:

Term Test(s)/Quiz(s)(minimum 2) 40%
Assignments 20%
Final Exam 40%

Materials permitted into tests and exam are at the discretion of the instructor.

Approved by: Sandra Noble