functions – Page 151

Microsoft Access Tutorial (Part 2): Design View, Field Properties, & Relationships

November 19, 2019June 9, 2016 by Ian

This article is Part 2 of the Microsoft Access tutorial.

Here’s what’s included in this article:

Design View.
Add field properties to a field.
Add two more tables (for the relationship)
Set up a relationship between three tables.

What is the Expression Builder in Microsoft Access?

February 14, 2020June 8, 2016 by Ian

The Expression Builder is a component of Microsoft Access that helps you build expressions. It allows you to look up and build expressions without having to remember how to type the full expression.

Screenshot of the Expression Builder in MS Access 2013. — The Expression Builder in Access 2013.

How to Create a Table in SQL Server using a Query

February 14, 2020May 24, 2016 by Ian

To create a table in SQL Server using a query:

In the SQL Server Management Studio, click the New Query button on the toolbar
Type or paste a CREATE TABLE script (example below)
Click the ! Execute button on the toolbar

Here’s an example:

Screenshot of SSMS with the New Query button highlighted. — Clicking the “New Query” button on the SSMS toolbar opens a new query. Clicking “Execute” runs the query.

What is a View?

February 14, 2023May 24, 2016 by Ian

In the world of databases, a view is a query that’s stored on a database.

The term can also be used to refer to the result set of a stored query.

To create a view, you write a query, then save it as a view.

To run a view, you query it, just like you’d query a table. The difference is that, the view itself is a query. So when you query the view, you’re effectively querying a query. This enables you to save complex queries as views, then run simple queries against those views.