![Page 1: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/1.jpg)
Making the Most of Quick and Easy
Queries
Danny Brashear and Joyce Mitchell
![Page 2: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/2.jpg)
GETTING DATA OUT OF FASTER
• FASTER Search • FASTER Query• FASTER Reports• Excel Query• Simple SQL Query
![Page 3: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/3.jpg)
WE’RE GOING TO FOCUS ON THREE METHODS
1. FASTER Query2. Microsoft Excel Query3. Simple SQL Query
![Page 4: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/4.jpg)
FASTER QUERY
![Page 5: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/5.jpg)
BENEFITS OF FASTER QUERY vs. FASTER SEARCH
• More Search Types• Several Operators
(Search uses Equals or Like) • Multiple Criteria by Using “And” or
“OR” (Admin Permission Required)
![Page 6: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/6.jpg)
MORE SEARCH TYPESQUERY VS. SEARCH
• EQUIPMENT INVENTORY: 89 Query Types vs. 23 Search Types
• PARTS INVENTORY: 69 Query Types vs. 22 Search Types (PP same)
• WORK ORDERS: 32 Query Types vs. 12 Search Parameters
![Page 7: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/7.jpg)
![Page 8: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/8.jpg)
![Page 9: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/9.jpg)
Query Using Single Type
![Page 10: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/10.jpg)
Query Using Multiple Types
![Page 11: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/11.jpg)
![Page 12: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/12.jpg)
![Page 13: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/13.jpg)
![Page 14: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/14.jpg)
Using the Excel Query Wizard to Create a
Single Table Query
![Page 15: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/15.jpg)
![Page 16: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/16.jpg)
![Page 17: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/17.jpg)
![Page 18: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/18.jpg)
![Page 19: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/19.jpg)
![Page 20: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/20.jpg)
![Page 21: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/21.jpg)
![Page 22: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/22.jpg)
![Page 23: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/23.jpg)
![Page 24: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/24.jpg)
![Page 25: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/25.jpg)
![Page 26: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/26.jpg)
USE EXCEL TOOLS
• Sort files• Total & Sub-total • Filter • Attach to e-mail
![Page 27: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/27.jpg)
SIMPLE SQL QUERY
![Page 28: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/28.jpg)
![Page 29: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/29.jpg)
List of Open Parts Orders
![Page 30: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/30.jpg)
Number of PM’s Overdue by PM Type, by Equipment Type
![Page 31: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/31.jpg)
Non-Stock Parts with Annual Usage Qty > 4
![Page 32: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/32.jpg)
E-Mail List by Asset #
![Page 33: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/33.jpg)
![Page 34: Making the Most of Quick and Easy Queries Danny Brashear and Joyce Mitchell](https://reader036.vdocuments.us/reader036/viewer/2022062517/56649f295503460f94c41c57/html5/thumbnails/34.jpg)
MAKING THE MOST OF QUICK & EASY QUERIES
Questions?