Create a Calculated Field in Access – Instructions

Create a Calculated Field in Access - Instructions: A picture of a calculated field in an Access query.
Create a Calculated Field in Access: Overview             You can easily create a calculated field in Access queries. A calculated field is a field that derives its value by performing a function on values from other table fields. It can also calculate values entered by hand. The field’s data only appears for the duration of
Read more
No Comments

Hide a Query Field in Access – Instructions

Hide a Query Field in Access - Instructions: A picture of a hidden field in a query, shown within the query design view in Access.
Hide a Query Field in Access: Overview             You can easily hide a query field in Access. Sometimes when you create queries, you need to add a field to the QBE grid for criteria purposes only. In this case, you don’t want the field itself to appear in the result set. Having additional fields appear
Read more
No Comments

Sort a Query in Access – Tutorial

Sort a Query in Access - Tutorial: A picture of a user sorting a query result set using the buttons in the “Sort & Filter” button group on the “Home” tab in the Ribbon.
Sort a Query in Access: Overview             You can sort a query in Access by any field within the QBE grid when viewing the query in design view. To sort a query in Access when in design view, select the field in the QBE Grid by which to sort the result set. Then click into
Read more
No Comments

Run a Query in Access – Instructions and Video Lesson

Run a Query in Access - Instructions: A picture of a query opened in “Design View” in Access.
Run a Query in Access: Overview             You can run a query in Access when using query design view. To do this, click the “Design” tab of the “Query Tools” contextual tab within the Ribbon. Then click the “Run” button in the “Results” button group.             If the results are not what you expected, you
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

Aggregate Function Queries in Access – Tutorial and Instructions

Aggregate Function Queries in Access - Tutorial: A picture of a user selecting an aggregate function to perform within a query in Access 2016.
Aggregate Function Queries in Access: Overview             You can create aggregate function queries in Access that perform a mathematical function on another grouped field in a query. Aggregate function queries in Access are usually shorter queries often used for summary totals in reporting.             For example, if you want to know the sum of sales
Read more
No Comments

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