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
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
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.
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
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
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,
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
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