Resources – MS Access
Sponsored Links
This presentation is the property of its rightful owner.
1 / 14

Resources – MS Access Free Online Training Resources PowerPoint PPT Presentation


  • 65 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Resources – MS Access Free Online Training Resources

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


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…

  • 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”


What is the difference between a table and a query?


What is the difference between tables and queries?


Create MS Access database


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


Example table


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


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


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));


From queries to tables


Import MS-Access tables to ArcGIS

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


1. Specify the location of your database

2. Test connection

3. Click “OK”


Miscellaneous

  • One OLE DB connection will create only one connection to the database.

  • ArcGIS will remember the connection for you.


  • Login