Microsoft Office 365 vs. Microsoft Office 2013 Training

A picture of the web page for
Microsoft Office 365 vs. Microsoft Office 2013             As a software training center, we have noticed that there still seems to be some confusion between Microsoft Office 365 vs. Microsoft Office 2013 and what that entails for the related Microsoft Office training. This article will attempt to clarify the differences between the two. The major
Read more
No Comments

Find Office Tips with the Microsoft Office 2013 Basics Quick Reference Guide

              A Reference Guide Full of Office Tips             Many users who are already familiar with using the products contained in the Microsoft Office 2013 suite of products may only need a quick tip on how to perform common tasks. You can find many common
Read more
No Comments

SQL Training: Using SQL in Access 2013

SQL Training: Using SQL in Access 2013- A picture of the Code Editor window in Access 2013 with ANSI-92 SQL code contained within it.
              The SQL training “Mastering Introductory SQL Made Easy™ v.1.0” discusses SQL in Access 2013. Access 2013 is a RDBMS that creates self-contained databases and provides visual tools to allow users to make relational databases without the need for SQL. As such, there are few places to use SQL in Access.
Read more
No Comments

Microsoft Access 2013 Training: Using Field Properties

Need more Access training? Click here for the complete tutorial!                 Setting Field Properties You can set the properties of the table fields that you create in the design view of the table. When you open tables in design view, you name the fields and assign them a
Read more
No Comments

Microsoft Access 2013 Training: How to Use the Report Wizard

To view the complete tutorial with video lessons, click here!                 Using the Report Wizard You use reports to further calculate and then display the results from a query. You can also use them to calculate statistical results on tables or queries for summary reports. They are simply
Read more
No Comments

Delete, Crosstab, Find Duplicates, and Find Unmatched Queries in Microsoft Access 2013

For the complete tutorial, click here.             Delete Queries You can use a delete query to delete records in a table based on specified criteria. Deleting unnecessary records will speed up the performance of queries, reduce redundancies, and make for more smoothly operating databases. When you run a delete query,
Read more
No Comments

Advanced Queries in Microsoft Access 2013

For the complete tutorial click here.           Make Table Queries Have you ever run a query and wished that you could save the result set of the query as a permanent table? In Access, that is exactly what the “Make Table” queries do. A “Make Table” query creates a new table
Read more
No Comments

Creating an Index in Microsoft Access 2013

One great feature of Access is the ability to create indexes from tables. An index can help users to find and sort records faster. The index stores the location of records based on the field you choose to index. Access obtains the location from the index, and then retrieves the data by moving directly to
Read more
No Comments