The DROP Statement in SQL – Tutorial
Thursday, July 14 2016
The DROP Statement in SQL: Overview You use the DROP statement in SQL to delete created database objects. You can use the DROP statement in SQL to delete databases, tables and indexes. You can also use the DROP statement in SQL in conjunction with the ALTER TABLE statement to delete fields
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments
NULL Values in SQL – Tutorial
Tuesday, April 12 2016
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
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL
The UPDATE Statement in SQL- Tutorial
Wednesday, October 28 2015
The UPDATE Statement in SQL: Overview After you have data within the tables in your database, you will often need to update those records. SQL uses the UPDATE statement to update field data within specified records in a table. The core SQL of the UPDATE statement is shown below. Note that the “table_name” parameter
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL
CREATE DATABASE Statement- Tutorial
Friday, June 26 2015
CREATE DATABASE Statement: Overview Within many relational database management systems, the CREATE DATABASE statement is used to create the database. The core SQL of the statement is shown below. CREATE DATABASE database_name In this statement, the “database_name” parameter is the name you want to give to the database. Note that while most versions
The FOR Loop in JavaScript- Tutorial
Thursday, March 05 2015
The FOR Loop in JavaScript: Overview Loops are useful in JavaScript when you want to execute the same code over and over with a different value each time. The for loop in JavaScript is used to create a loop in JavaScript. The for Loop in JavaScript loops through a block of code a number
- Published in JavaScript, Latest
The UNION Operator in SQL- Tutorial
Wednesday, February 11 2015
The UNION Operator in SQL: Overview The UNION operator in SQL allows you to combine the result sets of two or more individual SELECT statements into a single result set. Note that the UNION operator in SQL is not a JOIN, but rather a way to combine the data within two result sets into
- Published in Access 2013, Latest, Office 2013, SQL
Managerial Accounting- Tips for Ethics in Financial Reporting
Thursday, June 13 2013
In recent years, many financial scandals have come to light in the media. Companies such as Enron, WorldCom, and AIG have experienced significant scandals due to unethical and sometimes illegal accounting practices. It is important for companies to prepare financial statements correctly and legally to avoid punishment, but also to have an honest relationship with
- Published in Business, Latest, Small Business Accounting