Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros

Posted on June 9, 2016June 9, 2016 by Ian

This article is Part 3 of the Microsoft Access tutorial.

Here’s what’s included in this article:

Create a query (so you can “search the database”).
Create a form for data entry.
Create a macro (so that a multi-step task can be done automatically – at the click of a button).

How to Use the Query Designer in SQL Server

Posted on May 24, 2016February 14, 2020 by Ian

To use the Query Designer in SQL Server:

Open a new query by clicking New Query on the toolbar
Open the Query Designer by selecting Query > Design Query in Editor... from the top menu
Add the tables you want to run the query against
Build the criteria for your query then click OK

The query will appear in the query window. To run the query, click ! Execute or press F5

Below are screenshots for the above steps.

Posted on May 24, 2016February 14, 2020 by Ian

To create a query in Access 2013 or 2016:

The results of the query will be displayed.

You also have the option of saving your query. To save the query, right-click on the query tab. click Save, and name it at the prompt.