access database microsoft training

access database microsoft training - Access!

Resolved · Low Priority · Version Standard

Access!

Foad has attended:
Access Introduction course

by - delegate Foad [3 posts] (2007 Sep 12 Wed, 09:01) Reply

I have historical daily data based on trades made these are the data inside the data base:

date
nominal amount
counterpart

I want to make a query so I can view my data by months and by times traded with one single counterpart. How can I do this???

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	3	book now	£475	£495
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: Access!

by - trainer David gold contributer [428 posts] (2007 Sep 13 Thu, 15:44) Reply

Hi Foad

To do this you would need to create a query. You would link the tables together, select the data you want and then put an order by clause in the the SQL. I suggest that it may be a good idea to take the next level Microsoft Access course as this will enable you to understand this a lot better.

Hope this helps
David

· Innovation with Microsoft Access
· Convert a Paper Trail to a DBMS
· Microsoft Access Courses
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Three Myths About Microsoft Access

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips

Rate this page: