Query Relationship

Resolved · Low Priority · Version 2007

Tue 17 May 2011, 17:12 Delegate Naomi said...

Naomi has attended:
Access Introduction course

Query Relationship

I need some help with understanding creating query

Wed 18 May 2011, 10:04 Trainer Simon said...

RE: Query Relationship

Hi Naomi,

Thank you for your question and welcome to the forum.

Once you have created your tables which hold the data, you can then view certain records from the table by creating a query.

For instance, if you had a Customers table and you wanted a query that showed all customers in Berkshire then you would create a query to show only the records that match the Berkshire criteria.

Please find a link below that will allow you to follow step by step.

http://www.baycongroup.com/access2007/05_access.html

I hope this helps. Let me know.

Regards

Simon

Wed 18 May 2011, 10:34 Trainer Simon said...

RE: Query Relationship

Hi Naomi,

I have just found another link that may be useful.

http://www.dealing-with-data.net/create-access-query.html

Regards

Simon

Tue 24 May 2011: Automatically marked as resolved.

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

Query Relationship

Query Relationship

RE: Query Relationship

RE: Query Relationship

Access articles

Access tip:

Hiding Multiple Table columns