Training

Home/Services/Training

Crystal Reports 2016: Part 1

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report’s presentation.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2016 helps you build advanced reports with ease, presenting complex information in an understandable way.

Crystal Reports 2016: Part 2

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Even though you are familiar with Crystal Reports, you may take some time to study its various tools that enable you to generate reports with the desired data using advanced methods such as SQL querying. This way, you won’t be slowed down by large databases or databases with which you are unfamiliar. By creating sub-reports, crosstabs, and running totals, you will turn raw data into meaningful customized reports that will help your business run more smoothly. If you work with large databases, you may find yourself faced with performance issues. In this course, you will also learn to use tools that can increase the speed with which data is retrieved.

Microsoft Office Access 2016: Part 1

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

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.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Microsoft Office Access 2016: Part 2

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Your training and experience using Microsoft® Access® 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Microsoft Office Access 2016: Part 3

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

You’ve covered many of the basic functions of Microsoft® Office Access® 2016, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today’s training, added to that which you’ve gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

SQL Querying Fundamentals

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server 2012. The language you use to retrieve information from SQL Server 2012 databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

SQL Querying: Advanced

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

In the course SQL Querying: Fundamentals, you learned the basics of SQL querying. Now that you have a foundation in how to query databases, you will learn in this course how to identify and use advanced querying techniques. In addition, you might find that you need to perform tasks such as modifying the structure of a table; inserting, updating, or deleting data; and indexing tables to optimize query performance. In this course, you will learn how to complete these tasks and more.

In today’s competitive environment, information is one of the most important factors in determining the success of an organization. If you are able to manage and retrieve information efficiently, you can streamline the organization’s processes and give it a competitive edge. As the organization grows, you will need to handle large amounts of data. Under such circumstances, you might need to query multiple tables simultaneously and with increasing frequency. You must step up the speed of generating query output to cope with the increasing demands of data storage, management, and retrieval.