reed.co.uk Courses

Header

Microsoft Access 2016 - Beginner to Advanced


EduCBA

Summary

Price
£10 inc VAT
Study method
Online, self-paced
Qualification
No formal qualification

1 student purchased this course

Add to basket or enquire

Overview

One gets accosted with data wherever he goes. Be it office, classroom or mart, data greets us in the form of costs, statistics, market quotient etc. Managing this data is of utmost importance. Microsoft’s Access brings a breather. It is a tool that creates ease in data management.

Access 2016 comes with all the functions and characteristics one may have already used in the prior versions of Access. It also has some novel features from Microsoft Office 2016. You can learn to get a hold over your data. This course will take you through a journey that will help you to tap the potential of Microsoft Access 2016. You will learn to organize, amend, and control thousands of records.

Before the advent of Access, Borland (in the form of Paradox and dBase) and Fox (through FoxPro) were leaders in the database market. Windows entered the market with Microsoft Access. After Microsoft acquired FoxPro in 1992 and incorporating Fox’s Rushmore query optimization routines into Access, Microsoft Access instantly became the dominant database for Windows. It efficiently delineated the rivalry that botched to change from the MS-DOS world.

In 1992 Microsoft announced the release of Access version 1.0 on 13 November 1992. Access 1.1 was released in May 1993 to improvise favorability with other Microsoft products and to incorporate the Access Basic programming language. In due course of time, Microsoft came up with newer versions of Access consisting of enhanced database size and improved network reliability.

Apart from its own database storage file, Microsoft Access also finds its applications as the ‘front-end’ of a program whereas other products such as Microsoft SQL Server as well as Oracle and Sybase function as the ‘back-end’ tables. Several backend sources can be used by a Microsoft Access Jet Database. Also, few applications – Visual Basic, ASP.NET, or Visual Studio .NET – employ Microsoft Access database format for their tables and queries. Microsoft Access is also likely to be a part of network, wherein it could undergo merger with other technologies such as Microsoft Excel, Microsoft Outlook, Microsoft Word, Microsoft PowerPoint and ActiveX controls.

Access tables comprise of a wide range of field types such as indices, cascading updates and deletes. It also has a query interface, forms, enter data, and reports for printing. Repetitive tasks could be programmed through macros with point-and-click options. It is also possible to position a database on network and have multiple users share and update data by being in their own zone. In MS access, data is locked at the record level which is way different from Excel where the entire spreadsheet gets locked.

Microsoft Access played a restricted role in web development prior to 2010. User interface features of Access, such as forms and reports, work only in the Windows. The Microsoft Jet Database Engine, which forms the central part of Access, can be retrieved through technologies such as ODBC or OLE DB. The data comprising of tables and queries are accessible through web-based applications developed in ASP.NET, PHP, or Java. Through Microsoft’s Terminal Services and Remote Desktop Application in Windows Server 2008 R2, organizations are able to host Access applications to be run over the web. Access 2010 allows databases to be published to SharePoint 2010 web sites running Access Services. These web-based forms and reports run in any modern web browser. Access 2013 – a more vigorous version than Access 2010 could create web applications in SharePoint 2013 sites with Access Services.

Description

Join the Advance Access 2016 course from EduCBA and learn advance functions in Access and learn to store and modify data more effectively. You will learn how to build relational databases, customize data according to the requirements of analysis, various specialty or action queries, ways to minimize data entry errors by building buttons in forms, applications of access, automating data using macros.

The tutorials will help you learn the following in detail.

  • Create tables

The first section starts with the basics and will teach you to create a table with application parts and field properties present on the table tools menu. One can make the table and also choose an area in the current database or another one to place the table. We will teach you to make a query by also providing information on types of queries possible in MS Access.

  • Make table queries

This section will update you further on the types of queries such as Crosstab query, Union Query Statistical Query and few others along with their applications. For instance, a Make Table query generates a new table as a product of the query, rather than merely showing a query result. It could be used as a basis for other queries, act as a backup for data. It can also be used to display selected information from several tables in a single table which can be further exported to Microsoft Excel for examination in spreadsheets.

  • Designing forms:

Access 2016 offers us several options for creating forms. The way reports and queries are categorized; forms are also named and saved in the database file. Forms are essentially Access tools and one can tweak them to meet your specific needs.

On the basis of your needs, forms can be generated in several ways. Form can be customized by using the Form tools, Form Wizard, Form Design functions. One can create a form, control field selection and also style it as per one’s requirements.

Designing forms wherein we will learn about various form controls, Input Boxes, Record Navigation, Adding Buttons, Setting the tab order, Multiple forms and Split forms.

  • Reports:

Reports in Microsoft Access database present a method to view, configure, and review the information. For instance, one can make a report of phone numbers with all the contacts, or a summary report reflecting total sales from different regions and time zones. Report is an important tool in Access, which works conveniently when one has to process the information in database to display the summary of data, store visuals of the data, supply details of individual records or to create mailing labels.

The structure of a report is categorized into sections that can be viewed in the Design view. By learning how each section works can help one to create enhanced reports.

  • Use of Macros

The versions after MS Access 2010 have macro as an added introduction to enable enhanced web integration. Since then, macros have gained power as well as flexibility.

Nonetheless, all macros are not considered safe and certain keywords are also banned that were originally not functional in the macro view.

In Access 2016, a new or existing macro can be made through the Navigation pane that enable to publicize macros or it can be made with Access tools such as a form or report which offer privacy to the macros.

Whenever a person intends to perform any action after opening the Access database, one needs to create an AutoExec macro in the desktop database. We will train you to learn how an AutoExec macro can maximize the application window, lock the navigation pane and open a certain report every time you open a database.

  • Connecting HTML to MS Access

A data access page comes in the HTML format with an Office Web Component set in it. The Office Web Component collects connection information regarding a data source. In this last section on training, we teach you to use data access pages in order to connect an HTML page to tables in a database.

We will teach you methods to create the Data Access Page by Using the Wizard and with the help of an Existing HTML Page.

Lastly, we can view other applications in Access, which teach us about Publishing in HTML or XML, sharing through email or data analysis tools, as well as encrypting the database and splitting it.

Who is this course for?

Ideally this course can serve well MBA holders, graduates in business administration, and students from commerce background. However, this is not a rule. Students from any background can do this course. This course is made for students willing to learn intermediate-level skills. It will benefit those constructing relational databases, performing database maintenance, or creating advanced queries and reports. Any professional from a business background as well as finance analyst, market researchers and bankers can benefit from this course. Also those wanting to go a step ahead of earlier Access versions can do this course.

Requirements

This course is intended for students who are specifically interested to build a basic understanding of Microsoft Office Access 2016, including the skills required to create a new database, data tables, create forms and reports, and also learn queries.

A basic knowledge of MS Access will enable you to gain advanced concepts of Access 2016 taught in our course. It will also help to have a passion for the subject and also an interest to practically apply tenets of MS Access. A computer with internet connection can help to view training material.

Questions and answers


No questions or answers found containing ''.


AK asked:

Please advise whether this course prepares for the MOS Access 2016 exam (77-730). How many hours is the training ? Thanks !!

Answer:

Hello, Our course covers major functions and features of Microsoft Access 2016 from scratch with examples. The course though has not been prepared from the perspective of this certification. Please check our curriculum and match it with the exams, it might help you. Thanks Aatish

This was helpful. Thank you for your feedback.

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals