OCA403 - Access

Outline info
Semester
School
Last revision date 2024-02-20 09:37:58.143
Last review date 2024-02-20 09:37:58.143


Subject Title
Access

Subject Description
Microsoft Access is a computerized database that allows you to manipulate, link, chart, query and report your data to customize the information you need. You will learn to use Microsoft Access to create databases, view, format, manage and modify data tables and fields. You will learn to create forms, queries, reports and explore data relationships using its pull-down menus, toolbars and dialog boxes. Microsoft certified courseware publication is used to present the software features in a well-illustrated graphic format to prepare students to complete the appropriate Microsoft Certification exam #77-730 for students who wish to write the MOS (Microsoft Office Certification).

Credit Status
This is a credit subject towards certificates in the Office Administration programs.

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

  1. Understand Microsoft Access 2016 through its functional features and concepts
  2. Design databases
  3. Administer databases
  4. Manage databases
  5. Use a Database Management System (DBMS) effectively

Essential Employability Skills
    •  Apply a systematic approach to solve problems.

    •  Use a variety of thinking skills to anticipate and solve problems.

    •  Locate, select, organize, and document information using appropriate technology and information systems.

    •  Analyze, evaluate, and apply relevant information from a variety of sources.

    •  Manage the use of time and other resources to complete projects.

    •  Take responsibility for one's own actions, decisions, and consequences.

Academic Integrity
Seneca upholds a learning community that values academic integrity, honesty, fairness, trust, respect, responsibility and courage. These values enhance Seneca's commitment to deliver high-quality education and teaching excellence, while supporting a positive learning environment. Ensure that you are aware of Seneca's Academic Integrity Policy which can be found at: http://www.senecapolytechnic.ca/about/policies/academic-integrity-policy.html Review section 2 of the policy for details regarding approaches to supporting integrity. Section 2.3 and Appendix B of the policy describe various sanctions that can be applied, if there is suspected academic misconduct (e.g., contract cheating, cheating, falsification, impersonation or plagiarism).

Please visit the Academic Integrity website http://open2.senecac.on.ca/sites/academic-integrity/for-students to understand and learn more about how to prepare and submit work so that it supports academic integrity, and to avoid academic misconduct.

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@senecapolytechnic.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 Accessibility Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

Camera Use and Recordings - Synchronous (Live) Classes
Synchronous (live) classes may be delivered in person, in a Flexible Learning space, or online through a Seneca web conferencing platform such as MS Teams or Zoom. Flexible Learning spaces are equipped with cameras, microphones, monitors and speakers that capture and stream instructor and student interactions, providing an in-person experience for students choosing to study online.

Students joining a live class online may be required to have a working camera in order to participate, or for certain activities (e.g. group work, assessments), and high-speed broadband access (e.g. Cable, DSL) is highly recommended. In the event students encounter circumstances that impact their ability to join the platform with their camera on, they should reach out to the professor to discuss. Live classes may be recorded and made available to students to support access to course content and promote student learning and success.

By attending live classes, students are consenting to the collection and use of their personal information for the purposes of administering the class and associated coursework. To learn more about Seneca's privacy practices, visit Privacy Notice.

Prerequisite(s)
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

None

Required Supplies
COMPUTER SOFTWARE REQUIREMENTS:

MS Access v: 2019/365.

Student Progression and Promotion Policy

http://www.senecapolytechnic.ca/about/policies/student-progression-and-promotion-policy.html

Grading Policyhttp://www.senecapolytechnic.ca/about/policies/grading-policy.html

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.senecapolytechnic.ca/about/policies/academics-and-student-services.html) or at Seneca's Registrar's Offices. (https://www.senecapolytechnic.ca/registrar.html).



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.) 
Assignments
  • 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.senecapolytechnic.ca/Academic_Honesty/. 


Grading is based on the following marking scheme:

Assignments 70%
Final Exam 30%

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

Approved by: Melanie Rubens