• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using Access to Learn SQL

Access is a useful learning tool for gaining fluency in SQL. This chapter shows you how to create Access QBE queries from SQL statements entered in the SQL dialog. If you use SQL with another RDBMS, such as Microsoft SQL Server, this chapter can help you make the transition from ANSI/Access/Jet SQL to Transact-SQL, the extended version of SQL used by Microsoft SQL Server. Knowledge of SQL also is necessary for Visual Basic programmers because Visual Basic doesn't include a graphical QBE feature.

Many users of Access decision-support applications want to be able to define their own queries. When you open an Access 97 database with the runtime version of Access, the Query Design window is hidden. Thus, you must design forms that include control objects that users can manipulate to construct a Jet SQL statement that returns the desired query result set. You write Access VBA code to translate users' choices on the form into a Jet SQL statement; then create a QueryDef object (a persistent query definition whose name appears in the Database window) in the current database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint