Action Queries

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Action Queries

Use the Design View to start a query, and then open the code to customize the statement.
http://www.functionx.com/access/Lesson21.htm
  • Total Hits: 19277

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 150 votes

  • Category: MS Access/Query Languages

  • Submitted on: 2008-04-15 07:42:39

  • Submitted By: Shekhar

  • Set as Favorite

Description:

We have used the concept of a query so far only to create a list of fields that would be considered for a set of records. We also mentioned that a query in Microsoft Access is simply a means of visually representing data. Indeed, a query is based on a SQL statement. As SQL is its own, fully functional language, we can use it to perform far more operations than to only select columns for a query. The SQL can be used to create tables, modify tables, perform data entry, modify records, etc. Some of these operations can be performed visually in the query Design View. They can also be performed using SQL statements. To know what is going on behind the scenes, you can write your own code (SQL statement). You can also use the Design View to start a query, and then open the code to customize the statement.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 37.33%  56
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.67%  16
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 12%  18
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.33%  17
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.67%  43

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements