Microsoft Access 2016

Closed Caption

Certificate

Dedicated Tutors

31 Videos
9.02Hours
125 Test Questions

Course Description

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.

Proudly Display Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.

Step-by-Step Courses List

Chapter One:

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
Chapter Two:

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
Chapter Three:

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
Chapter Four:

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.

Chapter Five:

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.

Chapter Six:

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.

Chapter Seven:

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.

$54

Share on:

You Will Get Certification After Completion of This Course.

Frequently Asked Questions

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.

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.

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.

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.

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.
Our platform is 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.

Related Products

Description

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.

Reviews

There are no reviews yet.

Be the first to review “Microsoft Access 2016”

Your email address will not be published. Required fields are marked *