SQL Training: Using the CREATE VIEW Statement in SQL- Structured Query Language for Databases
Tuesday, May 13 2014
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
No Comments
Microsoft Access 2013 Training: How to Use the Report Wizard
Thursday, May 01 2014
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
- Published in Access 2013, Latest
Understanding SQL Functions- Standard Query Language for Databases
Tuesday, April 15 2014
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
Delete, Crosstab, Find Duplicates, and Find Unmatched Queries in Microsoft Access 2013
Wednesday, March 19 2014
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,
- Published in Access 2013, Latest
Advanced Queries in Microsoft Access 2013
Tuesday, March 18 2014
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
- Published in Access 2013, Latest
Advanced Queries in Microsoft Access 2010
Tuesday, February 18 2014
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
- Published in Access 2010, Latest
How to Create a Database in Microsoft Access 2010
Monday, January 27 2014
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
- Published in Access 2010, Latest
How to Access Settings in Windows 8.1
Wednesday, December 18 2013
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
- Published in Latest