[PDF] Syllabus for Microsoft Access Syllabus for Microsoft Access. Course

View - Download Syllabus for Microsoft Access

Previous PDF

Next PDF

Syllabus for Microsoft Access

Course Number and Name: BOT 2333 Microsoft Access

Department/Program: Business and Office Technology

Instructor Name: Ms. Joanna Alston

Instructor E-Mail Address: joanna.alston@mgccc.edu

Semester Credit Hours: 3 Semester Hours (3,2,2)

Prerequisite Course/s: Instructor Approved

Welcome to Microsoft Access! Please read through this syllabus carefully for important information.

COURSE DESCRIPTION

This course applies database concepts for designing and manipulating data files and formatting output

as complex documents and reports using Microsoft Access. The software used for this class is Access

2016 (more on that later).

STUDENT LEARNING OUTCOMES

Upon completion of the appropriate units, you will be able to complete the following:

1. Manipulate database files, and format complex documents and reports.

a. Design and create a database using specific criteria. (1) Open objects in multiple views. (2) Move among records. (3) Create and modify tables. (4) Create lookup fields and modify field properties. b. Modify database file structure and records to produce desired output. (1) Create and modify queries. (2) Enter, edit, sort, filter, and delete records. c. Demonstrate file management techniques. d. Define and create relationships enforcing referential integrity. e. Create, format, preview, and print reports. f. Design, create, and modify custom screen formats. g. Create and manipulate data using multiple databases.

h. Perform mathematical operations, and relate their applications to existing information in a database.

CONTENT OUTLINE

I. Managing and Creating Tables

II. Creating Relationships between Tables

III. Performing Queries

IV. Creating and Modifying Tables in Design View

V. Creating Forms

VI. Creating Reports and Mailing Labels

VII. Modifying, Filtering, and Viewing Data

VIII. Importing and Exporting Data

BOT 2333 Microsoft Access

REFERENCES/TEXTBOOK

Benchmark Series: Microsoft Access 2016 with SNAP and eBook (You cannot substitute another book.) Authors: Rutkosky, Davidson, Roggenkamp, Rutkosky

ISBN-13: 978-0-76386-997-7

Purchasing textbook: The textbook for this course a purchase book. You can purchase this book through the JD Campus bookstore (228-896-2502) if you are an MGCCC student. If you are not an MGCCC student, you can order the book from our campus or buy only the textbook through other sources such as online or other retail bookstores such as Barnes & Noble, Walden Books, etc. The bundle is NOT available through these sources. It is very important that you have your book and software (see below) and are ready to begin the first day of class.

MATERIALS AND OTHER RESOURCES NEEDED

Textbook (described above)

Software: Microsoft Access 2016 - You cannot use another Access version. (See special pricing for students at link below.) http://mgccc.e-academy.com/ Browsers: Internet Explorer 9 or later; Mozilla Firefox; Google Chrome

Student Data Files: These files can be obtained through the textbook resources online via SNAP and are

also available in the course site. Internet access: High-speed access is recommended (DSL or cable).

Email account: Students are to use the school's email address if available. This is the email address I will

use to communicate with you on an individual basis.

COURSE SCHEDULE

A document of important dates is available under Modules.

EVALUATION AND ASSESSMENT METHODS

Evaluation will consist of objective tests, practical tests, and computer assignments. I may add or remove assessment items at any time. However, you will be given sufficient notice.

The first unit of your textbook, Getting Started in Office 2016, should be covered. It is not an assigned

section, but it is very helpful if you have not worked in Access 2016.

Your grades will come from three areas:

under Modules letting you know what is to be submitted. Assignments may come from the Projects found within the chapters or the exercises located at the end of every chapter in the eBook. SNAP will be utilized for completing coursework. Assignments are worth 50 points each. objective. At the end of each chapter are a Chapter Summary and a Commands Review. Be sure to review the commands and online study tools to use as review for tests. You are not to submit

BOT 2333 Microsoft Access

them for grading. Refer to the Important Dates for test dates. Theory tests are worth 50 points each, and performance tests are worth 100 points each. They will be divided as follows: At least one of your tests will be proctored. The information needed to set up your proctored test can be found on MGCCC's eLearning website - http://www.mgccc.edu/elearning/ learn over the course of this semester. The project will be assigned after the second test and will be due just before the Final Exam. Further instructions will be available when the project is assigned.

GRADING SYSTEM

Your grading scale is based on a point system. It is simply a percentage of the points you have earned

points you have earned and divide that number by the total possible points and then multiply by 100. This method will give you your number grade. Use the scale below to look up your letter grade. % of Points Grade

93-100 A

85-92 B

75-84 C

70-74 D

Below 70 F

PARTICIPATION AND ATTENDANCE

Even though this is an online class, attendance is mandatory and will count. Online classes are offered as

a convenience to our students. We realize that different circumstances make it impossible for some

students to attend traditional college classes. Fortunately, the Internet has provided us with a vehicle to

deliver our classes to you in the convenience of your home. In turn, however, you are expected to follow

some basic guidelines and policies to be a successful online student. If you do not log on regularly, you

Therefore, you are expected to log on several times a week (when and where is up to you). Assignment

due dates and tests are listed in the Important Dates file under Modules. It is up to you to abide by

those deadlines. Most students drop or fail online courses because they cannot develop the habit of logging-on to allow themselves enough time to complete assignments by the due dates.

No late work will be accepted! If you fail to turn in an assignment on time, you will be counted absent,

BOT 2333 Microsoft Access

the fourth absence you will be dropped. Remember, if I don't hear from you, I cannot help you. If you

are having problems, please communicate! You can expect to spend about 8 hours (or more) a week (depending on your computer skills) in this

class. This time will include reading the lessons, working the exercises, working on your assignments and

communicating with your classmates and instructor.

INSTRUCTIONS FOR ADDITIONAL HELP

You may contact your instructor anytime by Canvas Inbox, phone (228-897-3763), or e-mail

(joanna.alston@mgccc.edu) for additional help. Your first option of communication with your instructor

should always be Canvas Inbox. For technical support regarding the SNAP program, you must contact their dedicated Tech Support; the number is 1-800-328-1452, or you can contact them through their 24/7 chat services. Visit http://www.snap2016help.com/#!contact-us/weqhx for more information. For technical support regarding MGCCC's Canǀas program, you must contact the 24/7 MGCCC Help Desk; the number is 1-855-308-2755, or you can contact them through their chat services. Visit http://www.mgccc.edu/elearning/technical-support/ for more information.

ACADEMIC INTEGRITY

Dishonesty will not be tolerated! You are expected to do your own work on all assignments and tests.

Violation of this principle constitutes academic dishonesty, and disciplinary action will be taken. At any

time (except during tests) you are allowed and encouraged to communicate with other classmates and your instructor about procedures regarding your exercises. However, you are expected to complete all

of your assignments and tests on your own. If you read the lessons and complete your assignments, you

will not have any trouble with the tests in this course. Any student or students may be required to complete a quiz/exam in a proctored environment at any time throughout the course as deemed necessary by the course instructor.

REASONABLE ACCOMMODATION

Mississippi Gulf Coast Community College is in compliance with Section 504 of the Rehabilitation Act of

1973 as amended and the Americans with Disabilities Act of 1990. Prospective students who require

special and reasonable accommodation(s) because of physical or mental impairment must make their needs known prior to enrollment at Mississippi Gulf Coast Community College. Prospective students

must follow the guidelines in the college catalogue. If you have a disability of any kind and will need

reasonable accommodations or assistance in the classroom or with this course, please see the instructor

the first day of attendance.

EQUAL OPPORTUNITY

Mississippi Gulf Coast Community College is an Equal Opportunity Employer and welcomes students and

employees without regard to race, color, religion, national origin, sex, age or qualified disability. For

further information, contact the Equal Opportunity Officer at a Mississippi Gulf Coast Community College Center, Campus, or the District Office. Compliance is coordinated by the Vice President for

Administration and Finance, Perkinston Campus, P. O. Box 609, Perkinston, Mississippi 39573, telephone

number 601-928-5211.

BOT 2333 Microsoft Access

OFFICE PROFICIENCY ASSESSMENT & CERTIFICATION (OPAC) MGCCC adopted the Office Proficiency Assessment & Certification (OPAC) System for all Business &

Office Technology majors. OPAC is a computerized means of measuring skills utilized in today's digital

office. OPAC exams are now part of your program requirement. Business technical students are required

to complete three OPAC exams during their course of study. A final grade of 68/F is the highest grade a

student will receive in any course where the required OPAC assessment is administered but not taken.

STUDENT RIGHTS AND RESPONSIBILITIES

It is your responsibility to comply with the following: attend class regularly and actively by logging on several times a week complete and submit all required assignments and tests according to posted dates do your own work check your email REGULARLY submit assignments in proper format keep backup copies of your files review microcomputer techniques as required on an individual basis prepare yourself for tests

PROFANITY OF ANY KIND WILL NOT BE TOLERATED

support your classmates to create a conducive learning environment (as you would in the traditional classroom)

It is your right to the following:

A course syllabus

Due dates for tests and other assignments

Grades within a timely manner after due dates (Keep in mind that some classes take longer than others for grading.) Response to your email messages or phone calls by your instructor in a timely manner (Your instructor reserves the right to make changes to this syllabus as needed. Sufficient notice will be given to students if changes are made.)

Again, welcome!

quotesdbs_dbs22.pdfusesText_28

[PDF] ms crm developer jobs in chennai

[PDF] ms crm developer jobs in hyderabad

[PDF] ms crm developer jobs in india

[PDF] ms dynamics crm developer jobs in chennai

[PDF] ms dynamics crm functional consultant job description

[PDF] ms excel 2007 formulas with examples pdf free download

[PDF] ms excel 2007 shortcut keys pdf

[PDF] ms excel 2013 marathi notes pdf

[PDF] ms excel advanced pdf in hindi

[PDF] ms excel advanced tutorial pdf

[PDF] ms excel exercise 2 space weight

[PDF] ms excel formatting exercise

[PDF] ms excel notes in hindi pdf free download

[PDF] ms excel practical assignment questions

[PDF] ms office course material free download