Wingspan Swift SQL in 10 Images

Swift SQL Main Page

Clint Covington's Blog

Download 14 day Demo Version

You can now try Swift SQL for free for 14 days by just clicking on the link below. You will be required to register with our website, but we will only use your login for tracking your order and will not forward your email to any other party!

Swift SQL 14 day Demo Version!

Pricing

Swift SQL is a great new tool from Wingspan that brings working with Access SQL into the 21st Century!

To purchase the product now, please click this link to place your order:
Buy Wingspan Swift SQL

Support

With Wingspan, you are not alone. You can contact us by email anytime, or you can view the downloadable Video Tutorials and Documentation for Swift SQL

A Quick Tour of Swift SQL in 10 Images

1. Launching Swift SQL

Swift SQL is a Com Add In that is registered on your computer by the Installation program.

 Once you have installed Swift SQL, a new 'Swift SQL' button will appear on your Database Container toolbar.  It will also appear in the Tools Menu and in the Query Designer toolbar.

These buttons are ALWAYS automatically available to you, for any file that you are working with!

You can launch Swift SQL from the Database container, by selecting a query and clicking the new 'Swift SQL' button, or else...

...open a Query in SQL view and click the new 'Swift SQL' button.

2. The Swift SQL Window

Launching Swift SQL will open the following Editor Window

Take a look at how it has automatically formatted your query's SQL string to make it easy to read and edit

The Swift SQL Editor Window. Note the formatted SQL string

3. Find and Replace in Swift SQL

Use Swift SQL's Find and Replace functionality to edit your SQL strings

Find and Replace in action in the Swift SQL Editor

4. Commenting your SQL Strings

Using Swift SQL, you can now add comments to your SQL strings

Add comments anywhere in your SQL strings with Swift SQL

5. Testing SQL strings

Swift SQL allows you to safely test edited SQL strings against your database without making any changes to the actual queries in your Database

6. Editing your SQL Strings

You can edit SQL strings by typing directly into the editor window.

But you can also use the Table and Select Query documenting features of Swift SQL to allow you to enter fully qualified Field names into your SQL string by just double clicking on the Field name!

Adding a new Field into your SQL by double clicking on the Field name in the Documenter list box.

7. Documentation of Tables, Queries and Fields

By selecting and right clicking a table or query name in the Editor, you view all the correct Field Names for that object

Viewing all the Fields for any Table in your Query

8. Commit SQL or Save As New Query

Swift SQL stores all your work in its own Datafile

Therefore, until you either save the SQL string as a New Query, or Commit the SQL to the underlying Query you are working with, your database is insultated from any changes you make to the SQL strings

This makes Swift SQL very safe to use and great for testing changes to the SQL of your Queries.

The Commit SQL and Save as New Query buttons

9. Snapshots: Store, Test and Edit multiple versions of your Queries

Swift SQL manages multiple versions of your SQL strings by storing them as 'Snapshots'

To create a new Snapshot, just click the 'Save as New Snapshot'. button.

You can store as many different Snapshots of any given query as you like, allowing you to restore previous versions of your queries or even use Swift SQL as a version control tool for your Access Queries!

Creating a new Snapshot

10. How does Swift SQL store Snapshots?

Swift SQL stores the Snapshots of your Queries in its own backend data file.

That is how it insulates your database from any changes you make until you proactively commit the changes to your database

Check out the Live Copy column in the Snapshots table: the Snapshot that is checked is the one that reflects the SQL that is stored in your database.

The Swift SQL Data File

Tutorial Videos

We have a series of Tutorial videos that covers what we have shown here and all other aspects of Swift SQL in full detail. Please click on the link below to start viewing these videos.

Swift SQL Tutorials and Documentation Videos

Return to Wingspan Swift SQL Main Page

Swift SQL Main Page

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.