she works for. And another table has the name of every department number. How do we go about building a QBE that answers: What is the name of the department that employee XY works for?
120244
Build a view that joins your two tables.\n\ncreate view EmployeeDepartmentDetailView as Select tblEmployee.*, tblDepartments.* from tblEmployee JOIN tblDepartments ON tblEmployee.departmentNumber = tblDepartments.departmentNumber;\n\nThen do a select on this new view:\n\nselect departmentName from EmployeeDepartmentDeailView where employeeName = 'xy'.
541419
Best way is to have 2 tables.  A header and details table.\n\nThe header table will have one row per sale.  Key field would be invoice number.\n\nThe detail table will have details of each sale.  One row per item.  Key field would be invoice number and item number\n\nJoin field would be invoice number.
75042
I am so glad you asked this question. I work in the marketing dept. One thing is I have to account every day where I have been who I have seen and who I spoke with. I have also encouraged my boss to check up on me at any time.\n I also set up care and do care plan as well with home health. I also have asked my boss to check up on why if they did not go with our company, which is not very often that they do not sign with us. I want to know if I need to add or not say something.\n Then I have spreadsheets of where I have been and who I have talked too where and when. I turn them in weekly and write if it’s an AB or C possibility.\n\nFirst you must assess your organizational needs\nDo you understand 'Client/ patient’s service and needs’?\n Are we doing quality control on the aide’s nurses and marketer’s .Calling the home and doing patient checks.\nIdentify your gaps and prioritize your new hires into skill level meaning A, B, C level great aide being an A does charting reports problems with patients has complements from patients and families.\n \nManaging \nExpectations, gets jobs quickly and on time\nRecruiting and interviewing knows job descriptions inside and out great interview skills, orientation skills, reviewing benefits with employees, training them on equipment\nHow well does the employee communicate with the mangers and nurses.  \n \nHow well do the management motivate and reward the employee \nHow does the employee step up to problems?\nHow well organized is the employee.
139150
class Employee {\n   String employeeName;\n   int employeeNumber;\n   String employeeLevel; // you may want to change this to an integer.\n   String jobDescription;\n   double salary;\n....\n}
481325
Create a query with all of the fields you want in the report\n\nIn the criteria area under the department field put this\n\nLike [Enter Department Name] and between #[Enter Start Date]# and #[Enter End Date]#\n\nThen create a report based on the query and it will give you a repot that only includes the department you asked for
487496
you just for a appending of the datas ...\nThe dept name should be taken the add the last two didits of year then add the numbering... have each in seperate column and append them
294869
Go to the required skills section of the Job Description. For each skill the job requires, think of how your friend meets or exceeds that skill and provide an example. What industry is the job in? If it's a bank: hightlight how moral and ethical your friend is. If it's in the fashion industry - highlight his/her creativity. You get the jist!
424329
It's called a conflict of interest.  How can he be an employee and competitor at the same time?  He may use info from DK at his own company and dip in on their profits.  Would you want your competition knowing all your secrets?  I think not. They made a wise business decision-- that's all.
340595
Well, somehow I doube she lost her job over just one complaint unless her boss is a total jerk. Sometimes events like this are just the tipping point. Besides, since when do people get to choose their waiter? Since when does a boss not take their own employee's say into things? I'd keep these questions to myself, but then look a little deeper.
195284
The usual way to do this is to have 2 tables.  One table for your purchases (i.e. the items you are bringing into your inventory) and another table for sales (i.e. the items that are going out of your inventory).  The common link is a part number (i.e. some unique number to identify each item).\n\nYou need to load each item purchased and qty. into the "purchases" table and load each item sold and qty sold into the "sales" table.  If you purchase and sell the same items over and over you can just keep adding rows to your purchases and sales table.\n\nTo see what you have on-hand you make queries that sum up all the purchases by part number and sum up all the sales by part number.  You join these together and include a formula to subtract sales from purchases.  The result is what you have on hand.\n\nDoing it this way gives you a running history of what was purchased and sold.  You never have to change or replace your original data - you just let the system do the math to tell you what's on-hand.
505130
ask her for references and check the BBB.
177243
You'll need to create a database using MySQL, Microsoft SQL or something similar, and pick one of the computers to be the main repository or master. You fill the database up with the current information then copy it to a second database in the other computer, using a second copy of the same software. You then set the two databases to "talk" to each other; during the "conversation" they have, they will update each other with the changes made, no matter where they have been changed. \n\nI'm not sure if you can do this with Microsoft Access but to get it to work right, you'll need a database administrator to make the initial setup and show you how to make the two Quickbooks talk to each other. It is a pretty common task so any decent database admin should be able to get it up and running in less than a day unless your Quickbooks has something quirky about it, or unless you have a lot of data to translate over.\n\nIt's hard to find a reasonably priced freelancer for such a short job because freelancers and consultants usually want a couple weeks' worth of work before taking a project. I'd recommend talking to some friends to see if any of them know a good IT guy in their office (sounds like your office is pretty small). If you can find the tech to do it, I can tell you exactly what to ask for in Microsoft talk. \n\nAlternately, you can consider converting the QuickBooks into an online database program which would be accessible from anywhere that you have an Internet connection, and it would be real-time; if your secretary updated something, you'd see it in an instant. I'm not sure what features you need so I can't recommend one but go to your choice of search engine, and search for "online database" then go browsing!
192819
when u create table in design view,and select field. there is look up option ear general TAB.click on that tab if u have text field then u r able to change it and make combo. then u have to give reference combo to perticular table field by using query
169466
Simple!  Once the person on the other end has answered, ask to speak with the person in charge of all purchases in the office.  I am an office manager.  We get those types of calls every day.  Of course, my secretary screens the calls, but that is how they present the question.  That is the only way I could tell you to find out.  Good luck.
397146
If you want to make the article more interesting, ask something about before she was a math teacher. Before college even. What she originally wanted to be when she was young, and what led to this career choice. Or ask if she has a personal motto for herself.
597472
I would look at the Indiana Companies Database book. I forget the real name. Its lists all major companies in IN with some info on them, what they do, who to contact, etc. I actually have one at home. What do you mean by employee friendly? \nTheres a list of family friendly companies nationwide by Working Mothers Magazine as well.
332577
I think I would have to tell all the caddie women that you work with to BITE ME.  Where do they get off making you pay for the money.  I say until they can prove you stole anything, then you don't have to pay for it. Start designating the register to one person and leave it solely in their hands. 12 people is way to many to have in one drawer.  Just for that I would never pay it back.  Not unless I took a lie detector test, and it had proved that I had stolen it.  Girl look for another job.