Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2003 (table relation)

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access 2003 (table relation)

Resolved · Medium Priority · Version 2003

Reply Wed 21 Jan 2009, 14:10Delegate Anita said...

Anita has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course
Excel Advanced course
Effective Communication Skills course

Access 2003 (table relation)

Can you view data from different tables in one database, rather than separate tables? This may be something to do with the table relation?

In addition, what other advanced features will help in a finance department where Excel performs the primary resource to formulate information? Are these taught in the Intermediate or Advances phase? How will using these in Access benefit against Excel?

For upcoming training course dates see: Pricing & availability

Reply Wed 21 Jan 2009, 21:23Trainer Rajeev said...

RE: Access 2003 (table relation)

Dear Anita

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

You are right. This is something to do with Relationships between tables. We cover this in detail in Intermediate level.

If you know how the relationship work in Access you can very easily insert something known as Subdatasheets. If you are not familiar with relationships between the tables then I recommend that you enrol in one of our Intermediate courses.

Please find the below link to see the schedule of the intermediate course:

http://www.microsofttraining.net/microsoft-access-course-london-2000-intermediate.php

It is important to understand that Access is not there for lots of calculations and functions!! If you feel that you need to do lots of calculations then my recommendation will be to use Excel. If you have got most of teh data in Access and you wish to transfer it in Excel so that you can perform the financial functions then please follow these steps:

1. Open the Table or Query in Datasheet view
2. Choose Tools > Office Links > MS Excel

This will extract your table into Excel and you can perform all your excel functions.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Wed 28 Jan 2009: Automatically marked as resolved.

Access articles

· Up The Professionalism Of Access Files Thanks To Digital Signatures
· MS Access and Database Normalisation
· How To Use The Analyze Table Tool In Access
· How To Make One Combo Show Values Determined By Another Combo In Access
· How Microsoft Access grows with your company

Please browse our web site to find out more about
access database courses and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips