header

Computer Training

Data Solutions Plus provides high quality, hands-on
company-dedicated computer training.

Our instructors have many years experience in the classroom as well as in business.
As a result, the material is presented in a manner that is applicable and understandable to the students.

Students receive printed materials that are used during class.
These materials also serve as reference materials after class.

Please contact us to discuss your company's training needs.
Call us at (828) 776-9636,  email us at solutions @ datasolutionsplus.com  or  CLICK HERE.

Our standard class curriculum for Access & Excel is listed below.
Training in additional topics is available.  We can also create a class customized to meet your needs.

Access Level 1

Access Level  1
Database Basics with Access

Click here to view class outline

An introduction to Access and its capabilities. Review the Access Program Screen and Ribbon. Learn how to create and use a database to enter, find, filter and sort information.  After this class you will be able to create tables and queries with confidence. This class is ideal for those working with a database that has already been created, as well as those who want to learn to build a simple database from scratch.

Prerequisite:  Basic knowledge of Windows and Microsoft Office.

Access Level 2

Access  Level 2
Working with Multiple Tables and Intermediate Query Concepts in Access

Click here to view class outline

In this class we will focus on designing and working in a database that contains more than one table.  Learn principles for proper database design, discover multiple methods for creating relationships between tables, and design multi-table queries.  Learn how to create drop-down (“lookup”) lists and become experienced with intermediate query concepts such as parameter queries, concatenated fields and calculations.  

Prerequisite:  Basic knowledge of Microsoft Access

Access Level 3

Access  Level 3
Advanced Database Concepts in Access

Click here to view class outline

Explore more advanced Access database design techniques.  Learn to use field properties to require data entry, create custom date formats, and define input masks.  Understand how to modify drop-down (“look up”) lists.  Work with importing, exporting and linking data between Excel and Access. Discover advanced query techniques such as calculating totals and averages, finding unique values and using action queries to automatically update, delete or append data.   

Prerequisite:  Intermediate-level knowledge of Microsoft Access

Access Forms & Reports

Click here to view class outline

Create user-friendly data-entry forms and professional-looking reports with Access.  Learn formatting techniques.  Add logos and calculations to forms.  Create buttons that open other forms, print reports and perform other automated tasks (macros).  Group, total and sort data in reports. 

Prerequisite: Intermediate-level knowledge of Microsoft Access

Excel Level 1

Excel Level  1
Spreadsheet Basics with Excel

Click here to view class outline

An introduction to Excel and its capabilities. Review the Excel Program Screen and Ribbon.  Learn basic Excel concepts, including navigating, formatting, data entry, data editing, basic formulas.  After this class you will be able to create and work on spreadsheets with confidence. This class is ideal for those working with a spreadsheet that has already been created, as well as those who want to learn to build a spreadsheet from scratch.

Prerequisite:  Basic knowledge of Windows and Microsoft Office.

Excel Level 2

Excel Level 2
Managing Workbooks, Creating Charts and Using Advanced Functions in Excel

Click here to view class outline

This class improves your ability to manage, review and analyze data by familiarizing you with some of the powerful tools that are built into Excel.  Learn how to manage workbooks, create and work with charts, utilize formulas and functions, and create data tables that allow you to sort and filter data in a database-like fashion.

Prerequisite:  Basic knowledge of Microsoft Excel


Excel Level 3

Excel Level 3
Advanced Topics in Excel

Click here to view class outline

Learn advanced Excel topics including interweaving Excel and other Office programs (such as inserting an Excel worksheet into a Word document) and maintaining data links between the documents or between multiple Excel workbooks.  Use advanced functions, perform What-If analysis and develop Pivot Tables and Pivot Charts. Learn to create Excel macros. Gain an understanding of how to automate repetitive tasks and increase productivity. 

Prerequisite:  Intermediate-level knowledge of Microsoft Excel

CONTACT US TO DISCUSS YOUR TRAINING NEEDS:  
Call us at (828) 776-9636 or email us at solutions @ datasolutionsplus.com or  CLICK HERE

footer