(IGCSE ICT) Calculations in MS-ACCESS??? Immediate help required!!!?

Question

I need step by step guide for calculations\formulas in MS Access , mainly in reports and queries. Different basic formulas mainly average,sum,min, max etc etc
Do include any websites you know in your answer.
URGENT!!!

Answer 1

For Reports:

From the Design Tools drag & drop a TEXTBOX into the area where you want the calculation to show up.



If You right click the TEXT BOX the PROPERTIES will open. Click the DATA tab and put your calulation in CONTROL SOURCE. If You Click the "..." to the right of CONTROL SOURCE the EXPRESSION BUILDER will open. You can view a list of common expressions & the help files for each from there.



In the PROPERTIES click the FORMAT tab and you can change how the results of your calculation appear (IE: 40% or $50).



For QUERIES:

Type your Expression in the FIELD: line. If You right click a column and click BUILD... the EXPRESSION BUILDER will open.



FOR BOTH:

Common calculations are fairly simple:

=[Field1]+[Field2]

=([Field1]+[Field2])*[Field3]



Rates/Percents are also fairly easy:

=[Field1]/[Field2]

=([Field1]+[Field2])/[Field3]



On reports put your TEXTBOX in a "FOOTER SECTION" and you can Summ up the columns:

=SUM([Field1])

=SUM ([Field1]+[Field2])

=SUM([Field1]+Field2])/SUM([Field3])



For Queries you'll have to click the SUM icon on the tool bar before this works.



There simply isn't enough room to fill in all of the details...this should get you going though.

Answer 2

Microsoft Access Calculations

Answer 3

Start off with the query.



In an open column right click the "field" cell. In the pop up menu click "build".



Double click "Functions". A ton of stuff will be available. Select what you want and start experimenting. The Help feature is also helpful.

Answer 4

get proper of entry to is a database application (small scale compared to the likes sq. Server/Oracle) and Excel is spreadsheet application. The confusion in many circumstances arises because both have spreadsheet like records get proper of entry to reflects. a million) get proper of entry to shops records in tables which will nicely be pertaining to to at least one yet another (relational database) at the same time as Excel makes use of flat spreadsheets 2) get proper of entry to love different database apps can use the sq. language to question yet excel has none 3) get proper of entry to can save much better records than excel can wish that permits somewhat? each and each and every of the most proper on your attempt!

Answer 5

well in ur calculation query, u just write any calculation u want to find out. for example if u had a restaurant and wanted to find out how much a customer wud have to pay for food, u simply type customer*(price).