microsoft access course london - Query

The UK's most regular instructor-led training courses.
Training information: microsoft access course london · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Query

Theresa has attended:
Access Intermediate course

by - delegate Theresa [1 post] (2007 Mar 15 Thu, 15:56) Reply

How do I create a query

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Query

by - trainer Richard platinum contributer [818 posts] (2007 Mar 20 Tue, 10:20) Reply

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

· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access as a Business's Database Management System
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Access VBA Handling Errors and Debugging Code
· Take an Access Course to Learn About Relational Databases

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report