1 / 5

CPSC 203

CPSC 203. Xin 27 October, 2010. Import Data. Excel  Access. Make-table queries. Query  Table Practice Create a Class table for different semesters Select the data with a query Change the query type to Make Table Query Run the Query Set Class to be the Primary Key of the new table

niabi
Download Presentation

CPSC 203

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CPSC 203 Xin 27 October, 2010

  2. Import Data • Excel  Access

  3. Make-table queries • Query  Table • Practice • Create a Class table for different semesters • Select the data with a query • Change the query type to Make Table Query • Run the Query • Set Class to be the Primary Key of the new table • Create five (5) queries, each showing • ID • Student • WebsiteRankX • Website Name

  4. Union Queries • Many queries  one query • Source queries have the same # of fields • The fields must be in the same order and data types • Union Queries must be done in SQL • Practice • Create a union query to combine the five queries just created • Create an empty query • Change the type to Union • Input the following SQL • SELECT QueryWeb1.* from QueryWeb1 • UNION • SELECT QueryWeb2.* from QueryWeb2 • UNION • SELECT QueryWeb3.* from QueryWeb3 • UNION • SELECT QueryWeb4.* from QueryWeb4 • UNION • SELECT QueryWeb5.* from QueryWeb5

  5. Append Queries • Add records to an existing table • Practice • Create a blank table, WebRanking, containing • WebsiteRankID (Autonumber) • ID (Number) • Student (Number) • WebsiteRank (Text) • WebsiteName (Text) • Create a new query based on the union query • Change the type to Append • Relate fields in the union query and the table • Run the query to append data

More Related