close
 

Now Open for In-Person Classes. COVID-19 Updates.

 

Scheduled Maintenance: PeopleSoft/MyCerritos will be down December 2-5 for maintenance.

CIS 155 Intro to Access

Recommendation: CIS 102 or equivalent with a grade of Pass or "C" or higher.
This is a foundation course in database management using Microsoft Access. It covers relational database concepts and design, techniques for building a database using queries, forms, reports, and expressions. Topics also include multiple-table queries and reports and the user interface to a database. This course covers the topics in the Microsoft Office User Specialist (MOUS) certifications.
Transfer Credit: CSU

Drop Date: 11/18/2022

CIS 155 MS Access Syllabus

Here are links to a location to buy the textbooks:

Textbook:

GO! with Microsoft Office 365, Access 2019 Comprehensive, 1st edition

or on Amazon:

GO! with Microsoft Office 365, Access 2019 Comprehensive 1st Edition

E-textbook:

Pearson eText GO! with Microsoft Office 365, Access 2019 Comprehensive -- Instant Access

This is a class on the MS Access application you will need access to this app on a WINDOWS computer (not Mac/Apple)

Get Office 365 with Access for FREE!!

Lab Student Data Files

Chapter Notes

  1. Ch01 instruction
  2. Ch02 Instruction
  3. Ch03 Instruction
  4. Ch04 Instruction
  5. Ch05 Instruction
  6. Ch06 Instruction
  7. Ch07 Instruction
  8. Ch08 Instruction
  9. Ch09 Instruction

Videos
Note: These Videos are from Excel 2016, but there are very few differences in tasks of Excel 2016 and 2019.
1 Project 1AProject 1B
2 Project 2AProject 2B
3 Project 3AProject 3B
4 Project 4AProject 4B
5 Project 5AProject 5B
6 Project 6AProject 6B
7 Project 7AProject 7B
8 Project 8AProject 8B
9 Project 9AProject 9B
10 Project 10AProject 10B

Objective Videos

Labs (See lab descriptions and submit labs thru Canvas)

  1. Ch01 Project C Instructions
    Lab01 solution
  2. Lab02 Solution
  3. Lab03 Solution
  4. Lab04 Solution
  5. Lab05 Solution
  6. Lab06 Solution
  7. Lab07 Solution
  8. Lab08 Solution
  9. Lab09 Solution

Test Solutions

  1. Test01a Project 3D
  2. Test02a Project 6D
  3. Test03a Project 7D

Stay Connected

Site Map | Accreditation | Disclaimer | Document Readers | Report a Website/Accessibility Issue | Safety Reporting | Consumer Information Last Update: 11/25/2022