tag:blogger.com,1999:blog-76570791038363078162012-04-29T05:50:28.881-07:00Evolution of a Database ConsultantGo where the work takes you.DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-7657079103836307816.post-35397208281353252872012-04-29T05:50:00.000-07:002012-04-29T05:50:28.886-07:00MS Access SharePoint Attachment FieldI recently tested a project that would be a good candidate for MS Access on Sharepoint. It is an ongoing project keying records daily from scanned images and would require at least 3 keyers daily. The advantages are obvious: ability to work remotely, centralized administration, and flexibility to distribute or redistribute work flow. I developed forms with needed validation rules for each unique image that we are keying from. Within the table design (and then forms) I included an attachment field. When an attachment field is added to a form, the first image will show. As I will only add one image per record, this works perfectly for our purpose. For management tools, I designed a separate, client application that links to the Sharepoint lists (tables). I run daily processes and updates from this "management" application. I needed a way to add all new images in a batch process daily. My images arrive as tifs since this is the default and best format on scanning images. However, this format is not "web enabled" and needed to be converted to jpg's to render in the browser. After batch converting the tif's to jpg's, I batch add them to the table with the following two-step vba functions: First, I populate a field in the table (list) with the name of the image (having all new images in a folder): <br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/-KwNFYdskjuU/T503_eaI6jI/AAAAAAAAAEg/V4IlMwj87JU/s1600/Function1.jpg" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="108" width="320" src="http://1.bp.blogspot.com/-KwNFYdskjuU/T503_eaI6jI/AAAAAAAAAEg/V4IlMwj87JU/s320/Function1.jpg" /></a></div> Then I add the attachments: <br /><br /> <div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-5lP2W76rfU4/T504EJnMBmI/AAAAAAAAAEs/ZVn9GublAs0/s1600/Function2.jpg" imageanchor="1" style="margin-left:1em; margin-right:1em"><img border="0" height="260" width="320" src="http://4.bp.blogspot.com/-5lP2W76rfU4/T504EJnMBmI/AAAAAAAAAEs/ZVn9GublAs0/s320/Function2.jpg" /></a></div><br /> NOTE: I set the process running and checked back later and found that adding 150 jpg attachments took one hour to add. Not real speedy and an obvious consideration that will make this process unreasonable for some projects. <br /><br />I have the ability to run counts, do quality control and give feedback to keyers based on the login information that Sharepoint always captures. The built in fields are "SharePointCreatedDate", "Author", "SharePointModifiedDate" and "SharePointEditor." I always add similar fields to my desktop applications but these are included in any SharePoint list. <br /><br />I found no clear instructions to this process on the web so I'm hopeful that this information will be helpful to some of you. Would love to hear your feedback.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-3539720828135325287?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com0tag:blogger.com,1999:blog-7657079103836307816.post-34749850889682024742011-11-06T07:08:00.000-08:002011-12-19T04:22:59.198-08:00Sharepoint Access Services Reporting FlexibilityI have been struggling with offering my users a flexible and powerful reporting environment in their Access Services application. In a desktop MS Access database, to give users the ability to select more than one item to apply to a single filtering criteria you can either create a custom interface/fuction with VBA or use a multi-select combobox (or listbox) with VBA. Unfortunately, VBA is not available in Access Services. Microsoft has replaced VBA with expanded Macro capabilities that, while pretty powerful, is not as flexible or powerful as VBA. Nor is a multi-select combobox available in the same way in a web database. I had to think outside the box. <br /><br />Here's what I came up with:<br /><br />In our database we have a table with contacts and a related table with lists that the contacts belong to. I created a list lookup table with the values the users can select to filter their records with the fields: SelectList(s) (Y/N), Lists, ListID. There are 55 possible lists in the lookup table. Then I designed a report selection form, placed a subform on it with checkboxes for each list selection. After selecting the list(s) the user desires and clicking "Select Lists" a macro is run that populates TempVars with the for selected list(s) ListID number. <br /><br />I designed a Query that links the Contacts table to an interim ContactLists table that then links to the SelectMultiLists table. I run a datamacro that sets the selected records to YES for the TempVars ListID. I included the SelectList field in the query and set it's criteria to "True" so that only the related records that the user has checked in the subform appear in the results. <br /><br />Back on the Report Selection form, after the user clicks the yes/no option to select their criteria, they select the report (I have 4 different report formats including labels and a spreadsheet layout appropriate for export to Excel) they want to run and a macro is run with additional If/Else/Endif structure that additionally filters the report selected. <br /><br />In this way I was able to offer reports on multiple lists and have included 3 additional criteria (state, district, active). <br /><br />I reviewed the templates Microsoft offers for Web Databases, and the Northwinds Web template and I believe what I have designed has more flexibility/options for reporting all in Sharepoint (don't have to move to the client).<br /><br />Would love to hear your feedback if you have worked with Access Services and can offer better or additional reporting suggestions.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-3474985088968202474?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com2tag:blogger.com,1999:blog-7657079103836307816.post-37579518224087635552011-09-25T14:54:00.000-07:002011-09-25T18:51:08.546-07:00My First Access Services ProjectAccess Services is Microsoft's answer to running MS Access applications on the web, in Sharepoint. The obvious advantage is that a user with login credentials can access their data from any web browser. I have completed and published my first MS Access Services project. It has been tested on an iphone/ipad and it runs just like on a PC (not quite as much fun on an iphone because of the screen size but great to have the option in a pinch). I don't know about you but I can think of lots of business needs that this might fill. Microsoft Access is the most widely used desktop database system in the world. Sharepoint is the perfect intranet environment and adding Access Services extends that usefulness.<br /><br />Challenges that had to be overcome:<br /><br />1) Office 2010 was the first release of Access Services so finding a lot of good examples and forum support is a challenge. A Google search on any MS Access features or questions returns beaucoup of resources - such is not yet the case with Access Services. Microsoft recommends http://www.utteraccess.com/forum/Access-Services-Web-Data-f74.html and I have found others like http://accessexperts.net/blog/category/access-web-database, http://channel9.msdn.com and http://dmoffat.wordpress.com. Though there are many that try to offer support, most prefice their comments with "I haven't tried this yet, but ..." It's a start, we are all learning and any effort these non-paid folks make to help should definately be appreciated. I've found posts by Albert Kallal are very comprehensive and informative.<br /><br />2) I heard a lot of buzz about the fact that you must either have Sharepoint hosted in house of pay for the hosting service. Some complained that it was too expensive. In my opinion, this is not an issue. Any serious business application on the web must be securely hosted somewhere and Sharepoint offers that security and flexibility at a reasonable price for businesses. For $49/month accesshosting.com offers 5 users and handles our needs. That is not concurrent users, concurrent users aren't limited. That 5 users is user logins. So I configured administrator, contributor and viewer users with 3 user logins to spare. Accesshosting includes a daily backup in the hosting price but will only restore back one day. This is not an adequate backup/restore flexibility for most businesses but you can upgrade backup/restore options or plan your own backup.<br /><br />2) Optimizing the design for speed. As we are running this in a web browser with multiple and varied internet speeds, making it as efficient as possible is important to it being a useable tool. My project contained about 14,000 records in the largest table and initially was too slow to load. The solution was to open the main page with a subset of the data (A-C for example) and offer the user a box to search for the record(s) they want and then query the next small subset of data. Doing this in all forms made a huge different in speed.<br /><br />3) Offering multiple report formats and filtering options. I have 10 reports including formatted labels, each report/label has 3 or more filtering options. I host with Accesshosting.com and they include SQL Reporting Services in the hosting. In this way, my users are able to generate their reports and print or export in multiple formats including PDF, Excel, CSV and more. Does the trick.<br /><br />I'm excited about the results and looking for my next project!<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-3757951822408763555?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com2tag:blogger.com,1999:blog-7657079103836307816.post-38091802320768819372010-07-04T07:10:00.001-07:002010-07-04T07:30:56.901-07:00MS Access 2010 - Sharepoint HostingI have taken the giant step of upgradng to Microsoft Office 2010 and I love it. I did not upgrade to 2007 because I chose to wait for the second iteration of this major upgrade. For MS Access 2010, the major improvement and, in my opinion, move in the right direction, is the new Access Services that makes it possible to develop an application totally for the web and hosted on a MS Sharepoint server. Data is moving to the web, we know it and if we are smart, we will get ready to support it.<br /><br />Here's how it works: In Access the developer must select "Web Database" option when starting the project. All forms, reports, Queries and events are developed with web compatibility. New macro functionality has been added to extend the capabilities. Access 2010 allows forms and reports to be published to web sites using what is called "access web services" that runs on Sharepoint software. These web based forms and reports run in any standard browser. Before publishing your project to the Sharepoint server, it is checked for compatibility and errors reported.<br /><br />Many have voiced the concern that having to run in Sharepoint creates an expense and complication that will impede this usefulness. Honestly, I had this concern at first but here's what I decided: Any URL will have to be hosted somewhere and security, user-access, multi-user conflicts in tables, etc., will need to be handled somehow. Sharepoint does it effortlessly to the developer and there are many reasonably-priced hosting services out there. You can find 30-day free trials to host and demo sites to customers if needed as well. I have used www.accesshosting.com for such a demo and been happy.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-3809180232076881937?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com14tag:blogger.com,1999:blog-7657079103836307816.post-58686987348197563282010-04-08T07:16:00.001-07:002010-04-08T07:45:32.430-07:00Go Where the Work Takes YouI have been awarded several MS Access database development projects of late that I would like to share: <br /><br />I recently completed an application for a wonderful European style bakery in Atlanta that is growing daily. The chef needed a way to control the process of receiving and tracking daily customer's orders, generating the baker's daily production reports with breakdown of dough types, dough volume required, and invoicing of customers. I worked closely with the client and we have developed a great tool that will make the daily process more efficient, easier to manage and less time consuming. Really enjoyed this project.<br /><br />I am working on modifications to an application used by a local micro brewery to manage their process. This is a challenging project as I am wading through some very different, and totally without comments, code. To further complicate matters, the original programmer and I seem to approach the process differently. An occasional challenge can be good and keep you on your toes. <br /><br />The third project is for an association that promotes a food product. Though I am modifying and adding to an existing application, I and the original programmer seem to approach the process similarly. I can more quickly understand where he is going. <br /><br />The moral of the story is: Go where the work takes you. Be flexible enough to see a need and accept the challenge.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-5868698734819756328?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com9tag:blogger.com,1999:blog-7657079103836307816.post-52596393948542156542009-12-16T05:50:00.001-08:002009-12-16T05:55:02.329-08:00We Are a Google Favorite Place!It's been almost a year since I posted (shame on me). Still here after 15+ years. We have been staying busy with a large project collecting police accident reports and validating the VINs. Been promised more to come and glad of it.<br /><br />We we're excited to receive a Google "FAVORITE PLACE" decal this week. Shows that the hard work I've been doing to promote our services on the web have had benefit. Google sent out 100,000 of the decals to those businesses that had enough clicks from their Local Business listings.<br /><br />Thanks Google!<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-5259639394854215654?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com9tag:blogger.com,1999:blog-7657079103836307816.post-5103444652257478862009-01-09T04:40:00.000-08:002009-04-02T05:15:36.154-07:00Lost a BidWe were not selected to continue in the bid process this week. A large telecommunications company located in our area gave us the honor of being included in their RFP list. We gave it our best shot but one of the things they looked at was company growth and receivables. Unfortunately our growth is flat and our receivables have gone down. We were also in the upper-middle tier on our pricing. There were some unknown variables inherent in the project that caused us to bid a bit higher. They gave about a week in a half to prepare the bid. <br /><br />It's a tough economic market and this company had previously started this project with a subsidiary company of a very large corporation. They went bust, leaving them with a failed project to start over. The moral of the story is: size may matter but it doesn't guarantee success. <br /><br />We have a strong history of successfully starting, continuing and completing projects. We have never let a customer down and had hoped that this would be considered. We are also proud of the people that have worked with us over the years. Some in our office, some from their homes. Local mothers for the most part that want to help with the family budget. <br /><br />C'est la vie! If at first you don't succeed, try try again.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-510344465225747886?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com10tag:blogger.com,1999:blog-7657079103836307816.post-34772154648707386652008-11-01T03:31:00.000-07:002008-11-04T04:11:15.621-08:00Being Prepared When the Opportunity ArisesSo I had been awarded a job capturing names and addresses from Kids Club applications for Burger King Corporation. Burger King had 6,000+ franchisees at the time and each was a distribution point for these applications. This was huge! I was given estimates of up to 20,000 applications per week. I got to work setting up an office in my garage, hiring and training people. We put six workstations upstairs networked into a Novell server. I also designed the data entry screens that we would need to key into and conversion/upload processes we would use. I wrote it in, are you ready, dBase III. This was a DOS based database language (the mother of all database systems today). It was actually very effective. I designed it as a multi-user back-end system with distributed front ends running on the local PC's. It was fast, safe and, as I said, efficient. We used it successfully for many years. My mantra was, "If it ain't broke, don't fix it." Over the years I upgraded dBase versions, finally moving into OOP dBase for Windows with SQL. I currently use MS Access, VBA and SQL. You might say I was forced into it by the business world, but I have reached an expert level and am very happy with that decision. I design screens that give me an edge in speed and accuracy. I listen to input from the people that are using the screens and constantly tweek and improve the screens and processes.<br /><br />Okay, we're ready, where's the work? We waited impatiently, checking our details and loose ends. We had set up a PO Box at the post office and were checking each morning. After a couple of days with no work, Bob the Postmaster called and said "You've got some mail here. I think you better come see this." We were excited, and thought, "Oh boy, maybe we have enough to get one or two of these girls working for a day or two. So we went to the post office, and you could have bowled us over when we saw our mail. We were brought into the back mail room, and as we walked in we saw very large orange plastic bags piled up everywhere. Bob the Postmaster walked us right toward them and said "Here's your mail." "OH MY GOODNESS! That's our mail?" "Yes, ma'am." <br /><br />After we picked ourselves up off the floor, we went home and got the truck and started carrying those big bags back to the garage. We filled up the downstairs of the garage with them. On opening the bags we found a mishmash of applications, complaint letters, letters from crazy people, little gifts from children, photos of Burger Kings loyal children customers, etc. A large part of the job was sorting and separating that mail. I can picture Rhonda, our mail sorter person, sitting with trays in her lap as she sorted through the bags. We also added several Value Added Services to our responsibilities on this job such as answering the white mail and housing a customer complaint phone line. <br /><br />Our 20,000 weekly estimate turned into 60,000 in reality, but we geared up and got it done. Needless to say, we got all six people started plus more and kept them working for over 12 years on that job. We eventually rented a local office space, as the job warranted. Burger King franchisees considered this their most effective marketing to date. We only stopped doing it after they awarded their marketing to a different company that chose to use their own in-house vendor. We have recently noticed that Burger King is collecting all the applicants directly online. Karen was the account director for the Burger King Kids Club and who we answered to. She is my idea of a great manager. She was no push over and could be tough and tenaciously accomplish her goals while being reasonable and fair at the same time. She gave us a glowing reference that will ever be appreciated. <br /><br />They were good years, and we appreciate the opportunities that we were given and the great contacts we made. We kept ourselves working and created in-office and at-home jobs for some good people. At one time we had twelve in-house employees and 40 local people typing at home as sub-contractors. We continue to use some of those same people today and enjoy running into the others around town. A good case for always being fair and kind.<br /><br />Have you had any memorable job experiences you can share?<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-3477215464870738665?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com4tag:blogger.com,1999:blog-7657079103836307816.post-20520292420265610082008-09-24T18:14:00.000-07:002008-11-01T03:30:49.886-07:00Starting a Data Entry CompanyOkay - ages since I blogged but here goes.<br /><br />I left off the Day of Small Things when I lost the job keying insurance forms for a doctor's clinic. From there I again went and found employment out of the house and had to have my son's stay in after school. I was traveling about an hour to work and my husband often made it to school to pick up the kids before me. I started out in a temporary position (Kelly Girls) as a specification typist for a design/engineer company. When a position opened up for an Administrative Assistant for one of the principles, I got it. I moved from there into IT support when a new network was installed (all the new high tech stuff). I enjoyed the job until the company started having financial trouble and a lack of jobs. They began laying off and soon closed up the office and moved the operation to Boston. Again I found myself looking for work. Only this time I had a little severance money. My husband and I thought it out: what could I do to make our lives easier, to be there for our sons? We decided that I would get some schooling in computer networking and get certified as a Novell Network Engineer. I took the classes, passed the seven tests and got my certification. Now maybe I can get something with more flexibility and closer to home. Sorry Charlie, I hunted for a job for a long time and it seems that I was more marketable as a secretary. However, I got a call from someone who knew someone I knew that needed a network installed in their office. It was a very large printing company - American Signature. They had just procured a job managing and processing a Kids Club for a major fast food company. I managed to present them with a network plan and a design for their data entry keying screens and data processes. <br /><br />This was my real start. They decided not to do the data entry and processing in-house themselves and let me bid on it. I got the job! We had to get to work. To be continued....<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-2052029242026561008?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com14tag:blogger.com,1999:blog-7657079103836307816.post-85953346704982119352008-08-10T10:43:00.000-07:002008-11-01T05:28:51.942-07:00Don't Despise the Day of Small ThingsIt's been a while but I am back to continue the story of my work from home saga. I left off with the purchase of an IBM Mag card machine and I was starting to solicit work. As I mentioned, we left notes on bulletin boards at the local colleges, told everyone we met, and ran an ad in the paper.<br /><br />I started to get calls from students that needed their thesis and other papers typed. The going rate was $.35 per page but I was glad to be doing something to make some money while at home with the kids. Many times the work came in the afternoon and they needed it done by the morning. I would work late into the night to get it done. That was actually okay for a while because the kids were in bed. Needless to say, that can get old and sometimes did.<br /><br />Shortly after my start up venture I received a call from a doctor that needed his insurance forms keyed and filed. This doctor specialized in geriatric Medicare and Medicaid patients. I went into his office for a meeting and he explained the job. We arrived at a deal and I happily went home to figure out how I would accomplish it. It was about this time that I upgraded my equipment to a PC. This PC was far from the desktop PC's we are using today. It was a SANYO computer, had 64 KB (not MB) of memory, did not have a hard drive, had a 5 1/4" floppy drive that the operating system (a predecessor of DOS called CPM) and all programs would run off. It came a "suite" of software applications that included WordStar, DataStar and a spreadsheet that I have forgotten the name of. I knew I could key them with WordStart but it was a great deal of work, besides I was only making 35 cents per filing. At that rate I might make $5.00 per week. I starting playing with DataStar to see if I could automate it and save time and eventually came up with a good system. I worked for this doctor for a good while and only lost the job when he stopped practicing.<br /><br />What I learned from this was that if you are diligent, don't turn down work, don't think too much of yourself to take a lower paying job, and use your brain; you can usually figure out a way to be more productive, give a good product and compete with others if there is a fair playing field. I add the fair playing field because there are some occasions when it is not possible to be competitive. As an example: I gave a bid on some work last year and the customer came back to tell me that I was a few cents per record more than their bid from China. I do not consider that a fair playing field. As I'm sure most readers understand, China has different labor laws (I am happy to have fair labor laws) and lower overhead than we do. What may level out that playing field is that English is our first language, there is the ability to more closely manage the job, we are in closer proximity and when the customer calls we personally answer the phone and understand their job. There is also some expense, loss of control and risk involved in sending the work to an out-of-country service provider, either in hard copy or electronically.<br /><br />That's all the <a href="http://www.dataplus-svc.com/">data entry </a>story for today. To be continued with the next post . . .<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-8595334670498211935?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com5tag:blogger.com,1999:blog-7657079103836307816.post-44456832199873569012008-07-11T05:58:00.000-07:002008-08-11T05:14:56.297-07:00Sharing What We've LearnedI want to be clear - if the job allows, I <em>occassionally</em> hire at-home typists to do data entry for my company but .... when I get good people they stay. So my purpose in blogging is not to give false hopes that I have lots of jobs but to share the things I have learned over the last mmm years.<br /><br />Now I know that I shared some of this in my first blog but I would like to fill in some of the details today. I can remember what it was like to have a baby in arms and have to go out and find a job. One of my jobs was as a bank teller. I had been a bank teller when I was single up in New York before we moved to Georgia so it was a natural choice. I took about a dollar an hour less in Georgia then I made in New York but it was what I could find. If I remember correctly, I was making $4.00 per hour. I was nursing my little guy when I started working and found that to be a problem. A couple of times embarrassingly so! Leaving him in the care of others broke my heart. We didn't have family nearby so it was a leap of faith to put him in child care. Neither he nor I were happy campers.<br /><br />I struggled with it for a while but when my friend Chris mentioned that she had worked for IBM up in New York doing "word processing" and that it paid much more than a bank teller (which at the time was considered up there with programming), I was in. Thank you Chris. She and I found a class at a local technical school down in Atlanta and enrolled. It was in a rough neighborhood but our husbands would drive us up to the door, go and keep themselves busy with my son for awhile and come back and pick us up. This opened a whole new world for me. I loved it and found that I had a knack for it. My friend and I both got an A in the class! We started looking for used word processing equipment and found an old IBM mag card typewriter. It was basically the old selectric typewriters (great machine) that had an added box that saved everything you typed on a magnetic card. Then you could load it up and make changes. It sure beat white out on those long papers. Wow, we've come a long way baby.<br /><br />I quit my job at the bank and started working temporary jobs through Kelly Girls. Had some interesting temp jobs including IBM, First National Bank of Atlanta Credit Policy, and engineering company typing specifications, etc. Needless to say, this did not help my issues of balancing being a mom and paying the bills at the same time.<br /><br />So, I wanted to work at home. I thought with my old mag card machine I could do it. My husband and I would go out in the evening to local colleges and post notes on the bulletin boards. I ran an ad in the paper and told everyone what I wanted to do.<br /><br />To be continued . . .<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-4445683219987356901?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com5tag:blogger.com,1999:blog-7657079103836307816.post-70472694211705932912008-06-25T05:26:00.000-07:002008-11-01T05:27:24.116-07:00Have Kids - Help them Adjust to your Work at HomeSo you finally have a job working at home. Just what you've been hoping for. You are set up and the kids are outside playing, you sit down to type and:<br /><br />Here comes little Jimmy crying. Big brother hit me and won't let me play with him. Whaw, whaw, will you play with me. What am I goin to do. <br /><br />Well, Mom, it will take a little patience and creativity to help your children adjust and understand your new schedule. The first thing you can do is consider their schedule and try to work around it. If they are in school during the day, your in like Flint. But what about the summer when they are around the house and bored. Try to plan activities that will keep them busy (a little TV is okay but we all know too much is a bad thing). Do they have some hobbies that they can be involved in during the day, day camp during the summer, can you see them playing in the yard while you are working inside. I actually designed our house so that I could see the kids while I was on my PC. If the kids are loosing it, fighting and crying, take a break, go get an ice cream. Explain to them how their understanding with your new job will help them also. Maybe it will make it possible for the family to make a trip to Disneyland. Now before they demand your attention they may think about that trip to Disneyland. <br /><br />Can you work in the evening when Dad is home and spending some quality time with his children? <br /><br />Sometimes you will find it difficult but hang in there and be patient. It will get easier with time.<br /><br /><a href="http://www.dataplus-svc.com/Employment.htm">Data Entry Services - Database Programming</a><br /><br />Do you stay at home, work at home or just want to be at home? Visit <a href="http://www.thelightkeeper.com/">The Light Keeper.com</a>, a site dedicated to those who Keep the Light at Home! You'll find articles, ideas, links, resources, information, tips - everything you need to help Keep the Light in your home. Sign up for our free newsletter, too!<br /><br /><a href="http://technorati.com/faves?sub=addfavbtn&add=http://www.workathomeencouragement.blogspot.com"><img src="http://static.technorati.com/pix/fave/tech-fav-1.png" alt="Add to Technorati Favorites" /></a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-7047269421170593291?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com5tag:blogger.com,1999:blog-7657079103836307816.post-15481734320628216752008-06-25T05:09:00.000-07:002009-04-02T05:18:09.456-07:00Managing Your TimeThe NUMBER ONE reason home workers fail is bad time management. A lot of the contractors that we have used over the years are moms so I will present this from that perspective.<br /><br />Strategies:<br /><br />Get up early. If you rise 30 - 45 minutes before the rest of the family you will a few minutes to collect your thoughts, have a cup of coffee and start the day prepared.<br /><br />Have a plan: what needs to be done today. Do you have 5 hours of data entry plus need to pick up the kids and go to ballet lessons. Write down on a note pad what you are going to accomplish and when. This will also help you see if what you are expecting of yourself is realistic. Don't forget to leave a few minutes for personal time and the little chores that will creep in. You might have some items that need to be done through out the week that are secondary. Do most important thing first. Use discipline and stick to the Plan!<br /><br />Group your running around: If you have to drop the kids at practice and pick them up in an hour, do your grocery shopping. <br /><br />Get enough rest and relaxation time: Don't fall into the habit of not getting enough rest - it will catch up with you. Ask me how I know. Set some time to go for a walk with your family or get an ice cream. It will keep you balanced and your family will not resent your job (so much).<br /><br /><a href="http://www.dataplus-svc.com/Employment.htm">DataPlus Data Entry Services</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-1548173432062821675?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com4tag:blogger.com,1999:blog-7657079103836307816.post-11883714166122185812008-06-25T04:41:00.000-07:002008-11-01T04:46:25.071-07:00How to Loose a JobI have had many employees, home contractors and job applicants over the the years. I would like to share some of my observations and experiences with them. <br /><br />EMPLOYEES<br /><br />PERFECT: She shows up for work on time and dependably, will do anything asked in fact looks for ways to be helpful to me and her coworkers. She recognizes that the company must be profitable in order to be viable and keep her employed and works toward that end. She is pleasant to be around. She will be with me as long as I can keep her.<br /><br />OKAY: She shows up late occassionally (currently we have a casual flex schedule that works well for us but, in the past, some jobs required a regular schedule), grumbles about what projects she is assigned or complains that somebody else has an easier project, but when all else fails, she does her work fine. I consider her a good employee but guess who is staying if I have to make a choice?<br /><br />NOT SO MUCH: Complains, not dependable, sloppy work, arguments with coworkers, etc., etc. She's gone as quickly as possible. <br /><br />CONTRACTOR<br /><br />Pretty much as above but not under my supervision. <br /><br />PERFECT: The ideal home worker is dependable, never falls off the map, cares about doing a good job and takes responsibility for the quality of her work. She will also not complain about assignments and makes her self available for whatever needs to be done. I will try my best to keep this person busy and happy.<br /><br />NOT SO MUCH: The problem home worker pretty much likes the idea of working at home and would like a check but isn't really into the work stuff. She may be unavailable when needed and will be gone ASAP. She makes excuses about missing deadlines and begs more time (because she hasn't managed her time well). You would be amazed at home many of these we have hired, trained, set-up and supported over the years. Turned out I was the one working at their home - not them.<br /><br />APPLICANTS<br /><br />PERFECT: Applicant 1 shows up on time, neatly (but casually dressed for us is okay), passes the typing test without a problem, asks about what our needs are and sincerely considers how it fits with her situation. This person is my ideal.<br /><br />NOT SO MUCH: Applicant 2 may show up late and not call, gives me a headache with her perfume or cigarette smell, may have a child with her that cries and demands while we are trying to talk, can't pass the typing test (hasn't practiced as I always suggest), is unorganized, asks all about what the job will do for her and tells me all about her requirements for a work at home job. Has no idea (nor does she care) about the companies needs to be viable.<br /><br />Guess who got the job!<br /><br /><a href="http://www.dataplus-svc.com/Employment.htm">DataPlus Data Entry Services</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-1188371416612218581?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com2tag:blogger.com,1999:blog-7657079103836307816.post-2873662523025157752008-06-16T09:27:00.000-07:002008-06-30T06:18:17.409-07:00Some of the Best Work at Home Advice on the WebAfter writing my first blog I did some research of what other sites and blogs were out there on the subject. Most of them are scams and a waste of time but there are a few that have value that I thought I would share with you.<br /><br />On the EHOW website there is a blog: <a href="http://www.ehow.com/how_2289441_work-home-data-entry-jobs.html">How to find work at home data entry jobs</a><br />that has some practical advice. She reviews some of the equipment you might need, encourages you to begin networking with local businesses to learn what unique needs they might have and introduce your capabilities. <br /><br />I found the information on <a href="http://www.thelightkeeper.com/wah/ideas/dataentry.htm">The Light Keeper - a website for at home parents</a> to be varied and useful. Not only does Angella Kay present ideas for working at home with some Links and Resources, she has suggestions related to Money, Parenting and a Scam Watch page.<br /><br /><a href="http://www.dataplus-svc.com">DataPlus Data Entry Services</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-287366252302515775?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com2tag:blogger.com,1999:blog-7657079103836307816.post-20192446616492748142008-06-13T04:29:00.000-07:002008-08-20T05:41:53.259-07:00Work from Home - How I did it and you can too!I am ?? years old, I have two happily-married grown sons, and I own DataPlus (<a href="http://www.dataplus-svc.com/">http://www.dataplus-svc.com/</a>). DataPlus is a small but successful data processing company located in Georgia and I actually from time to time hire contractors to work at home typing. We have been in business for over 20 years and I would like to share my story with you.<br /><br />It seems like yesterday that I was in the same position as many of you young mothers. I wanted to give my kids the best of a mom but saw the need to contribute to the household income. My husband, I and our one year old son had moved to Georgia from New York. We were hopeful that we could make a life, earn a decent living, and buy a home. We were poor as a church mouse. If we could have caught the mouse we would have eaten him. Though I hated to leave my baby, I had to find work out of the house at that time. It wasn’t ideal but we did our best.<br /><br />By the time my second son was born I was bound and determined not to leave my boys again. I posted notes on bulletin boards at local colleges to type school papers, ran ads in the paper for typing, delivered telephone books, and anything else I could think of. I remember typing into the wee hours of the morning when the kids were asleep and the house was quiet. I made far less than I should have for the work I did but it was worth it to be home for the kids. I picked up a job typing insurance claims for a doctor that ran several clinics. We bought a state of the art PC that had no hard drive, 64K of RAM and a 5 ¼” floppy. It came with WordStar and DataStar, one of the first database applications, and I started learning to make custom screens and look up tables to make my work go quicker. Unfortunately the doctor was cheating on his Medicaid bills and got closed down and the job ended but it opened a new work world to me. I continued to learn programming, moving on to dBase, Basic, MS Access, Visual Basic, SQL and others. When the kids were in school I took some training and got certified as a Novel Network Engineer.<br /><br />Along the way I got a couple of breaks. The first was being awarded a job keying all of the Burger King Kids Club applications. We set up the garage with desks and my PC. The work showed up in giant plastic bags, thousands and thousands of applications. Somebody had been overcome with the volume and given up. I hired my oldest son and his buddy from across the street to open and sort mail. We ran ads and started hiring and training home workers to key in the custom screens that I designed. We caught up but the job lasted another 12 years. Some of those same girls are still working with me today. Though that was the first job, it got us going and there have been many good customers since.<br /><br />The moral of the story is: don’t give up, keep your eyes open for opportunities, work hard, and learn everything pertinent you can. Maybe you’ll be telling your story to young moms in a couple of years!<br /><br /><a href="http://www.buildabetterblog.com/">Build a Better Blog</a><br /><br /><a title="Business" href="http://www.blogtoplist.com/business/"><br /><img alt="Business" src="http://www.blogtoplist.com/tracker.php?u=46465" border="0" /></a><br /><a href="http://www.blogtoplist.com/vote.php?u=46465" target="_blank"><br /><img alt="Top Blogs" src="http://www.blogtoplist.com/images/votebutton.gif" border="0" /></a><br /><br /><a href="http://www.howamazing.com/">How Amazing Directory</a><br /><br /><br /><a href="http://www.1800miti.com/links/info/data_svc.html">Find us on 1800miti.Com</a> A new way to look at the world.<br /><a href="http://www.mfad.net/" target="_blank">Business Directory</a> <a href="http://www.mfad.net/data-management,1585.html" target="_blank">Data Management</a><br /><br /><script src="http://api.bumpzee.com/bzrecentjs.php?id=3eeebe968c92ef77991314c7a2c7dc18&entries=0&width=200&visitors=12&border=ABE637&bg=FFFFFF&headbg=ABE637&txtcolor=003300&link=336600&cols=4&headtxt=Recent+Visitors&oln=1" type="text/javascript"></script><br /><select onchange="document.location.href=" name="jumpit"><option value="#">Bookmark this</option> <option value="http://del.icio.us/post?url=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services">del.icio.us</option> <option value="http://www.furl.net/storeIt.jsp?t=Data Entry - Capture - Processing - Programming Services&u=http://www.dataplus-svc.com">Furl</option> <option value="http://www.google.com/bookmarks/mark?op=edit&bkmk=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services">Google</option> <option value="http://ma.gnolia.com/bookmarklet/add?url=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services">ma.gnolia</option> <option value="http://www.netscape.com/submit/?U=http://www.dataplus-svc.com&T=Data Entry - Capture - Processing - Programming Services">Netscape</option> <option value="http://www.netvouz.com/action/submitBookmark?url=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services&popup=no">Netvouz</option> <option value="http://www.rawsugar.com/pages/tagger.faces?turl=http://www.dataplus-svc.com&tttl=Data Entry - Capture - Processing - Programming Services">RawSugar</option> <option value="http://reddit.com/submit?url=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services">reddit</option> <option value="http://www.shadows.com/features/tcr.htm?url=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services">Shadows</option> <option value="http://simpy.com/simpy/LinkAdd.do?note=Data Entry - Capture - Processing - Programming Services&href=http://www.dataplus-svc.com">Simpy</option> <option value="http://www.sphinn.com/submit.php?url=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services">Sphinn</option> <option value="http://www.stumbleupon.com/submit?url=http://www.dataplus-svc.com&title=Data Entry - Capture - Processing - Programming Services">StumbleUpon</option> <option value="http://myweb2.search.yahoo.com/myresults/bookmarklet?t=Data Entry - Capture - Processing - Programming Services&u=http://www.dataplus-svc.com">Yahoo MyWeb</option></select><br /><div style="font-family: Verdana,Arial,Helvetica,sans-serif; font-style: normal; font-variant: normal; font-weight: normal; font-size: 9px; line-height: normal; font-size-adjust: none; font-stretch: normal; width: 100px;"><a href="http://www.toprankblog.com/tools/social-bookmarks/">Social Bookmarking</a></div><br /><br /><script src="http://digg.com/tools/diggthis.js" type="text/javascript"></script><br /><br /><a href="http://www.blogsthatfollow.com/">Blogs That Follow</a><br /><br /><select name="jumpit" onchange="document.location.href=this.value"><option selected="selected" value="#">Bookmark this</option><option value="http://del.icio.us/post?url=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience">del.icio.us</option><option value="http://www.furl.net/storeIt.jsp?t=My Work from Home Experience&u=http://www.workathomeencouragement.blogspot.com/">Furl</option><option value="http://www.google.com/bookmarks/mark?op=edit&bkmk=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience">Google</option><option value="http://ma.gnolia.com/bookmarklet/add?url=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience">ma.gnolia</option><option value="http://www.netscape.com/submit/?U=http://www.workathomeencouragement.blogspot.com/&T=My Work from Home Experience">Netscape</option><option value="http://www.netvouz.com/action/submitBookmark?url=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience&popup=no">Netvouz</option><option value="http://www.rawsugar.com/pages/tagger.faces?turl=http://www.workathomeencouragement.blogspot.com/&tttl=My Work from Home Experience">RawSugar</option><option value="http://reddit.com/submit?url=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience">reddit</option><option value="http://www.shadows.com/features/tcr.htm?url=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience">Shadows</option><option value="http://simpy.com/simpy/LinkAdd.do?note=My Work from Home Experience&href=http://www.workathomeencouragement.blogspot.com/">Simpy</option><option value="http://www.sphinn.com/submit.php?url=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience">Sphinn</option><option value="http://www.squidoo.com/lensmaster/bookmark?http://www.workathomeencouragement.blogspot.com/">Squidoo</option><option value="http://www.stumbleupon.com/submit?url=http://www.workathomeencouragement.blogspot.com/&title=My Work from Home Experience">StumbleUpon</option><option value="http://myweb2.search.yahoo.com/myresults/bookmarklet?t=My Work from Home Experience&u=http://www.workathomeencouragement.blogspot.com/">Yahoo MyWeb</option></select><br /><div style="font-family: Verdana,Arial,Helvetica,sans-serif; font-style: normal; font-variant: normal; font-weight: normal; font-size: 9px; line-height: normal; font-size-adjust: none; font-stretch: normal; width: 100px;"><a href="http://www.toprankblog.com/tools/social-bookmarks/">Social Bookmarking</a></div><br /><br /><a href="http://bloggeruniversity.blogspot.com/"><img src="http://farm3.static.flickr.com/2395/2490736652_98110917fa_o.png" border="0" /></a><br /><br /><script language="javascript" type="text/javascript" src="http://rpc.blogrolling.com/display.php?r=5980d32fb810e4e6218031c43c6e39f4"></script><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7657079103836307816-2019244661649274814?l=workathomeencouragement.blogspot.com' alt='' /></div>DataPlus - Custom Data Serviceshttp://www.blogger.com/profile/08436982049701752461noreply@blogger.com2