microsoft access course london - query

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course london - Query

microsoft access course london - Query

resolvedResolved · Low Priority · Version Standard

Theresa has attended:
Access Intermediate course

Query

How do I create a query

RE: Query

Theresa,

You can create a QUERY by selecting the QUERY tab onthe left of the database window. There are Three options:

Create QUERY by:
- using the wizard
- in design view

You can choose how to start off. If you are new to Queries, try using the wizard to get the basics going. All the technical settings are located in the design view.

Once you really get a grip on queries, look at the SQL view and learn some of the statements. We cover this in the advanced course.

Richard


 

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Server loaded in 0.08 secs.