|hcs consulting group.|
|we make complex systems simple|
by albert d. kallal
thursday, january 03, 2002
a hot knife through butter
over the years i have been exposed to a good many development systems. these systems have always been database products in one way or another. data systems are the life blood of any company, and thus tend to have the most value to a company, and also usually the largest investment in money and time.
along the way, each system has tended to have certain features or benefits that stand out. time changes, and many of the products i have used either change, or go by the way side.
part time jobs without investment for studentsChapter 4: Affiliate Marketingamazon part time remote jobs
online encoder work from homeStaffing agencies specialize in connecting job seekers with employers. Many staffing agencies have a specific focus on administrative and clerical positions, including data entry. This can be a good option if you are looking for more stable, long-term part-time work.Does Amazon pay you to work from home
however, those really great features from each product stick in my mind.
just what do those great features in those products have in common? just what makes a great software tool?
great features in products are those that enable a developer to *model* real world solutions with ease.
part time evening driving jobs near meAttention to Detail: Data entry professionals should have excellent attention to detail to ensure that the data is accurate and complete.part time work from home jobs for students
part time job on mobile at home without investmentAnother popular online part-time job is working as a virtual assistant. Virtual assistants are responsible for a wide range of tasks, including email management, scheduling appointments, social media management, and customer service. You can find virtual assistant jobs on job boards, freelance websites, and through direct pitching to potential clients.full time online jobs from home
we can start taking about normalizing data,. we can start talking about creating class objects to model real world situations. it is very important to understand how a normalized database enables one to model the real world. it is also very important to understand how to create a class object that allows one to model the real world. however, great products will allow you model things with little, or no knowledge on your part. in other words, you are either creating some type of object, or setting up some type of data relation...with little or no effort on your part.
you can use quicken, and not know a thing about double entry bookkeeping. taking a task and making it simple can make you a millionaire.
take the pick operating system. this system has been around for 30 years. it used to run as it's own native os, but now runs on either nt, or on linux. the main reason that this database system still survives today is that it enables people of limited skill to model real world situations. the key to this system is the way it models data. it does not use a flat, or sql model to store data, but uses what is called a post-relational, or so called multi-valued database. it also becomes an amazing tool in the hands of a knowledgeable developer.
lets save the mv stuff for another day (my comments on why mv systems are great can be read here)
so, just what is great about a sub form in access? well, first let me explain what a sub form is. in ms-access there is a concept of a sub form. all this means is that access provides a mechanism to place more than one form into a existing form. in other words i can create 3 forms. i then can create a 4th form, and drop those 3 forms into the 4th form. i can also now take these 4 form, and drop it into a 5 form. by cobbling forms together in this fashion, one can create a some very complex objects with little skill. vb forms are missing what is perhaps the most useful feature ever created in access.
sub forms accomplish some major, and common tasks for a developer.
- allows one to build lookups into other tables..with no code, or strange syntax. thus several tables of data can be inserted into a form *with* a corresponding set of text boxes (fields).
- allows you to build re-useable components for a application. these re-usable components are simply screens that are dropped into existing screens as a sub form. this is a far superior model to cut and paste of simple controls due to the fact that one change in the sub form will be reflected throughout the application. when users do this, they are creating re-useable objects...yet no programming is required to accomplish this high level of re-usability. you can accomplish the same thing in vb, but you have to create a activex component. this is not *too* hard in vb...but it is extra work, and requires much more careful design and planning.
manages the difficult task of a parent to child relationship. (it inserts the correct key value into the child records with no need for code on your part). thus, one can build any classic type of parent to child relation. order forms, invoices...etc can built with no code to maintain the relation. in addition, thus the correct retrieval and display of these child records is also done for you. this whole process can be done via drag and drop.
lets look at how we use a sub form to lookup data from another file. lets assume that we have a invoice system. we will also assume that the invoice has a field called customer id, and that id is the customer id.
when adding a new invoice, we want the customer information to show up in our invoice. a good design means that the customer name, address phone etc. is contained in the customer table. we need to show this information in our invoice. how? many people will suggest using a dlookups to do this. absolutely horrible those dlookups are. the syntax, and amount of typing for each dlookup is really very messy. it also requires that the user know how to build a where clause of sql. not only that, but each dlookup is actually a separate request to the file. hence, to display a few fields of information using dlookup is a horrible hit on performance.
the next option usually put forward is to write some code that loads up some controls on the screen. actually that is not too bad, and what is done in vb. i really do think that if you have to write code to show an address in the invoice...you are already using the wrong tool.
remote data entryChapter 8: Freelance DesignWhich business is best for housewife
part time studyCommunication skills: Data entry jobs may require communicating with other team members or clients, so good communication skills are essential.online jobs from home without investment
i don't have the space here, but i would love to spend some time explaining how other tools solve this problem.
not only does a sub form solve this problem nicely, the whole process is done via drag and drop. first we create a small tiny customer form.
online part time job without investmentSocial Media Managementpart time internet jobs from home
we now drop the above little customer form into our invoice form. we get the following:
we are done!. if you use a wizard to insert the form, then the lookup via the customer id is also done for you. in other words we just placed 5 fields from the customer file into our invoice form. this was easy, and the whole process was done with the mouse. anyone can do this. just how do you setup a lookup to another database to display a few fields?. if you are using a product that is as the drag and drop process as above....please e-mail me. it is amazing, but in general the average access developer does not even use the above approach.
online jobs for 10th pass students without investment part timeOffer referral programs to encourage current employees to refer friends and family to the job. Provide incentives such as bonuses or gift cards for successful referrals.part time evening remote jobs
hum......lets also assume that we have a purchase order. a purchase order is really just like a invoice. again, our tiny customer form can be dropped into the po. my point here is that we have a very simple form and it can be re-used throughout the application when ever we need to display the customer info. nice eh? just how do you develop and get that kind of re-usability?
part time jobs work from home for students without investmentThe best part of online part-time jobs is the ability to work on your own schedule. Whether you're a morning person or a night owl, you can choose when to work and for how long. This flexibility allows you to balance your job with your other responsibilities and hobbies.typing jobs from home without investment
* sub forms are not the only reason why access enables one to develop applcitions faster than most tools. however, it is one of the main reasons why.