|
Courses >
Computer Applications > Introduction to Microsoft Access 2003
Syllabus:
All
courses run for six weeks, with a two-week grace period at the end. Two
lessons are released each week for the six-week duration of the course.
You do not have to be present when the lesson is released, but you must
complete each lesson within two weeks of its release.
A new
section of each course starts on the second or third Wednesday of each
month. If enrolling in a series of two or more courses, please be sure
to space the start date for each course at least two months apart.
| Week One |
| Wednesday - Lesson 01 |
Creating a Table: the Basics
|
| Friday - Lesson 02 |
Creating Tables: Customizing Fields
|
| Week Two |
| Wednesday - Lesson 03 |
Creating Relationships Between Tables
|
| Friday - Lesson 04 |
Creating Custom Data Entry Forms: Part 1
|
| Week Three |
| Wednesday - Lesson 05 |
Creating Custom Data Entry Forms: Part 2
|
| Friday - Lesson 06 |
Adding Controls to a Data Entry Form
|
| Week Four |
| Wednesday - Lesson 07 |
Performing Queries on Your Tables
|
| Friday - Lesson 08 |
Creating Basic Reports
|
| Week Five |
| Wednesday - Lesson 09 |
Advanced Reporting Techniques
|
| Friday - Lesson 10 |
Super Advanced Reporting Techniques
|
| Week Six |
| Wednesday - Lesson 11 |
Automating Access with Macros
|
| Friday - Lesson 12 |
Exporting Access Tables to Word
|
This
course includes a knowledgeable and caring instructor who will guide
you through your lessons, facilitate discussions, and answer your
questions. The instructor for this course will be Craig Power.
 Craig
Power has worked in adult continuing education for more than 18 years.
A UCLA graduate, he created custom accounting software for state and
local governments; developed an online course delivery and marketing
platform currently used by more than 1,500 colleges and universities in
the US, Canada, and Australia; developed an interactive cellular
biology video for the Los Angeles Unified School District; taught
college-level information technology courses; started and grew a
thriving small business; and served as an executive with a large
academic publishing corporation.
Requirements:
Microsoft Windows XP or 2000, Microsoft Access 2003 or Microsoft Office Professional Edition 2003
(please be sure to install this software on your computer before the
course begins), Internet access, e-mail, and the Microsoft Internet
Explorer or Mozilla Firefox Web browser.
Note: Microsoft Word 2003 or Microsoft Office Professional Edition 2003 will also be required for Lesson 12.
This course is not suitable for Macintosh users, nor for users of any of the 2007 versions of MIcrosoft Access.
Student Reviews:
"A terrific course--I liked the presentation."
"Great class, very useful & practical to my work."
"Great course! I had no idea there was so much "meat" to
Access--what I learned will come in handy for the database I need to
create for a non-profit organization, which will have to handle a lot
of information. I enjoyed how the "basic functions" were described
throughout the lesson, so as to drill them into my auto-response
system--and so as not to assume I would remember from one lesson to the
last."
"I am thankful to have the opportunity to take this course
through Ed2Go. I am able to study the lessons at my own pace in an
environment that is conducive for my learning style. The instructor was
great and I would recommend him to others."
"I enjoyed the class very much. I thought it moved a bit
slow at first but after consideration I realized it probably fit into
my schedule so well because of its pace. After each lesson I was
anxious to learn more. I use an Access based program at my job and am
anxious to experiment with a copy of the store's database. I don't
think I'm ready to mess with the real thing! I'll be back for more
lessons! Thanks for offering a well prepared and thorough course."
"I found the material easy to follow and thought the content
contained pertinent information to begin working with Access databases.
In the discussion area, I was able to find a resolution to an issue I
ran across. I plan to continue taking more advanced classes as time
permits. Thank you for the opportunity to make my job easier!"
"I liked how instructor Craig Power writes each lesson in an
easy-to-read and humourous format. The way the lessons were designed
was excellent. The method of making a database owned by the fictional
company and all the activities we did related to the company was very
engaging for the student."
"I loved the course! I feel that I now understand the basics of Access, which is what I wanted to get out of the course."
"Instructor for this class was awesome -- his style of
writing was perfect for me. The lessons got to the point quickly and
helped you understand the functions of the program using examples and
example problems."
"I really enjoyed the class and interacting with everyone
online. It was one of the "easier" classes I've taken! The instructor
was awesome and was very helpful in getting us through the lessons by
using humor and simplicity for everyone to understand."
"I thought this was simply excellent. I have taken other
online courses, and none have compared to this. I highly recommend it,
and I've already let our library system know!"
"Liked the class. Tried to take Access [elsewhere] and felt
lost. This time I actually understood it. The discussion area helped me
when I was puzzled. Thanks too for your sense of humor - it helped!"
"Second class through this instructor. I really like the way
he presents the information and will highly recommend him to others."
"Thank you, I enjoyed taking the course online. It allowed
me to work when I had the time. The instructor has a friendly style and
was easy to work with. I will take other courses from him and recommend
him to others."
"The course was very enlightening. The instructor is
excellent he attempts to reinforce the lessons with a related
assignment which helps you to remember the material covered."
"The Instructor is very helpful and ready to assist all the time."
"This class was essential in helping me maintain our new
Access Data Base for New Student Orientation. I have learned so much.
Our office is functioning more efficiently as a result of this course.
Thank you!"
"This course came to me highly recommended. Now I know why. Thank you for the opportunity."
"This course is very usful for me, I was eager to know
Access and I got a good chance by joining it. during the course time I
felt asif I am in a class room and talking to the instructor face to
face. It was wonderful, specially the discussion area. Great work!!!!
Keep it up."
"This course really filled my need at the right time, and it
was very "user friendly". It also allowed me to work at my own pace and
in my own time-frame. Thank you!"
"This course was a lot of fun. I learned a lot, and it has
already proven to be useful to me on my current job. I intend to take
the Intermediate class, and hope to find the experience as positive as
this one has been."
"This course was clear, concise and helpful. Encore!"
"This course was very helpful to me...it helped me
understand the 'disconnects' I had with how Access works. I'm so happy
that it was available online because I did not have the time to sit in
a classroom to learn it."
"This course was very well laid out for a online course.
Very easy to follow and anyone would be able to learn from it. I've
taken many online courses and was very impresssed with the simplicity
of instruction."
"This is the first time I have taken an online course, and
it turned out to be a very enjoyable experience. I liked the fact I
could progress at my own pace, and that it elminated the traditional
classroom problem of repeatly getting off the subject. That can be
particularly confusing when you are trying to learn a new software
program! Thank you for a great experince!"
"This is the first time I have taken an on-line course and I
was very pleased. I feel as though I have learned enough to at least
start working with Accsess. I felt the instructor was very thorough and
appreciated his sense of humor. In other words, the class was
interesting and helpful, not dry."
"This is the fourth ed2go course I have completed. It is by far the best one yet."
"This was an excellent introduction to many of the powerful
features in Access. I feel more than equipped to work with basic
databases and greatly intrigued to learn more."
"This was a terrific course...easy to follow, filled with
information and fun. This took the ??? out of Access and provided
within the 6 week period the skills to create a professional type
database. Coupled with the information given, your own creativity can
produce just about any look and feel you want."
"This was my first online course and other than life getting
in the way I enjoyed this format very much. It was so nice to not have
to attend class, but instead do it at my own pace when it was
convienient for me. Thank you for offering this."
"This was my first online course, I feel the instructor did
an excellent job. Even though we were online, I felt I was interacting
with the instructor. Taking this course has encouraged me to take more
courses online. I highly recommed this instructor."
"We have an Access database for my church and no one knew
how it worked. By taking this course I not only learned how to Work our
database, but now I can improve on it. I recommend this course to
everyone. Whether or not you are good with computers. I learned a lot
and it was a great help."
"Wow! Your course was written with the novice in mind making
it very easy to follow the lessons. Great job! I never got lost as you
had many pictures and documentation that described what to do if you
make an error. I would definitely take another class from you."
To purchase this course, click the Enroll Now button below:
|
Learn
how to use Microsoft's powerful and award-winning database to store,
locate, and print just about any type of important information. In this
six-week online workshop, you'll learn how to create tables,
relationships, custom data entry forms, queries, reports, mailing
labels, and macros. You'll also learn how to merge the data in your
Access tables with Microsoft Word form letters.