Soil Scientist’s Guide to MS-Access
Soil Scientist’s Guide to MS-Access
98
Soil Scientist’s Guide to MS-Access
Chapter 1: SSURGO Template 4
Loading MLRA data in NASIS 4
Exporting data from NASIS 6
Importing NASIS MLRA data into the SSURGO Template 9
Chapter 2: Basic Access 12
Tables Object 15
Switching between “Views” 15
Formatting tables 16
Subdata sheet 21
Filtering Data 23
Importing Data 25
Queries Object 28
Select Query 28
Crosstab Query 37
Make Table Query 38
Update Query 39
Append Query 39
Delete Query 40
Query Icons 40
Other Query Functions 41
Criteria 41
Wildcards 42
Sorting Data in a Query 43
Property Box (Query) 44
Calculating Statistics 46
Using a Calculated Field in a Query 47
Operators and the “Expression Builder” 48
Saving the Query 48
Using a Query to edit NASIS data 49
Reports Object 51
Pieces of the Report Manager 52
Building the Report 53
Property Box (Label) 55
Property Box (Control) 56
Properties Box (Header and Footer) 59
Property Box (Report) 59
Sorting and Grouping 60
Chapter 3: Advanced techniques 62
Queries and subqueries: 62
Report and subreports: 64
Expressions 69
Concatenation Expressions 69
Conditional Expressions 69
Arithmetic Expressions 70
Part of a Field’s expression 71
Using Expressions in Reports 72
Getting External Data 74
Drop Survey Area and Import macros 75
Chapter 4: Pedon Access Techniques 76
Importing NASIS Pedon data into Access 76
Relationships and Joins 79
Using the “Delete” query for PedonCE 83
Modifying Forms for Pedon “Migrator” 88
Chapter 5: ArcMap and the SSURGO Template 93
Joins 93
Relates 95
Closing Remarks 102
98
Soil Scientist’s Guide to MS-Access
98
Soil Scientist’s Guide to MS-Access
98
Soil Scientist’s Guide to MS-Access
98
Soil Scientist’s Guide to MS-Access
98
Soil Scientist’s Guide to MS-Access
98