slide1
Download
Skip this Video
Download Presentation
Resources – MS Access Free Online Training Resources

Loading in 2 Seconds...

play fullscreen
1 / 14

Resources – MS Access Free Online Training Resources - PowerPoint PPT Presentation


  • 123 Views
  • Uploaded on

Resources – MS Access Free Online Training Resources. Using an Access database to store and information (2 min) http://office.microsoft.com/en-us/assistance/HA011709681033.aspx Creating tables in Access (50 min): http://office.microsoft.com/training/training.aspx?AssetID=RC061183261033

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Resources – MS Access Free Online Training Resources' - lavey


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Resources – MS Access Free Online Training Resources

  • Using an Access database to store and information (2 min) http://office.microsoft.com/en-us/assistance/HA011709681033.aspx
  • Creating tables in Access (50 min): http://office.microsoft.com/training/training.aspx?AssetID=RC061183261033
  • Writing queries (50 min): http://office.microsoft.com/training/training.aspx?AssetID=RC010776611033
  • Youtube
  • http://www.youtube.com/view_play_list?p=D1836790490DF1AD&search_query=ms+access+2003+tutorial
definitions definitions
Definitions, Definitions…
  • Database: Collection of tables and queries
  • Table (or relational table)
    • Collection of records that share a common fundamental characteristic
  • Record
    • A record is composed of fields
  • Query
    • Set of instructions to a database “engine” to retrieve, sort and format returning data.
      • “find me the # of housing sales in my database”
slide6

Querying MS Accessor any relational database…

  • Querying = extracting information out of the database
  • This is done using the Structured Query Language (SQL)

Select PARCELID, ADD2, SQFT, LANDUSE

From PARCELS

Where SQFT>5000

Select fields

Select table

Select records

slide8

Querying MS Accessor any relational database…

  • Example:
    • Wildcard characters: ‘*’ ‘%’
    • AND vs. OR

Select PARCELID, ADD2, SQFT, LANDUSE

From PARCELS

Where LANDUSE like ‘C’ OR LANDUSE

like ‘R*’ OR LANDUSE like ‘A’

Select fields

Select records

slide9

Querying MS Accessor any relational database…

  • What if you want to query two tables?

Ownership Parcel

What will happen if you don’t

match up the tables with owerid?

A shared key

  • Shared key (ownerid) that is:
    • 1. unique to each table
    • 2. can be referenced by another table
slide10

SELECT PARCELS.PARCELID, PARCELS.SQFT, OWNERS.OWNERNUM, PARCELS.ONUM, OWNERS.ONAME

FROM OWNERS INNER JOIN PARCELS ON OWNERS.OWNERNUM = PARCELS.ONUM

WHERE (((PARCELS.SQFT)>5000));

slide12

Import MS-Access tables to ArcGIS

-Use MS Access database provider to talk to MS-Access

slide13

1. Specify the location of your database

2. Test connection

3. Click “OK”

miscellaneous
Miscellaneous
  • One OLE DB connection will create only one connection to the database.
  • ArcGIS will remember the connection for you.
ad