Microsoft Access 2016 (Levels I,II,III)
Contact Hours: 24 (an estimated time frame devoted to a course of study from start to finish that can vary from student to student)
Microsoft Access is now much more than a way to create desktop databases. It’s an easy to use tool for quickly creating browser based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues. This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided in to three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.
System Requirements:
Internet Connectivity Requirements:
Cable and DSL internet connections are recommended.
Hardware Requirements:
Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
256MB RAM minimum. 1 GB RAM recommended.
800x600 video resolution minimum. 1025x768 recommended.
Speakers/Headphones to listen to Dialogue steaming audio sessions.
A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
Windows Vista, 7, 8, 8.1
Mac OSX 10 or higher.
OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
Google Chrome is recommended.
Firefox 13.x or greater.
Internet Explorer 6.x or greater.
Safari 3.2.2 or greater.
Software Requirements:
Adobe Flash Player 6 or greater.
Oracle Java 7 or greater.
Adobe Reader 7 or greater.
Web Browser Settings:
Accept Cookies
Disable Pop-up Blocker.
Upon successful completion, students will be prepared to proficiently use Microsoft Access 2016 training for beginner, intermediate & advanced levels.
Visual Demonstrations & Multimedia Presentations - Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. We always focus on real world scenarios and skill-set development.
Quizzes & Exam Simulators - The custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.
Access Beginner
1.1 Introduction Part 1
1.2 Introduction Part 2
1.3 Elements Part 1
1.4 Elements Part 2
1.5 Reviewing Data
1.6 Queries Part 1
1.7 Queries Part 2
1.8 Tracking Time Part 1
1.9 Tracking Time Part 2
1.10 Tracking Time Part 3
1.11 Design Work With Forms
Access Intermediate
1.1 Relationships Part 1
1.2 Relationships Part 2
1.3 Changing Information
1.4 Loading Tables
1.5 Relating Invoices Part 1
1.6 Relating Invoices Part 2
1.7 Relating Invoices Part 3
1.8 Relating Invoices Part 4
1.9 Time Entry Form
Access Advanced
1.1 Queries Part 1
1.2 Queries Part 2
1.3 Queries Part 3
1.4 Queries Part 4
1.5 Reports Based On Queries
1.6 Adding Additional Information
1.7 Update Query Part 1
1.8 Update Query Part 1
1.9 Creating A Report From Scratch Part 1
1.10 Creating A Report From Scratch Part 2
1.11 Creating A Report From Scratch Part 3