Internet Explorer 7, 8, and 9 are no longer supported. Please use a newer browser.
Concourse works best with JavaScript enabled.
Lansing Community College logo

Main · Technical Careers · Computer Information Tech

Microsoft Access Database

  • Spring 2021
  • Section All
  • 3 Credits
  • 01/11/2021 to 05/10/2021
  • Modified 12/16/2020


This course provides introductory through intermediate level training in the creation of database management systems using Microsoft Access.  Instruction includes an introduction to Microsoft Access, database creation and maintenance, database querying, the generation of custom forms and reports, and integration of Access with other programs.  (F,Sp,Su)


Prerequisite Courses: None
Placement Score: Reading Level 4
Recommended: Windows and keyboarding experience

Course Note:  

Students must be able to use web browsers and online learning tools including drop boxes, discussion boards, and e-mail. They must also have Windows file management skills, including the ability to upload and download files, make folders, move and zip files.

This course requires the use of a PC computer running Windows 10, 4GB Ram, High Speed Internet Connection – 2 Mbit or higher, current version of Microsoft Office (see Materials section) and a MyLabIT account. Mac and Chromebook computers are not fully compatible and are not recommended. Equipment and software is provided for students that wish to complete assignments at the Main or West Campus computer labs. Office 365 is available to LCC students at no cost using links from the College website.

Contact Hours







Total Hrs


Student Learning Outcomes

Upon successful completion of this course, students should be able to:

  1. Create, modify, and update intermediate level Tables.
  2. Create, modify, and update intermediate level Queries.
  3. Prepare, modify, and update intermediate level custom Forms.
  4. Prepare, modify, and update intermediate level custom Reports.
  5. Utilize Access databases to query data based on intermediate level criteria.
  6. Sort and filter database information based on intermediate level criteria.
  7. Perform basic integration of Access with Microsoft Excel and Word applications.
  8. Create one to many relationships among database objects.
  9. Compact databases.
  10. Import and export database objects.
  11. Create parameter and cross tab queries.
  12. Create forms with subforms.
  13. Create a look-up wizard field.
  14. Use domain aggregate function in reports.
  15. Import and export from Excel, HTML,and XML.



Other Materials/Resources


At a minimum, access to a PC computer running Windows 10, 4GB Ram, High Speed Internet Connection – 2 Mbit or higher, a USB storage device (1 gigabyte or more) is recommended for storing and transporting homework. As an alternative you may use sufficient free local hard disk space or cloud-based storage solution.


  • Access to high speed internet
  • Web browser (current version of Google Chrome recommended)
  • Current version of Microsoft Office
  • MyLabIT access

Technical skills:  Basic computer skills, including the ability to:

  • Use Desire2Learn (D2L) course site
  • Use email (D2L and LCC Student email accounts)
  • Add and open attachments in email
  • Download and install software
  • Create Windows compressed (zipped) folders for submitting assignments
  • Download and open data files
  • Download and decompress zipped folders to obtain needed data files
  • Create new files
  • Modify existing files
  • Save files in commonly used formats
  • Copy and paste text


Student Electronic Access to Grades

D2L is the College’s Course Management System which includes a gradebook function allowing students access to their grades in order to receive timely and meaningful feedback on their progress in the course at any time. These grades will align with the Evaluation Criteria listed in this syllabus. D2L is accessed through the MyLCC page.

Whenever practicable, results for graded items should be posted electronically within 48 hours after the instructor has completed the grading process for the items, and final grades for the course should be entered no later than the specified grading day.


Types of evaluations and related weights
Type Weight Topic Notes
Assignments 25-40%
Class Attendance

See Class Attendance/Participation Policy below under Course Policies.

Class Participation 0-5%
Exams or Tests 60-75%

Departmental mid-semester and final exam may need to be taken in class, at the Assessment Center or at an approved off campus testing site.

Projects 0-5%
Quizzes 0-15%


College Standard




College Grading Standards

Recommended Guidelines for Student Grades

4.0  --- Excellent

4.0     ---     91 – 100%

3.5  --- ---------

3.5     ---     86 – 90%

3.0  --- Good

3.0     ---     81 – 85%

2.5  --- ---------

2.5     ---     76 – 80%

2.0  --- Satisfactory

2.0     ---     71 – 75%

1.5  --- ---------

1.5     ---     66 – 70%

1.0  --- Poor

1.0     ---     60 – 65%

0.0  --- --------

0.0     ---       0 – 59%

Course Policies

CITA 133 Course Policies

Class Attendance/Participation

Although attendance is not taken in this course, a student is expected to participate in all sessions.  This includes attending all traditional class meetings or regularly participating on the discussion boards for on-line classes and turning in fully completed acceptable quality assignments. If a student cannot participate in class due to illness or for extenuating circumstances, the student has the responsibility to notify the instructor. Even when the instructor is notified of the circumstances, that in no way relives the student of the responsibility for completing all work in the course to the satisfaction of the instructor. If continued attendance is not possible, it is the student’s responsibility to drop the course within the dates and conditions defined in the schedule book in order to receive a withdrawal "W" rather than a "0" grade.

Test and Assignment Policies

Student Learning Requirement:  It is VERY IMPORTANT to complete assignments a couple of days before final deadlines so that there is time to get help and make necessary corrections before assignments are submitted. This shift in responsibility from primary education that may be referred to as mastery learning.  As a college student you are responsible for seeking any necessary assistance to correct your assignments before they are submitted so that you are prepared to move on to the next topic as soon as you have submitted your homework. Submitting incorrect assignments or asking questions in the drop box during submission for grading is not beneficial for timely continued participation because our work is often cumulative and requires correctness to begin the next assignment.

Assignments: Plan to spend 2 to 3 hours per course credit each week on the weekly lessons (approximately 8 to 12 hours total, twice this amount summer). Assignments must be submitted on time to receive full credit unless other plans have been approved by the instructor prior to due dates. Your instructor will inform you of his/her late policy. Assignments are typically graded within three business days of the due date or the next class for traditional sections or as otherwise stated by your instructor.

Exams: Exams must be taken on dates listed unless other arrangements have been made in advance with the instructor’s permission. Traditional students will take exams in class. Online students must take at least two exams at a testing center.  Exams will be kept on file for two weeks after exam dates so questions, concerns, or grade related information regarding exams should be made in writing or in person within two weeks of the exam date. Exams are typically graded within 3-5 business days of the due date or as otherwise stated by your instructor.

CIT Program Policies


Netiquette (or network etiquette) is defined as a set of principles developed to express courtesy and to help people act appropriately while sending e-mail and using the Internet. All of us (instructor and students) will demonstrate netiquette and civility whenever interacting with each other. Please use standard “Business English” (complete sentences) and not jargon or slang for all communications.

Consider anything said in the public forums to be public information. Don’t post comments that may be controversial, abrasive, or in poor taste or information that may reveal too much personal information - protect your privacy! Please do not post in all capital letters as it can be considered yelling.

Academic Honesty/Cheating/Plagiarism

Please note that students are welcome to discuss topics and help one another solve problems while working on assignments but all assignments for this course are to be completed independently by the student named on the assignment. They are not group projects or group assignments.

Each student is expected to be honest in his or her work. Cheating and plagiarism are dishonest. The purpose of this policy is to establish College definitions of cheating and plagiarism and to describe potential consequences of academic dishonesty.  This policy applies to all students.

The term "cheating" includes but is not limited to:

  1. Copying in part or in whole from someone else’s assignment or submitting an assignment done by someone else without completely acknowledging their contribution.  This should not be an issue since all work is required to be done independently for this course.
  2. Use of any unauthorized assistance including electronic devices/media or on-line resources while taking quizzes, tests, or examinations. Some examples are e-books, Google, and Electronic messages or communications…
  3. Dependence upon the aid of sources beyond those authorized by the instructor while writing papers, preparing reports, solving problems, or completing assignments that require sounds and or moving or still images.
  4. The acquisition of tests or other academic materials without permission of the faculty or staff to whom the materials belong. Any interaction with any person other than the instructor or proctor in a testing situation may be interpreted as cheating.
  5. Academic honesty is twofold on the part of the student; first, not to cheat, and second, not to enable others to cheat. Sharing or posting electronically unauthorized assignment materials or exam materials is considered cheating.

The term "Plagiarism" includes but is not limited to the use, by paraphrase or direct quotation or the inclusion of electronic sources, of the published or unpublished work of another person without full and clear acknowledgment. When producing work for a course, students are expected to present their own ideas and to appropriately acknowledge the incorporation of another person's work. Not doing so is dishonest.

For any of these violations, the student is subject to academic penalty and other disciplinary action. Academic penalty may consist of a "0.0" grade for the offending work or (with departmental approval) a "0.0" grade for the course.

Computer Resources – Acceptable Use

Use of College-owned computer resources is a privilege extended by the College to students, employees, and other authorized users as a tool to promote the mission of the College. All users agree to be bound by the terms and conditions of the LCC Acceptable Use Policy at the time they complete an account application form. Copies of the LCC Acceptable Use Policy are available at the Library Circulation Desk and may also be accessed on the World Wide Web. The URL is

Theft or Other Abuse of Computer Facilities and Resources, including but not limited to:     

  1. Unauthorized entry into a file, to use, read, or change the contents, or for any other purpose.
  2. Unauthorized transfer of a file.
  3. Use of another individual's identification and/or password.
  4. Use of computing facilities and resources to interfere with the work of another student, faculty member or college official.
  5. Use of computing facilities and resources to send obscene or abusive messages.
  6. Use of computing facilities and resources to interfere with normal operation of the college computing system.
  7. Use of computing facilities and resources in violation of copyright laws.
  8. Any violation of the college's Acceptable Use Policy at


Most Computer Information Technologies classrooms are set up with Internet access for course work and research.

Class-Related Use of Internet Resources

Student access to classroom Internet resources will be determined by the course faculty as part of their classroom management function, i.e., faculty will determine appropriate in-class use based on course outcomes and class objectives and will determine those times when it is appropriate to access these resources and which times access to these resources will be restricted in order to better focus on course outcomes and class objectives which don’t require access. If students are found using the Web inappropriately or at those times that the instructor has restricted access, the same penalties listed below under “Personal Use of Internet Resources” will apply.

Personal Use of Internet Resources

Web access is for course work only. At the beginning of a class session, Facebook and other social media, instant messaging, and/or any other personal use of the Web is prohibited. If you are found using the Web for personal use during class time you will be issued a warning, and if found repeating personal usage, you will be dismissed from the class for a day. A third offense will result in dismissal from the course.

Faculty Prerogative

Classroom faculty may choose to include specific language in a Course Syllabus or Outline which further defines the acceptable use within their classroom. These statements will be considered sanctioned by the CIT Program and will fall within the guidelines of this policy.

Dynamic process Statement: Due to the dynamic nature of change within application software and the internet based environment that we work in, slight modifications to assignment content, points, and or due dates may be necessary as we progress throughout the semester. Students will be notified as soon as possible and given ample opportunity to respond to any changes that may be required.

Class Attendance/Participation


Extra Credit

Extra credit may be available in this course. This information is provided by the section instructor.

Institutional Policies

Transfer Potential

For transfer information, please consult the LCC Transfer webpage.  In addition, the Michigan Transfer Network website allows students the ability to search courses and discover how those courses transfer to colleges and universities statewide.

The Michigan Transfer Agreement (MTA) simplifies the transfer of students from one Michigan institution to another. For the most current information, see the LCC General Education webpage.

For additional transfer information contact the Academic Advising Center in the Gannon Building - Star Zone, (517) 483-1904.

Disability Statement

Students with disabilities who believe that they may need accommodations in this class are encouraged to contact the Center for Student Access, Gannon Building, Star Zone - Center for Student Support, via the Center for Student Access website, or by calling (517) 483-5323 as soon as possible to better ensure that such accommodations are implemented in a timely fashion.

Student Code of Conduct and General Rules and Guidelines

LCC supports a positive learning environment that provides opportunities for student success. The College recognizes the value and importance of a safe and orderly learning environment that encourages honesty, integrity, and ethical conduct. The Student Code of Conduct and General Rules and Guidelines ensure the protection of student rights and the health and safety of the College community, as well as aid in the efficient operation of College programs. In addition, the College has established procedures for addressing reports of alleged violations.                 

It is the responsibility of the student to be familiar with, and abide by, the Student Code of Conduct, as well as the General Rules and Guidelines. Furthermore, the instructor may establish reasonable guidelines within the classroom environment. Violations of the Student Code of Conduct and General Rules and Guidelines may be reported to the Office of Student Compliance.

Enrollment Verification

Class attendance and participation are essential to student success. Instructors will update class rosters by the 8th day after the start date of sections less than 8 weeks long, and by the 15th day after the start date of sections 8 weeks or longer to accurately reflect student enrollment in each course. Students who have not attended by these dates may be administratively dropped and responsible for any required tuition and fee charges.

Academic Success Coaches

At Lansing Community College, student success is our top priority.  Our Academic Success Coaches mentor students to help them meet their educational, personal and career goals.  LCC faculty or staff may refer you to an Academic Success Coach if they recognize that mentoring or assistance may be helpful to you. Please monitor your LCC email for referral notifications.  Your participation in academic success coaching is voluntary.

In addition, we encourage you to contact an Academic Success Coach on your own if you need help, guidance or assistance to reach your goals.  To contact an Academic Success Coach, call (517) 483-1422, email [email protected], or visit the Academic Success Coaching Team website for more information.

Nondiscrimination Statement

Lansing Community College is committed to providing equal employment opportunities and equal education for all persons regardless of race, color, sex, age, religion, national origin, creed, ancestry, height, weight, sexual orientation, gender identity, gender expression, disability, familial status, marital status, military status, veteran’s status, or other status as protected by law, or genetic information that is unrelated to the person’s ability to perform the duties of a particular job or position or that is unrelated to the person’s ability to participate in educational programs, courses services or activities offered by the college.

The following individuals have been designated to handle inquiries regarding the nondiscrimination policies: Equal Opportunity Officer, Washington Court Place, 309 N. Washington Square Lansing, MI 48933, 517-483-1730; Employee Coordinator 504/ADA, Administration Building, 610 N. Capitol Ave. Lansing, MI 48933, 517-483-1875; Student Coordinator 504/ADA, Gannon Building, 411 N. Grand Ave. Lansing, MI 48933, 517-483-1885; Sarah Velez, Human Resource Manager/Title IX Coordinator, Administration Building, 610 N. Capitol Ave. Lansing, MI 48933, 517-483-1874; Christine Thompson, Student Title IX Coordinator, Gannon Building, 411 N. Grand Ave. Lansing, MI 48933, 517-483-1261.

Compliance with COVID-19 Safety Precautions

All students, employees and visitors have a part to play in keeping the LCC community safe.  Everyone entering campus is required to adhere to the safety measures as outlined on the Spring Refresh 2021 webpage. Reports of noncompliance will be submitted to the Student Compliance Office for appropriate action.  Students with questions or concerns should email [email protected].

Media Release Statement

Photographs, pictures, slides, movies, video, or other media coverage of students may be taken for College-related business, in connection with their enrollment or participation in LCC activities without compensation from LCC, its Trustees, officers, directors, employees, students and agents of each of them, and photographs, pictures, slides, movies, video, or other media coverage of students may be used for any legal purposes.

Additional Items