A database is a well organized collection of data . With a database,
data can easily be accessed, managed, and updated. Relational
databases are the most commonly used database today. In this hands-on
instructor-led online training course, you will learn the basics of a
databases using Microsoft Access. This course is highly recommended
for students interested in the PHP, ColdFusion MX, ASP and JSP
training programs.
|
Day 1:
The Basics
- Understanding Databases
- Database Tables
Fields and Records
- Getting Started with Microsoft Access
- Creating a blank Access database
- Understanding Access database wizards, pages, and projects
- Opening an existing database
- Converting to other versions of Access
- Understanding the Microsoft Access Workspace
- The Database Window
- Exploring the Short-Cut Menu
- Customizing the toolbar
- Exploring other options available with Microsoft Access
- Course Lab Exercises
- Review Exercises
- Course Homework Assignment
Day 2: Tables
- Creating a table in design view
- Creating a table using the table wizard
- Creating a table by entering the data
- Introduction to datatypes
- Understanding a primary key
- Field validation rules
- Input masks
- Switching views
- Editing records
- Deleting records
- Adding and deleting columns
- Saving a table
- Resizing rows and columns
- Freezing columns
- Check spelling and autocorrect
- Printing a datasheet
- Lab Exercises
- Review Exercises
- Course Homework Assignment
Day 3(Part 1): Table Relationships
- Understanding the importance of a good table design
- Introduction to table relationships
- Building table relationships
Day 3(Part 2): Course Hands-On Live Project
- Research Project
- Final Course Project
Benefits Explained:
Instructor-led Training: Students can choose either our
Instructor-led self-paced training or our Instructor-led one-on-one
training. Both training choices guarantee students instructor
feedback, evaluation and course concept clarification. Students
registering for the Instructor-led one-on-one training will have
telephone, instant messenger/net conferencing, and email access to
their instructor. Students registering for the Instructor-led
self-paced training will have email access to their instructor.
Live server space: We provide students access to Web servers
running PHP, ASP, and ColdFusion MX. These servers are available to
all registered students for the duration of the course at no
additional cost. All students are required to upload their
homework assignments to the school server. Instructions on how to
upload homework assignments are provided by the school.
Convenient Schedule: Our training requires no time and place
commitments. Students can access course lectures, projects,
homework assignments, and other course resources at any time. Access
is granted 24 hours a day, 7 days a week.
Instructor Support: Our instructors are available to answer
questions on course topics, homework assignments, projects and other
course related issues. Instructor Support is available on weekdays
between 9am and 4pm Eastern Standard time. Instructors usually
respond with in a 2-6hour time frame.
Course/Program Certificate: The Internet Learning Institute issues
a certificate of completion to students who successfully
complete their course. Completion of the course is based on the
completion of the final project. The final project usually includes
all concepts covered in the course lectures.
Grade Report: We maintain a grade reporting system.
Students are generally graded for homework assignments and final
projects. Students are emailed updated reports as homework assignments
and projects are evaluated by instructors.
Instructor Homework Evaluation and Final Project Evaluation: Our
Instructors evaluate, grade and provide feedback on all homework
assignments and projects. Evaluation, grading and feedback is
generally based on coding
techniques, presentation, mastery, comprehension, utilization and
application of course lecture concepts. We always encourage our
students to go above and beyond the project requirements.
|
Software Requirement: Microsoft Access 97 or
higher Got
Questions?
Click Here
Ready to Register?
Click Here
Prerequisite:
* Basic Computer Skills
*Students are strongly encouraged to review
prerequisite course requirements. Adequate knowledge of prerequisite
courses provide a solid foundation for successful participation in
this course.
Benefits:
-
Instructor-led Online Training
- Live
server space
-
Convenient Schedule (No place or time commitment)
-
Instructor Support
-
Course/Program Certificate
-
Grade Report
-
Official Transcript
- Instructor Homework Evaluation
- Instructor Final Project
Evaluation
About Jumpstart Courses
Jumpstart courses are designed to target specific topics and
project areas. Instructors use extensive homework assignments
and projects to reinforce lecture topics.
Students must meet homework, lab, and final
project requirements before the course certificate is issued.
Homework assignments and projects are evaluated
based on coding techniques,
presentation, mastery, comprehension, utilization and
application of course lecture concepts.
Multiple Registrations:
Note that multiple registrations are only allowed with company
purchase orders. School policy generally requires that students
register for one course at a time.
How to use
your personal project as a basis for your final course project:
The school allows the use of a personal project as a basis
for a final project. This option is excellent for students
working on related projects. Students are required to submit a
project proposal to their instructor for approval. Instructors
review project proposals to ensure that they are within the
course limits and to ensure that the incorporate all concepts
learned in the class.
Note:
All students registered for Jumpstart courses have one month to
complete their course load. Students who take longer than a
month will be considered dormant. A dormant student is a student
who has failed to complete the required course work within the
allowed period. Dormant students are required pay a course
reactivation fee of half (50%) of the current tuition. |
|