Scribd
Upload
15 views2 pages

Chapter 18

This document provides guidelines for data manipulation in MS Access, emphasizing the importance of selecting the correct file type during import and ensuring proper date formatting. It outlines how to create relationships between tables and perform calculations in report footers, including functions for counting, summing, averaging, and finding minimum and maximum values. Additionally, it includes examples of how to filter date values based on specific criteria.

Uploaded by

payal.gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views2 pages

Chapter 18

This document provides guidelines for data manipulation in MS Access, emphasizing the importance of selecting the correct file type during import and ensuring proper date formatting. It outlines how to create relationships between tables and perform calculations in report footers, including functions for counting, summing, averaging, and finding minimum and maximum values. Additionally, it includes examples of how to filter date values based on specific criteria.

Uploaded by

payal.gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

By Ms Payal Gupta

Chapter 18-ICT
Data Manipulation
Data Manipulation (MS Access)
 While importing files, make sure you select text file and not excel file, as .csv files
are plain text.
 When they ask for a set number of decimal places in a field, choose Fixed in Format.

 Ensure that the dates displayed in the table are in the correct format under Table

Design view.
 To form a relationship between two tables, go to the Relationships section of the
Database Tools tab and choose the required tables.

 The calculations will ONLY work if placed in the report footer. If Σ Total is used, then
it appears automatically in the report footer.

Count the number of fields in a =COUNT(\[Primary_field\])


report Always use the primary field as it is the unique
field
By Ms Payal Gupta

Sum of fields in a report =SUM(\[Field_name\])

Average of fields in a report =AVG(\[Field_name\])

Minimum of fields in a report =MIN(\[Field_name\])

Maximum of fields in a report =MAX(\[Field_name\])

) | | Yes | Find values that are Yes/True | | No | Find values that are No/False | |
#01/01/2009# | Find a specific date | | >01/03/2009 | Find dates after a given date | |
<01/03/2009 | Find a date before a given date | | Between 01/03/2009 and
31/03/2009 | Find dates in a given range |

You might also like