Please help me - I'm new here!!

[ItsMe]

There really is not anything to click. Use a paper and pencil to draw out your entities and relationships. Use queries to define your relationships within Access. Reference the paper when you build your queries. Alternatively, you can use the Relationships Window to define Relationships and enforce Referential Integrity constraints. However, you may find that depending on the Relationships Window can create issues when you are using more advanced techniques to develop applications.

[Total Newbie]

Ok,

So, somehow I've done it!! I managed to link the two tables together now so one is a subtable of the other this is a good start......

So now what I need is to get my table to do some calculations, if this is possible? (I imagine it should be... but what do I know!) - basically I want the table to be able to work out some basic info, such as VAT based on the applicable VAT rate, and balances etc etc. I could do this in Excel simples, but can it be done in Access?

[Total Newbie]

Can anyone help with this last question? I.e. can these boxes do basic calculations as per excel?

[orange]

TN,

If you learn by watching, then do some more watching before getting too deeply in to Access.

Here is the first Database video in a series -you will see and learn various concepts.

Here is another series on the relational model.

And here is the first Access oriented video of a long series by Steve Bishop.

You really need to understand your business clearly before getting in to database. And you have to understand the basics of database before getting into Access. You said you were looking for a challenge, and what I have given is one approach to meeting your challenge.
Good luck .

[Total Newbie]

Thanks I'll take a look

[June7]

Access 2007 cannot do calculations in table. Must be done in query or in textboxes on form or report.

[Total Newbie]

Access 2007 cannot do calculations in table. Must be done in query or in textboxes on form or report.

Thank you - do the later versions allow it then?? If I were to get 2010 or something?

[June7]

Access 2010 introduced a new field type - Calculated - which will allow some calculations in tables. Common use is to do arithmetic with fields, such as Qty * Price. However, the same can be done in a query so not really a strong justification for upgrading to 2010.