NULL Values in SQL – Tutorial

NULL Values in SQL - Tutorial: A picture of the main bullet points of the lesson on NULL values in SQL.
NULL Values in SQL: Overview             When creating tables in SQL, you will need to deal with NULL values in SQL. A NULL value is a value that is unknown. These values can occur within database tables when a user who is performing data entry skips entering a value into a field. When a value
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 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

Designing Queries in Microsoft Access 2010

Using the Simple Query Wizard You use a query to answer a question that you have about the information stored in the database tables. You can then further analyze the results that the queries pull to produce even more information than the query itself displays. Reports are often based on query results, upon which they
Read more
No Comments

How to Use the Simple Query Wizard in Microsoft Access 2013

Click here for the complete tutorial             A query is a way to retrieve in formation in a database. In Microsoft Access, you use a query to answer a question that you have about the information stored in the database tables. You can then further analyze the results that the
Read more
No Comments