access courses - select query
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses - Select query

access courses - Select query

resolvedResolved · Low Priority · Version Standard

replyReply Mon 23 Jul 2007, 16:08Delegate Maureen said...

Maureen has attended:
Access Introduction course

Select query

We have been into system selected query, typed in headings
selected field we required information from. Which was dates from and to, Selected view item and nothing happend.
Help what are we doing wrong?????
Rgds
Maureen Clarkson

For upcoming training course dates see: Pricing & availability

replyReply Mon 30 Jul 2007, 12:11Trainer Richard said...

RE: Select query

Hi Maureen

Create a new query using the following steps:

1. Click on Query tab on the left of the database window
2. Create new query using design view
3. Select the table you want the data from, click SHOW / ADD
4. Double click the fields you want to see showing in your query result.
5. View your query by using the view icon at the top left of the screen
6. Go back to the design view, using the same button
7. Add any criteria you want to filter by.

Does that help?

Regards

Richard

 

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard