SQL Training: Using the CREATE VIEW Statement in SQL- Structured Query Language for Databases

Need training for SQL? Click here for the complete video training.               About Views A view is a virtual table that is based on the results of a SELECT statement. They are very much like the result set of a query. They always display the most recent data from
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

Understanding SQL Functions- Standard Query Language for Databases

To view the complete tutorial, click here             Understanding SQL Functions Functions serve a wide range of purposes within SQL. You can use aggregate functions to perform calculations on grouped values within a query. That is one very common use of functions within SQL. However, there are other types of
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

Advanced Queries in Microsoft Access 2010

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 as the output of a query, instead of simply displaying a
Read more
No Comments

How to Create a Database in Microsoft Access 2010

Creating New Databases A new database is a container that will hold all of the tables, form, reports, queries, macros, and modules that you create. In Access 2010, you can create a new database by clicking the “File” tab in the Ribbon. Then click the “new” command. Then select the “Blank database” choice in the
Read more
No Comments

How to Access Settings in Windows 8.1

Accessing Settings in Windows 8.1 You can access the settings in Windows 8.1 by clicking the “Settings” button within the Charm Bar. To show the settings for the currently displayed app on your computer, roll your pointer to the upper-right or lower-right corners of the Windows 8.1 screen until the Charm Bar appears. Then roll
Read more
No Comments