Lifeline, for more specific information about the College’s Code of Conduct and attendance requirements. Course Content Outline: based on the text The Pearson Custom Program for CIS Exploring Microsoft Office Access custom Essex County College edition with IT LAB’ Access Code, by Robert T Grauer; ‘MY published by Pearson; ISBN #: 978-0-536-11030-5 Class Meeting (80 minutes) Chapter/Topics 1 Introduction to the online software and creation of student accounts Chapter 1 2 Explore Access databases 3 4 Storage and memory, file management, soft table data – 5 6 Access or Excel to manage data, relationship windows – 7 Test 1 on Chapter 1 Chapter 2 8 9 Design data, create table, share data – 10 11 Share data with Excel, create and run a query, the query wizard – 12 14 databases, review for the Midterm Exam – 15 Midterm Exam on Chapters 1 & 2 Chapter 3 16 17 Create a calculated field in a query – 18 20 Create and edit Access functions, perform data arithmetic – 21 Create and work with data aggregates 22 Test 2 on Chapter 3 Chapter 4 23 24 Plan a report, use report – 25 Create and edit reports 26 27 Identify report elements, sections, and controls – 28 Add fields to a report, use the report wizard 29 Review for the Final Exam 30 Comprehensive Exam on all course material covered
Lifeline, for more specific information about the College’s Code of Conduct and attendance requirements. Course Content Outline: based on the text The Pearson Custom Program for CIS Exploring Microsoft Office Access custom Essex County College edition with ‘MY IT LAB’ Access Code, by Robert T Grauer; published by Pearson; ISBN #: 978-0-536-11030-5 Class Meeting (80 minutes) Chapter/Topics 1 Introduction to the online software and creation of student accounts Chapter 1 2 Explore Access databases 3 – 4 Storage and memory, file management, soft table data 5 – 6 Access or Excel to manage data, relationship windows 7 Test 1 on Chapter 1 Chapter 2 8 – 9 Design data, create table, share data 10 – 11 Share data with Excel, create and run a query, the query wizard 12 – 14 databases, review for the Midterm Exam 15 Midterm Exam on Chapters 1 & 2 Chapter 3 16 – 17 Create a calculated field in a query 18 – 20 Create and edit Access functions, perform data arithmetic 21 Create and work with data aggregates 22 Test 2 on Chapter 3 Chapter 4 23 – 24 Plan a report, use report 25 Create and edit reports 26 – 27 Identify report elements, sections, and controls 28 Add fields to a report, use the report wizard 29 Review for the Final Exam 30 Comprehensive Exam on all course material covered
cis.137.outline.f2010.docx