go_a03_grader_h3_career_books.accdb
| Title ID | Title | Author Last Name | Author First Name | Publisher ID | Category | Copies On Hand | Value of Books |
| T-01 | Competitive Interview Prep | Hubert | Gretchen | PUB-100 | Interviewing Strategies | 4 | ¤ 175.00 |
| T-02 | Conversation Ice Breakers | Stein | Herbert | PUB-108 | Interviewing Strategies | 1 | ¤ 90.00 |
| T-03 | Dressing for Interview Success | Thornton | Perry | PUB-102 | Interviewing Strategies | 4 | ¤ 175.00 |
| T-04 | Fifty Standard Interview Questions | Becker | Colin | PUB-103 | Job Search | 8 | ¤ 250.00 |
| T-05 | Hot Jobs | Sinclair | Janice | PUB-104 | Job Search | 3 | ¤ 200.00 |
| T-06 | Job Fair Success | Cunningham | Charise | PUB-105 | Job Search | 10 | ¤ 450.00 |
| T-07 | Phone Interview Success | Chu | Fong | PUB-100 | Interviewing Strategies | 10 | ¤ 420.00 |
| T-08 | After the Interview | Ramirez | Raphael | PUB-102 | Interviewing Strategies | 12 | ¤ 525.00 |
| T-09 | Entry Level Job Search | Doyle | Caryn | PUB-103 | Job Search | 5 | ¤ 325.00 |
| T-10 | Internship Search | Boykin | Dimitri | PUB-104 | Job Search | 4 | ¤ 400.00 |
| T-11 | Professional-Level Job Search | Ortiz | Ricardo | PUB-105 | Job Search | 6 | ¤ 300.00 |
| T-12 | The Best Use of a Cover Letter | Burke | Kay | PUB-106 | Job Search | 10 | ¤ 325.00 |
| T-13 | Finding Hiring Employers | Blanchett | Donald | PUB-107 | Job Search | 7 | ¤ 275.00 |
| T-14 | New Dress for Success | Gregerson | Margo | PUB-108 | Interviewing Strategies | 12 | ¤ 525.00 |
| T-15 | First Impressions | Epstein | Lonnie | PUB-109 | Interviewing Strategies | 10 | ¤ 420.00 |
| T-16 | Interview Techniques and Resume Tips | Erwin | Paulette | PUB-109 | Resumes | 13 | ¤ 525.00 |
| T-17 | Resumes in Cyberspace | Smith | John | PUB-107 | Resumes | 11 | ¤ 420.00 |
| T-18 | Mastering the Interview | Jameson | Susanna | PUB-101 | Interviewing Strategies | 2 | ¤ 125.00 |
| T-19 | Smart Answers to Tough Questions | Smith | Gary | PUB-100 | Interviewing Strategies | 1 | ¤ 75.00 |
| T-20 | Jobs of the Future | Greene | Sharon | PUB-104 | Job Search | 3 | ¤ 325.00 |
| T-21 | Mastering the Job Market | Khan | Alexis | PUB-102 | Job Search | 3 | ¤ 400.00 |
| T-22 | High Tech Jobs | Peterson | Karen | PUB-103 | Job Search | 5 | ¤ 300.00 |
| T-23 | Find the Right Job for You | Lufton | Louisa | PUB-100 | Job Search | 3 | ¤ 200.00 |
| T-24 | High Tech Career Paths | London | Eric | PUB-102 | Job Search | 6 | ¤ 400.00 |
| ID | mSysRowId |
| 1 | 3mVbpKC+gWGNqYyAtm6j663Pzjdf8ggkuMS9YB2j5wQ=-~lAom/djYrGN2/zzKWgruxw== |
| Publisher ID | Company Name | Rep Last Name | Rep First Name | Job Title | Phone Number | mSysRowId |
| PUB-100 | AAA Career Books | Visyas | Victoria | Sales Representative | (512) 555-0054 | Gyn0bNxpYhIXaFEg8GQW4JGjV+CBi3S5f008ROxGgj0=-~aMZ2o2k6B4tuEQcS68bW9Q== |
| PUB-101 | Career Consultants Inc | King | James | Sales Associate | (512) 555-0071 | KWbakvDO76MGC9AoQxxUWc+hXaupRO41VlATiCMDLCA=-~+ecNF++09kwKx7aoYo9+NA== |
| PUB-102 | Executive Press Associates | Phelps | Pauline | Regional Manager | (512) 555-0063 | vpZcp3ogoYngIldqyNU7Y154D6s+GhLMpt5ypad1xko=-~jcjv77f3Hoi/kNRAB7B0Aw== |
| PUB-103 | Conner, Dunne, & Murphy Publishers | Hernandez | Hector | Sales Representative | (512) 555-0012 | TT/YKlD8B4yBFy3rhd0P1b2s/QdmEv85e6IH+a87zF8=-~LvsSnYoMFI8urdoIcfZyFw== |
| PUB-104 | Employment Central Ltd | Mizumori | Raymond | Sales Representative | (512) 555-0041 | vSVHBtBNCDYWYWXafGNGZasFgp6pMY+3R+XIQJP1SRw=-~Bhqu7thaYco3CDocqjPVFQ== |
| PUB-105 | Yellow Rose Publications | Nguyen | Timothy | Sales Representative | (512) 555-0051 | rMvuHV0nIOkMXL9GdrPYQQD/Qcw3PcMkNxASMzUmrGM=-~uww1h0HQTmSa+BC931CVuA== |
| PUB-106 | Woodward Publishers | Lamb | Anne | Technical Sales Rep | (512) 555-0065 | xdYSytn3ClN9+cTzYGOqqcqIUvpNbHTKKOJWMQ5aB5Y=-~k88tdxEEj5OaujK/64W7aQ== |
| PUB-107 | Careers R Us | Butler | Benjamin | Sales Associate | (512) 555-0098 | 97FvQLDV3yYE0ypCOCoHw5Fvemql7JFVPJYgLF6VPV8=-~AmafAMpQyn16GaVW1wblDQ== |
| PUB-108 | Austin Publishing | Soto | Jacob | Sales Associate | (512) 555-0064 | 0g482mnCedwFU27nGJ79Y24nkpQalncHAikDyiat5qM=-~otz2V3h2ioprHuN7Zu/ZEg== |
| PUB-109 | Carliz Publications Inc | Bryant | Robert | Sales Representative | (512) 555-0063 | xcC2MnGu46HRvAvQotv/crG7nfQnN02PneMluGKRr6w=-~QzgvHKcIhOa1piAEw/idDg== |
| PUB-110 | Kyle Tyler of New York | Molvik | Sergei | Sales Representative | (512) 555-0072 | /AhlF/BmgYs8GLuaRurZ6flc033d/oVxami1nrqQmU0=-~33ueG6rm1HUoe9YeuJU5Yw== |
SELECT Publishers.[Publisher ID], [Career Books].Category, [Career Books].Title, [Career Books].[Author Last Name], [Career Books].[Author First Name], Publishers.[Company Name]
FROM Publishers INNER JOIN [Career Books] ON Publishers.[Publisher ID] = [Career Books].[Publisher ID]
WHERE ((([Career Books].Category) Like "*res*" Or ([Career Books].Category) Like "*interview*"))
ORDER BY [Career Books].Category, [Career Books].Title;
juicywang
