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

Resources – MS Access Free Online Training Resources PowerPoint PPT Presentation


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

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”


What is the difference between a table and a query

What is the difference between a table and a query?


What is the difference between tables and queries

What is the difference between tables and queries?


Resources ms access free online training resources

Create MS Access database


Resources ms access free online training resources

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

Example table


Resources ms access free online training resources

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


Resources ms access free online training resources

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


Resources ms access free online training resources

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


Resources ms access free online training resources

From queries to tables


Resources ms access free online training resources

Import MS-Access tables to ArcGIS

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


Resources ms access free online training resources

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.


  • Login