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
The SELECT Statement in SQL- Tutorial
Monday, September 21 2015
The SELECT Statement in SQL: Overview You use the SELECT statement in SQL to choose specific records to view from a table, or from related tables, within a temporary table called a result set. We will start the examination of the SELECT statement by looking at the SELECT statement in its simplest form when
- Published in Access 2010, Access 2013, Latest, Microsoft, Office 2010, 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
DROP USER and DROP ROLE Statements in SQL
Thursday, November 20 2014
DROP USER and DROP ROLE Statements in SQL: Overview This blog post discusses using the DROP USER and DROP ROLE statements in SQL. You can use the DROP USER statement in SQL to delete a user from the database. Note that this statement is technically classified as Data Definition Language (DDL), as it defines
- Published in Access 2013, Latest, Microsoft, SQL
Managing Accounts Receivable in Sage 50 2014
Friday, October 11 2013
Sage 50 is a multi-featured accounting and bookkeeping program that allows you to create invoices, statements, pay your bills, write checks, track inventory, manage your payroll, and perform other accounting and business-related services. Sage 50 is a terrific program to learn, as the skills that you learn in Sage 50 can save valuable time and
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