New members: get your first 7 days of ITTutorPro Premium for free! Join for free

Microsoft Access 2016

Course Description

9.02Hours

31 Videos

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.

Share on:

Course Syllabus

Access 2016 Basic

  1. Introduction Part1
  2. Introduction Part2
  3. Elements Part1
  4. Elements Part2
  5. Reviewing Data
  6. Queries Part1
  7. Queries Part2
  8. Tracking Time Part1
  9. Tracking Time Part2
  10. Tracking Time Part3
  11. Design Work With Forms

Access 2016 Intermediate

  1. Relationships Part1
  2. Relationships Part2
  3. Changing Information
  4. Loading Tables
  5. Relating Invoices Part1
  6. Relating Invoices Part2
  7. Relating Invoices Part3
  8. Relating Invoices Part4
  9. Time Entry Form

Access 2016 Advanced

  1. Queries Part1
  2. Queries Part2
  3. Queries Part3
  4. Queries Part4
  5. Reports Based On Queries
  6. Adding Additional Information
  7. Update Query Part1
  8. Update Query Part2
  9. Creating A Report From Scratch Part1
  10. Creating A Report From Scratch Part2
  11. Creating A Report From Scratch Part3

Microsoft Access 2016 earners have an understanding of the Access environment. They understand basic database design principles and the correct application of the principal features of Access 2016. Earners can create and maintain basic Access database objects including tables, relationships, data entry forms, multi-level reports, and multi-table queries. Access earners may include small business owners, mid-level managers, business professionals, students and others.

Microsoft Access (or MS Access) is bundled as part of the Microsoft Office suite. It is only available on the PC version.

Access has traditionally been known as a desktop database system because its functions are intended to be run from a single computer (as opposed to a client/server system where the database application is installed on a server, then accessed from multiple client machines) across a network.

However, Access also includes a web solution (for building “custom web apps”) that is integrated with SQL Server — a more powerful database product, also from Microsoft) — for a more robust solution.

When you save a database in Microsoft Access, it is saved with a .accdb extension. This is the file extension you will use the most when developing Access databases. Older Access databases used an .mdb extension or sometimes a .mde extension, but in 2007, Microsoft started to phase these out in favor of the .accdb extension. If you’re unable to open an older database, you may need to convert to .accdb first using an older version of Access.

The Microsoft Access 2016 Security Technical Implementation Guide (STIG) is published as a tool to improve the security of Department of Defense (DoD) information systems.

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft® Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

In this course, you will create and manage an Access 2016 database.
You will:

  1. Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  2. Organize and manage data stored within Access tables.
  3. Use queries to join, sort, and filter data from different tables.
  4. Use forms to make it easier to view, access, and input data.
  5. Create and format custom reports.

$199.00

  • Vast selection of courses and labs Access
  • Unlimited access from all devices
  • Learn from industry expert instructors
  • Assessment quizzes and monitor progress
  • Vast selection of courses and labs Access
  • Blended Learning with Virtual Classes
  • Access to new courses every quarter
  • 100% satisfaction guarantee

You Will Get Certification After Completetion This Course.

Instructor Led Lectures
All IT Tutor Pro Formerly It Nuggets Courses replicate a live class experience with an instructor on screen delivering the course’s theories and concepts.These lectures are pre-recorded and available to the user 24/7. They can be repeated, rewound, fast forwarded.
Visual Demonstrations, Educational Games & Flashcards
IT Tutor Pro Formerly It Nuggets recognizes that all students do not learn alike and different delivery mediums are needed in order to achieve success for a large student base. With that in mind, we delivery our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.
Mobile Optimization & Progress Tracking
Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded.
Practice Quizzes And Exams
IT Tutor Pro Formerly It Nuggets Online’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure you are confident on the topic you are learning.
World Class Learning Management System
IT Tutor Pro Formerly It Nuggets provides the next generation learning management system (LMS). An experience that combines the feature set of traditional Learning Management Systems with advanced functionality designed to make learning management easy and online learning engaging from the user’s perspective.

Frequently Asked Questions

How does online education work on a day-to-day basis?
Instructional methods, course requirements, and learning technologies can vary significantly from one online program to the next, but the vast bulk of them use a learning management system (LMS) to deliver lectures and materials, monitor student progress, assess comprehension, and accept student work. LMS providers design these platforms to accommodate a multitude of instructor needs and preferences.
Is online education as effective as face-to-face instruction?
Online education may seem relatively new, but years of research suggests it can be just as effective as traditional coursework, and often more so. According to a U.S. Department of Education analysis of more than 1,000 learning studies, online students tend to outperform classroom-based students across most disciplines and demographics. Another major review published the same year found that online students had the advantage 70 percent of the time, a gap authors projected would only widen as programs and technologies evolve.
Do employers accept online degrees?
All new learning innovations are met with some degree of scrutiny, but skepticism subsides as methods become more mainstream. Such is the case for online learning. Studies indicate employers who are familiar with online degrees tend to view them more favorably, and more employers are acquainted with them than ever before. The majority of colleges now offer online degrees, including most public, not-for-profit, and Ivy League universities. Online learning is also increasingly prevalent in the workplace as more companies invest in web-based employee training and development programs.
Is online education more conducive to cheating?
The concern that online students cheat more than traditional students is perhaps misplaced. When researchers at Marshall University conducted a study to measure the prevalence of cheating in online and classroom-based courses, they concluded, “Somewhat surprisingly, the results showed higher rates of academic dishonesty in live courses.” The authors suggest the social familiarity of students in a classroom setting may lessen their sense of moral obligation.
How do I know if online education is right for me?
Choosing the right course takes time and careful research no matter how one intends to study. Learning styles, goals, and programs always vary, but students considering online courses must consider technical skills, ability to self-motivate, and other factors specific to the medium. Online course demos and trials can also be helpful.
What technical skills do online students need?
Our platform typically designed to be as user-friendly as possible: intuitive controls, clear instructions, and tutorials guide students through new tasks. However, students still need basic computer skills to access and navigate these programs. These skills include: using a keyboard and a mouse; running computer programs; using the Internet; sending and receiving email; using word processing programs; and using forums and other collaborative tools. Most online programs publish such requirements on their websites. If not, an admissions adviser can help.
preloader