Resources – MS Access
Download
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

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”





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



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 PARCELS.ONUM, OWNERS.ONAME


Import MS-Access tables to ArcGIS PARCELS.ONUM, OWNERS.ONAME

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


1. Specify the location of your database PARCELS.ONUM, OWNERS.ONAME

2. Test connection

3. Click “OK”


Miscellaneous
Miscellaneous PARCELS.ONUM, OWNERS.ONAME

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

  • ArcGIS will remember the connection for you.


ad