ODBC-101 - LuisGomez.NET
Download
Report
Transcript ODBC-101 - LuisGomez.NET
Using ODBC drivers with
Windows Applications
Slightly Different steps for each release.
These steps are for 2003.
Creating a Query.
Autofilter.
Pivot Table.
Charts.
ODBC & End Users.
Data
>
◦ Import External Data >
New Database Query....
Choose Data Source (Payroll):
◦ You may have several Databases or Applications.
◦ BR Demo provides Payroll & Common.
QueryWizard:
◦ Select Desired Fields.
◦ Select Desired Filters.
◦ Select Desired Sort Order.
Data
>
◦ Filter >
AutoFilter.
Resize Fields to Display as desired.
Use Handle or “Down Arrow”.
Easily filter out unwanted information.
Data
>
◦ PivotTable and PivotChart Report >
AutoFilter.
Pull Data either from Sheet or Data.
Wizard May help, but I just Finish.
Drag Fields to Pivot Table.
Sum vs. Count.
Data
>
◦ PivotTable and PivotChart Report >
AutoFilter.
Often it’s best to start with a PivotTable.
Use the Wizard, it has lots of options.
Slightly Different steps for each release.
These steps are for 2003.
Import vs. Link.
Queries.
Reports.
Import:
◦ Copies data from BR to Access
◦ Snapshot in Time
◦ Queries run Faster
Link:
◦
◦
◦
◦
Queries read data Directly from BR tables.
Live results.
Indexes make it faster.
Joins are Slower
Mixing Import & Link is often the best
A SQL statement that pulls data from tables:
◦ Take advantage of the GUI Query designer.
◦ Otherwise known as “Views”
Make Table Query:
◦ A Special type of Query.
◦ When executed, will “IMPORT” data into a table.
◦ Use Imported data to run a complex Query.
Joins:
◦ Challenges with BR.
◦ Many to One.
◦ Join Other Queries.
Start with a Table or Query
Use the Wizard to Get Started
Enhanced with the Designer.
Create End User Documentation:
◦ File Layouts.
◦ “How To Tutorials”.
◦ Training Seminars.
Custom Reports & Queries:
◦ SQL/ODBC Queries can be sold.
◦ Much easier to create.
◦ Once delivered, customers can modify reports.