Rename a Field in a Table in Access – Instructions and Video Lesson

Rename a Field in a Table in Access - Instructions: A picture of a user renaming a table field in Access.
Rename a Field in a Table in Access: Overview             You can rename a field in a table in Access that you have already created. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously created objects. This
Read more
No Comments

Wildcard Characters in Access- Tutorial

Wildcard Characters in Access: A picture showing wildcard characters used for query criteria in Access.
Wildcard Characters in Access: Overview             You can use wildcard characters in Access to add an additional level of flexibility to your query criteria. Wildcard characters within query criteria in Access represent unknown values. The asterisk “*” and the question mark “?” are the two main wildcard characters in Access
Read more
No Comments

Create Input Masks in Access – Tutorial

Create Input Masks in Access - Tutorial: A picture of the “Input Mask Wizard” in Access.
Create Input Masks in Access: Overview             You can create input masks in Access to dictate a pattern used for data entry in selected fields. Access provides an easy step-by-step routine called the “Input Mask Wizard” to do this. The “Input Mask Wizard” helps you apply input masks to selected “text” and “date/time” fields.            
Read more
No Comments

The Format Property for Yes/No Fields in Access – Tutorial

The Format Property for Yes/No Fields in Access - Tutorial: A picture of a user setting the
The Format Property for Yes/No Fields in Access: Overview             You can set the Format property for Yes/No fields in Access to change the way that they will display in forms and reports. The following formats are available for logical fields in Access. To set the Format property for Yes/No fields in Access, simply select
Read more
No Comments

The SELECT Statement in SQL- Tutorial

The SELECT Statement in SQL- Tutorial: A picture of the SELECT statement syntax in SQL.
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
Read more
No Comments

Delete a Table Field in Access- Tutorial

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
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

How to Create a Database in Microsoft Access 2010

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
Read more
No Comments