Ready to Checkout?


Delete a Table Field in Access: Overview             You can delete a table field that you do not use from a table in an Access database. Once again, as when changing a field name, make sure that there are not any queries, forms, reports or macros that refer to the field or use data contained

The UNION Operator in SQL- Tutorial

Wednesday, 11 February 2015 by

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

The DELETE Statement in SQL: Overview             The DELETE statement in SQL is used to remove specified records from a table. Like the UPDATE statement, it includes a WHERE clause that you should ensure is correct before executing the DELETE statement in SQL. If you do not specify a WHERE clause within the DELETE statement

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

Microsoft Office 365 vs. Microsoft Office 2013             As a software training center, we have noticed that there still seems to be some confusion between Microsoft Office 365 vs. Microsoft Office 2013 and what that entails for the related Microsoft Office training. This article will attempt to clarify the differences between the two. The major

              A Reference Guide Full of Office Tips             Many users who are already familiar with using the products contained in the Microsoft Office 2013 suite of products may only need a quick tip on how to perform common tasks. You can find many common

              The SQL training “Mastering Introductory SQL Made Easy™ v.1.0” discusses SQL in Access 2013. Access 2013 is a RDBMS that creates self-contained databases and provides visual tools to allow users to make relational databases without the need for SQL. As such, there are few places to use SQL in Access.

Need more Access training? Click here for the complete tutorial!                 Setting Field Properties You can set the properties of the table fields that you create in the design view of the table. When you open tables in design view, you name the fields and assign them a