creating a simple database

[Mark MacMillan]

HELP! I come to Access from a FilemakerPro mindset. I've
been asked to create a simple database, but there is no
Access documentation in this office.

The database has one text field, plus six numeric fields,
plus two calculation fields per record (the calculations
simply sum up the various numeric fields). Then
ultimately I need grand-totals -- to summarize all the
records.

So far, all I've been able to create is the text and
numeric fields. How easy is it to insert calculation
fields, then summaries?

THANK YOU TO ANYONE WHO CAN HELP.

 

[Dan Artuso]

Hi,
Just so you know, what you are refering to is a table within a database.
Now, without knowing exactly what these calculations are, I can
tell you that you can use calculated fields in queries or you can have
a form based on your table with calculated controls.

You can fool around with a query by creating a new one, then adding your table
to it. Once you are in design view, click on the Totals icon (the sigma symbol
on the toolbar). You can then choose from different aggregate functions such as
Sum, Average, Min, Max and so on, by clicking on the Totals row in the grid.

Use Help to get more info on these topics:
queries, totals query, aggregate functions, group by