Forum home » Delegate support and help forum » Microsoft Access Training and help » access database microsoft training - Access!

access database microsoft training - Access!

ResolvedVersion Standard

Wed 12 Sep 2007, 09:01 Delegate Foad said...

Foad has attended:
Access Introduction course

Access!

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???

Thu 13 Sep 2007, 15:44 Trainer David said...

RE: Access!

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

access database microsoft training - Access!

Access!

RE: Access!

Access articles

Access tip:

Using the Quick Access Toolbar in Access 2010