 |
Access Advanced Onsite Group Training Course |
Course Description:Overview
- Expand on basic Access® skills with advanced relational database techniques
- Use normalization to improve data structure and integrity
- Create powerful and dynamic queries and reports
- Implement forms with logic, automation, and validation
- Learn to manage, document, and optimize databases
- Prepare for Microsoft Office Specialist (MOS) Access certification
- Normalize data using junction tables and improved table structures
- Create joins, subdatasheets, subqueries, and action queries
- Design enhanced reports with calculations and subreports
- Add logic and interactivity to forms using conditional formatting and controls
- Validate data entry at the field, form, and record level
- Build macros for task automation and improved UI design
- Manage object dependencies and document database architecture
- Students looking to gain intermediate to advanced Access skills
- Professionals responsible for creating, maintaining, or integrating Access databases
- Individuals preparing for the Microsoft Office Specialist (MOS) Access exam
- Completion of Access Introduction Course or equivalent experience
Access Advanced - Course Syllabus
Warning: include(oisyllabus/onlc-access16-adv.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
Warning: include(oisyllabus/onlc-access16-adv.php.php): failed to open stream: No such file or directory in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
Warning: include(): Failed opening 'oisyllabus/onlc-access16-adv.php.php' for inclusion (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/busin148/public_html/includes/microsoft-onsite-instructor-classes.php on line 49
How On-Site Training Works
How On-Site Training Works
- Discuss your team's educational needs with a BCS representative.
- Schedule class date(s) that fit your team's availabilty.
- Professional Trainer will conduct the class at your facility or online.
- We provide the instructor, instructor travel and lodging, training manuals and digital practice for each student.
- You provide the meeting/conference room, student xomputers with correct software installed and a projector for the instructor to use.
- Usually a two-week lead time to schedule a class.
- Classes normally run from 9am-4:30pm local time, but can be adjusted to fit your schedule.
- 1 Hour Lunch Break, and Two 15-minute Break
On-Site access Training Packages
Small Group Package (up to 6 students)
- A Professional Instructor will come to your office and train your students
- Up to 6 students can attend the class for the flat rate course price of $1800/day
- Additional students can be added for $125/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
Total Cost for 6 students: $1800/day (Flat Rate)
Medium Group Package (up to 12 students)
- A Professional Instructor will come to your office and train your students
- Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
- Additional students can be added for $100/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
Total Cost for 12 students: $2500/day (Flat Rate)
Large Group Package (up to 18 students)
- A Professional Instructor will come to your office and train your students
- Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
- Additional students can be added for $75/person/day
- Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
- Course is scheduled based on dates you provide (Subject to instructor availability)
- We usually require about 2-weeks lead time to arrange a training session
- Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
- Two 15 minute breaks and one hour long break for lunch
Total Cost for 18 students: $3100/day (Flat Rate)
Related On-Site Training Courses
access Self Paced On-Demand Courses
On-Site Training Request
Please complete the information request form below, and one of our representatives will contact you within one business day.
"Great class!! Clear explanations of complex topics. I could repeat lessons as many times as needed to make sure I mastered them."
- Thomas L(Akron, OH)
