Jumpstart Training

• Targeted
• Fast
• Affordable
• 100% Hands-on
• 100% Instructor-led
• No Time Commitment
• No Place Commitment

View all courses

Do you have a related personal or work project you are working on? If you do, you can discuss your project with your instructor and request to use it as a basis for your course final project. Note that the project must be within the course limits and it must include all the concepts covered in class.Get trained anywhere in the world! The Internet Learning Institute is a 100% Hands-on Instructor-led online training school. All our courses are conveniently offered online with no time or place commitments. Does your employer want to pay for your classes? Find out how we can get you started right away and bill your employer directly Details

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 TablesFields 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
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.