Quote / estimate template

Hi, i was searching the internet for a template but it seems that i cannot fined one. I dont want to reinvent the wheel if i can get / buy a template which i can tailormade for my company. Im in the copier business and im busy building a quote/estimate template/database. I assistance will be appreciated. Thanks


Post your answer or comment

comments powered by Disqus
Hi everyone

I am an access trainer and have developed some basic databases in the past and now am concentrating on developing a database for the company I work for. I'm comfortable at this stage with designing the structure and as I have been with the company from start up (6 months ago) and have put a lot of the manual systems in place for our staff to take orders etc I have a real good handle on how the database should work.

How do I quote/estimate to my manager how long it will take to build a database? I know this is a "how long is a piece of string questions" but many years ago a guy once told me a formula for estimating development time. So much for tables, so much for queries etc etc.

As with most management they have no idea how long things take and since this project is extremely important and urgent I don't want to be pressured into saying that it will be ready at a certain time and there is no way to achieve it.

What are your suggestions?

Thanks in advance - Jenine.

Hello again AWF

I have a problem i hope someone can help with.

I have an access database that handles our customers, orders, quotes etc. and works quite well. It has become so relied upon in the office that others are now making suggestions they'd like to see on the development. Thats good for me.

The latest one relates to external word documents. At present when we need to do a new quote for a customer, the database is used to add the quote details (ie date, customer name, quote value etc etc). then a "create quote from blank template" button is clicked and word pops up, opens the "quote.dot" template, pastes the address, date, quote number & reference to it using bookmarks & then saved as a word document to the server (ie. 14940 - quote.doc).

This part is OK. The quote.dot template however has a 6.8cm header & 2cm footer area on page 1 and 2.9cm header & 2cm footer for all other pages. This is because the quotes themselves are printed onto pre-printed letterheads for posting.

The problem:

We now need to be able to email the quotes to some customers and at present have to print the quote out on the letterheaded paper then scan it to pdf, save it, then email it. This is ok but invariably the scan is not quite square & quality lacking.

I want to be able to print the (already saved) word document to pdf with a computer generated letterhead. How would i do this ?

I was thinking either to create a report that has the letterhead info & import/merge the text from the quote to it, then email it or using vba, create a button on the quote details form in the database "email attached quote" which opens the word document in read only, inserts the necessary header & footer, then attaches itself (as pdf) to outlook new message....

Not sure which would be best !!!

Any suggestions appreciated.

Hi all,

I am interested in creating a relational database in Access (2010). I have all the data tables, a flowchart for how they are related (w/key), etc. I would like to hire someone to build the system for me, along with an "interface" (so we can query the data and create reports).

***I hope I am not breaking any rules relating to asking to hire someone. If so, please let me know.

Is there a place where I can submit a project outline to obtain some quotes/estimates?

Thank you,

Brent

Upon converting the services template web db I was able to get everything imported to a client db all functions are working with the exception of when I attempt to create an invoice from a quote the form has a command button that call a invoice macro and all i am getting if Operation is not supported for the type of object I am sure someone have attempted to convert this web db to client db and have the answer

Hi I am wondering if anyone has a template for an estimating database or a database which has an ability to select an item on a form which looks up a table of operations and you can then select which ones you want?

I am trying to establish a database from which i can have a table which contains a list of manufacturing operations and std run times against each operation.

I would then like to be able to open a form for each project and lookup the operations table and attach the ones i want so that it generates a list against the project number.

I can then add an operation qty and it will then multiply this by std run time to give total run time.

any ideas would be appreciated.

Thanks

John

hello, i am after some help tweaking an access 2010 template (services) i am a novice at this but computer literate, would anyone beable to help?

as an electrician, i am looking to purchase a mini laptop and try to run from a database system rather than the piles of paper i currently carry around. This template is perfect for that, however i would like to add the following:

Additional tab on the quote form which displays just a text box, this will be used in the initial survey to take notes on what the job requires and update the notes as the job progresses.

Another tab which can be used for test results which relate to each circuit of the house, this could be linked to an excel spreadsheet as the test form is quite big (i have an example sheet in excel). I have been able to add a hyperlink to the form, however i want it to create a seperate file for each record. I hope this makes sense.

Any help greatly appreciated.

Hi all, newb here both to this forum and to Access front ends, though I've been a decade in SQL DB Admin so table design won't be a headache (much!).

Got a meeting tomorrow with a fellow who runs a small family-staffed wholesalers, pretty much a blank sheet site, processes about 2,000 orders a year with data strewn everywhere across umpteen Excel files and Sage. We met last week and wants me to have a database put together containing all product ranges, button-touch remote reporting on profits/sales etc, warehouse stock levels, billing, etc, none of which are currently automated/interconnected.

I'm thinking that it's not going to be much more complex than Northwind, but as this is my first foray into 1-1 consultancy and proj-managing the entire SDLC, I wanted to get some idea of what questions I'll need to ask, what kind of timelines I should quote for R+D.

Anyway, I think an Access db should suffice for the above purposes, again not dissimilar in structure to Northwind, but with more forms/reports for the accounts side.

My questions are;

1) Anyone have a general checklist/roadmap?

2) What kind of timelines I should be quoting? (assuming uninterrupted work, free access to all data etc, I estimate completion in a couple of months, more if he bothers me with extra work, in/out of project.)

3) What kind of questions should I be asking him at our meeting?

4) He feels he'd benefit from BI as do most businesses, but what kinds of benefits should be agreed here for a small firm like his?

5) He wants to replace Sage for his accts, so far he's just using it for billing/P+L reporting, but I imagine his reporting needs will grow. Anyone common 'Gotcha's when it comes to migrating from Sage to MSA ?

6) Could I use a stock template from within Access and build outwards from there?

Thanks in advance, everyone!!


Jaybee

Hello, please can someone help me with an issue I am having. I have been changing the northwind desktop service template to suit my needs, and must point out i am new to access and databases and am now stuck.

When creating a quote i have the option to add service tax and/or product tax. When i try entering any number below 0 i get an error such as
please specify services tax rate between 0 and 100%.

I have looked in tables and found in the before change ribbon option a few references to validating the tax such as; IF [ProductsTaxRate]1 Then Raise Error .......

But after I delete these references the problem still occurs

I also found some references to the tax in the macros section. I am unsure what i need to change to be able to do below 0 numbers.

I hope this all makes sense

Please can some one help?

Thank you

I searched the archive and didn't find quite what I was looking for, so..

I have an Excel 2003 spreadsheet work-in-progress being used as a template (developed by others) to prepare project cost estimates in a complex regulatory environment. We are 'modelling on the fly' for a number of projects until we are comfortable with the estimate model, after which time I intend to incorporate our 'stable' estimate methodology into Access. Meanwhile, I am 'stuck' with the Excel spreadsheet.

I have a project tracking database (Access 2003), and I want to be able to track my estimates. I do NOT want to embed my spreadsheets into the db, just a filelink. There can be more than 1 estimate per project.

Ideally, the user should be able to define a project in the Access db (or select one already defined) and click a 'make estimate' button, which would generate a new Excel file in a predefined directory (based on the present version of the .xlt file), give it an appropriate filename (based on the Access ProjectID and estimate sequence number for that project if there were others already), open up that workbook in Excel, and then autopopulate some cells based on information showing on the original form in Access!

A separate button for 'Open existing estimate' will eventually be required, but I think I could do that if I can get someone to walk me through the steps required above.

I am somewhat familiar with vba in Access, but am an absolute rookie when it comes to excel.

Edit: I left out that I would also add an appropriate record to a table like tblEstimate which would contain the link(s) to the estimate(s). This table will obviously contain a FK to tblProject

I am continuing to work on my quoting database. In case you not aware of my database, I am designing a very ambitious database for the start-up company I work for. We manufacture specialty chemicals for research and the database I am designing is supposed to track a customer’s quotes and orders.

I have had quite a bit of help in the forms here in the past and I figured I could get a few suggestions on my next step. I have the general form made for each quote/order however I can’t really decide how to design the way each quote treats the quote “status”. Such as marking it to be shipped, package, canceled, etc. Right now I have all the status as a combo box; however I would like a few things to happen for different status.

1) Although I will do this last I want to make it so you can’t go backwards in the chain of status. Example- A Order that has been marked “shipped” can’t go back to “processing” status.

2) Next I want Access to automatically e-mail different people at different status points. Once the quote has been accepted by the customer I want access to e-mail the laboratory and tell them the product and amount to package. Also I want access to e-mail the customer once the order has been shipped with the shipping details. I have a pretty good idea how to do this, but I am not sure if a combo box is the best way.

3) I also want a live feed like list with the current orders sorted by status and ordered by oldest first, this would appear on the switchboard or main page.

Like I said I have a combo box in place for status right now, however I have seen templates which use a button system which has a separate table for status and also uses yes/no boxes. Any suggestions on how to approach this plan?

I am helping to create an access database for my school's band/chorus library. Does anyone know of any specific templates that would suit this? The current databases are in excel and are attached. Thanks for all help. Attached Files HS Music Inventory 2011.zip (157.8 KB, 2 views) Most Updated Library.zip (56.0 KB, 1 views) Reply With Quote 04-17-2012, 06:25 AM #2 alansidman VIP Windows 7 32bit Access 2007 Join Date Apr 2010 Location Lake County, IL Posts 1,778 You can look here for ideas
http://www.databasedev.co.uk/data_models.html

http://office.microsoft.com/en-us/te...010117248.aspx

I now see I posted this in the general area instead of the programming area and am moving it to here. I am running Windows XP in and Office 2010 in 32 bit on my 2nd pc where this db is located.

I need some help, please. I am not a total novice, but have some experience, yet have never learned VBA. I am taking someone's template that I found on a forum (forgive me, but I forgot who made it), and trying to modify it to fit my need. I sometimes need to be told exactly what to do and where to do it, not just hints. Anyway, this is not yet working so if anyone can help me fix it I appreciate it very much. It was created in 2003 or before and I am trying to use it in 2010.

I am uploading the database. I think the switchboard_lev1 (thru 4) forms need the VBA modified, but I am not sure what and where. Then I plan to change their looks. Is there any code that is not compatible or is better changed to suit 2010 and future versions.

I understand what most of the code in frm_Main is doing and the module, but now I am stumped by the code in the switchboard forms.

This project is at least 6 months behind because I am learning how to modify this code, so any help is appreciated. I have at least 7 databases that need to be updated to 2010 and include this login to provide minimal security because of untrained users. Thanks! Attached Files login_demo 012413.zip (146.6 KB, 3 views) Reply With Quote 01-31-2013, 04:16 PM #2 June7 Super Moderator Windows XP Access 2010 32bit Join Date May 2011 Location The Great Land Posts 15,115 I guess switchboards have their benefits (maybe with web database) but I don't like them because they use macros and I don't use macros, only VBA. However, your switchboards don't seem to be fully macro driven. Not sure what you have here. The button clicks definitely aren't working.

What exactly is not working for you? What has you stumped?

Personally, I would not have a separate switchboard for each permission level. I would use code to control what buttons are available to users.

Why are user IDs and passwords displayed on form_main?

Login form is a common topic. Search forum or google. Start with http://www.accessforums.net/forms/mu...orm-24841.html

Hi there
Hoping you can help, as always

I've downloaded the new, "Resource Scheduling" template from the MS website.
I've adapted it to a somewhat different purpose, using it to schedule crew on concerts and shows. I've treated the people as resources, and the "Customer" field as the show name, so it's easy enough to schedule them in this way.

What I want clarification on, is being able to enter the data seperately. You'll see from the screengrab that it gets rather messy with 7 entries for each person (a week's worth) and then with seperate shows...)

I have created a report that sorts by "Customer", so the output is clear-ish.

Am I correct in saying that all I need to do is to enter another column in each table and link them up, for the actual event ID?

Hope this is clear enough (but probably not....) so please ask for clarification.
Thanks
David

http://www.filesonic.com/file/418155...2011-12-12.mdb Attached Thumbnails   Reply With Quote 12-18-2011, 01:30 AM #2 June7 Super Moderator Windows XP Access 2010 32bit Join Date May 2011 Location The Great Land Posts 15,111 I don't think this template quite fits your situation. Maybe one too many tables. Consider this structure:

tblStaff
StaffID (primary key)
StaffLastName
StaffFirstName

tblEvent
EventID (primary key)
EventName
EventStart (date/time)
EventEnd (date/time)
ContactName
ContactPhone

tblEventStaff
ID (primary key)
EventID (foreign key)
StaffID (foreign key)
ScheduleStart (date/time)
ScheduleEnd (date/time)
Confirmed

I am another brand new user to Access and I am hoping for some quite basic support.

I am using access 2007 and have downloaded the "Lending Library" from Microsoft.

1. When I check out items I get a Default "Due Date" populated. I would like to change the default "Due Date" from 7 days as it comes in the template to 25-30 days. How would I go about this change?

2. When I have checked out an item and the item has passed the "Due date" I would like to be able to extend the lending time easily for certain items. What do I do?

3. Some times mistakes are done and I would like to undo the operation. What do I do? There is the "Undo" Button in Access, as in other MS programs, however this does can not be clicked.

4. The database saves automatically. When I have completed my work and want to close the database there is no warning if I want to save the changes in the database. Related to question 3 this creates some issues when I have done mistakes and do not want to save the changes in the database.

5. When I try to import data from Excel I consistently get a failure message as the attachment. I have gone through the excel sheet up and down to verify the columns in the excel sheet match the Access database template. I understand this question is close to impossible to anwer without seeing my excel sheet but I am looking for some guidelines when importing excel data into access. Attached Thumbnails   Reply With Quote 11-11-2010, 01:35 AM #2 RuralGuy Administrator Windows 7 Access 2010 (version 14.0) Join Date Mar 2007 Location 8300' in the Colorado Rocky Mountains Posts 9,484 You should really limit each thread to a separate issue rather than a list of 5 separate issues. I would also post your zipped up db so we can look at what you might have done.

Hello,

I have already accomplished creating a word document by clicking on a button.
Here is the code:

Private Sub CreateWord_Click()
On Error GoTo cmdOK_Error
Dim stDocName As String
stDocName = "Client-Status-Linda"
DoCmd.OutputTo acOutputQuery, stDocName, acFormatRTF, "Word.rtf", True
cmdOK_Error:
Resume Next
End Sub

Also, I have attached the generated documented.

It generates a standard word document, however, I would like to be able to choose colors, font style, etc.


I know that you can use a template with the OutputTo method, however, I have not been successful in making it work.


expression.OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding)


Please let me know how to accomplish generating a word file and formatting it with a template. Any help would be appreciated.



Thanks


Linda Attached Files Word.zip (12.8 KB, 5 views) Reply With Quote 11-18-2012, 08:41 PM #2 Rod Expert Windows 7 32bit Access 2007 Join Date Jun 2011 Location Metro Manila, Philippines Posts 658 Sorry, I don't think the template helps you. Here's the official MS help; it seems restricted to three types only.

TemplateFile Optional Variant A string expression that's the full name, including the path, of the file you want to use as a template for an HTML , HTX , or ASP file.

Hello.

I hope someone can help or point me in the right direction. My knowledge of Access isn't great, but I'm keen to learn.

I have an Inventory Management template that a colleague started to set up for our business but never completed. The database will be used to log stock and create purchase orders.

The products table already has many items that my colleague inputted, but I have been trying to add more. I've got no problem adding products to the table or through the form, but the problem is that the Unit Price's are not being calculated for any other products I'm adding after the originals in the table.

This may have something to do with the template being made in 2003 and i'm using Access 2010 or that the productID is now being auto-generated as a very long number (see screenshot in attachment)

I've attached the database and a couple of screenshots, you will see that I have added product Test001 to the table and that on the purchase order the UnitPrice is not calculated, but does calculate for existing products.

Hope someone can please help?

Thank you Attached Files Inventory Management.zip (822.8 KB, 19 views) Reply With Quote 12-13-2011, 09:34 AM #2 Robeen VIP Windows XP Access 2010 32bit Join Date Mar 2011 Location Tulsa, Oklahoma. Posts 1,500 I looked at your DB.
In the Products Table - Test001 has a UnitPrice of 10.00 quid.

I'm not sure I understand your problem.
You say the Unit Price is not being 'calculated' . . .
I don't think the Unit Price NEEDS to be calculated.
You just input the Unit Price for each product - no?

Perhaps if you explain your problem a little differently - with a few step-by-step examples, I may be able to understand your problem and help.

Hello Access Forumers,

A friend who is starting a pipe fabrication company has asked to help him get started by creating an estimating tool for quoting on work (I have used access once, and therefore am the resident expert among my friends). The idea is that based on the material, pipe size, pipe thickness, type of work being performed, and quantity, a cost can be determined. I have reviewed the Northwinds example as well as other variants where the customer/product/order relationships have been quite well documented, and while some of this could be incorporated, I feel that the structure of this database is somewhat different. Searching the forums has not yielded any results for this case, but if this topic has been previously covered please let me know (and a point in the right direction would also be appreciated). I am hoping for a little advice from this user group with regards setting up the tables and the associated PK's, FK's etc before heading down the wrong path.

The issue that I am struggling to sort out is how to create "unique data", because the data is structured in more of a format where the intersection of the data yields the result. Some example data is provided below:

Pipe Diameter (in) Sch. 20 Sch. 40 Sch. 60 2" $10 $15 $20 3" $20 $30 $40 4" $30 $45 $60
In this table, the left column provides the pipe diameter, and the top row provides the wall thickness (or schedule). This could be sample pricing for a butt weld joint type for carbon steel. There would be similar pricing data for other material types (stainless steel etc.) and joint types. The question I have is how to link all this information together, and what is the best manner to do so. For example, if each record were to be unique and, in order to allow access to query by each field, would I need to create a table that looks as follows?


Pipe Diameter (in) Schedule Price ($) 2" 20 10 2" 40 15 2" 60 20 3" 20 20 3" 40 30 3" 60 40 4" 20 30 4" 40 45 4" 60 60
In this way, each record set is unique. However, because of common pipe diameters, would I also need to create some kind of product ID as the primary key? For example, there could be a naming convention of pipe diameter.schedule that would create a unique primary key for each record (for a 3" schedule 40 pipe this would be 3.40). If this is the case, this will require a significant amount of work based on the number of combinations available.

So, as you can see, I am a little unsure as to how to proceed and I cant help but feel there is a better/more efficient way to perform this task.

Hopefully this explanation is sufficient. Please let me know if it is not.

Thanks in advance!

Quote: Originally Posted by mcdhappy80 You mean composite PK consisting of two fields where one part of PK is, lets say, autonumber field, and other could be number which identifies from which user the data comes. Yes, that's correct.

Quote: For example:
0101 - first record from first workstation
0102 - first record from second workstation If you mean:


	Code:
	ID      Source
1         1
1         2

Then, yes. But I'd actually use it in the other order, with the machine column 1st and the ID column second.

But it really matters none at all, as this is just a way of a generating unique compound PK across multiple databases.

Quote: I thought about that non-replicating mechanism (with PKs) You suggested, but I wanted to automate synchronization process as much as possible to the end users, so I thought, if Access already has that mechanism (replication) implemented why not.
My idea was to create that "synchronization" between two database with one mouse click, if possible, through VBA code. It's doable with Jet replication, of course, but it requires indirect or Internet replication, unless you don't mind corrupting or losing all your data every now and again. And the programming requirements are at a substantially higher level of sophistication for Jet replication than it is for the method of shipping non-replicated MDBs back and forth.

So, after all the programming, while the end-user experience might be an easy one-click experience, you still have all the issues of setting up each workstation and installing all the needed components and keeping them all in working order, which is itself quite complicated. For a taste of what's involved with this, see the Jet Replication Wiki article on setting up indirect replication without Replication Manager:

http://dfenton.com/DFA/Replication/i...cation_Manager

Quote: Are there VBA code examples to create this data exporting/importing scenario? I'd think it would be very simple code. You'd keep a copy of your empty transport database as a template, make a copy of it, append the new records to its table(s), zip it up (or not -- it might not be large enough to matter), copy it across the WAN to the other machine and be done with it.

In the other directioy, you'd also periodically check to see if thje local computer has received a transport database from the other machine, and if it's there, import its records into your local database.

That sounds to me like quite a few programming steps, but each of them is very simple. Sure, you could complicate things by given each transport database a different name, and archiving the files after you've imported them, but the basics are pretty straightforward, seems to me.

The only problem I can think of that could be a problem would be making sure the VPN was up and running before trying to copy the file across to the other side, but that's an issue with indirect replication over the Internet, as well, so it's not really something specific to the approach I'm suggesting.

I have a home water treatment filters company .

Home filters have like 7 different stages which must be replaced from 3-10 months depends on each stage life time ..lets say you install the frist stage in 1/1/2012 its time to replace it in 1/4/2012..We have like 2000 customers ..Is there is a Access Template that i can store my customers data base in and when i search for a certain date i know who have to replace his stages at that date ...Can access help with what am asking anyways
thanks in advance

Jon,

It would be nice, in my opinion, to have a custom profile field dealing with which version of Access a person has. In the Admin panel you go to:
User Custom Fields Select Multiple-Selection Checkbox
You can define the options here then head into the templates, find the Postbit Templates option, then the Postbit template.

Here, find:


	Code:
	$vbphrase[join_date]: $post[joindate]

Then, paste after:


	Code:
	Using Access: $post[field5]

Where field5 is the custom field number. Actually, it could be inserted after the post count with a
to separate it, too. Might be better.

This will have the benefit of listing next to a person's posts and join date what version(s) of Access they are using. It helps to solve problems since not everyone is explicit enough when describing their problem.

Inspired by Friday's new sig...

How about a thread where we share some of our favorite poems or excerpts from poems? Maybe even offer a tidbit about why we like it or what it means to us? Might be fun...

In college I had a large, black binder that I used to keep all my important class materials in. Whenever I found a piece of a poem or a quote I liked, I'd print it out in an interesting font and tape it to the binder. By the time I graduated it was pretty well covered. One of the centerpieces was from Edna St. Vincent Millay:

"Safe upon the solid rock the ugly houses stand
Come see my shining palace built upon the sand"

Anyone care to share their favorites?

http://www.npr.org/templates/story/s...oryId=98593139

This is an interesting read mainly because of all the anti-gun lobbying done on this website. Most of you on here portray the US gun owner as a blood thirsty inbred because we like our right to own guns. You think most of us go out of our way to shoot somebody. Well I would rather live here than in Guatemala.

They not only use guns but knifes too.
Quote: "We have a saying: If you don't pay, we won't hurt the father, sadly, it's the children who'll pay," Flaco says. "We send them a letter. Then we surveil their kids. We ask for $5,000 to $13,000, depending on the kind of business he's in. If he doesn't pay, we kidnap his wife or a child, and we kill them. Then we send him body parts showing him we mean business, and we keep kidnapping family members until he pays."
Moral of the story? Guns don't kill people. Knifes don't kill people - people kill people.

Hi everyone,
This post will probally turn into a rant about my workplace more than anything else.

I'm having lots of problems trying to estimate how long it will take to do parts of my project. The project has to do with payroll - there are about 450 employees all over the world - some being paid weekly, some biweekly, some monthly and in about 4 different currencies. Many change job alot - as they are on short term contracts. I've been creating a DB to track who is working where, on which project and their rates for their current assignment. The idea is to show the gross pay for each one by project. Oh and I was also supervising 3 temps putting in all the data - peoples contact details, pay rates, current jobs from various sources of data that were full of mistakes. I've just checked and I've been working on it since the 20 Aug. I don't think thats unreasonable for a database that lets them take care of all their operations?

Its very nearly there now but I've been having such problems estimating how long parts of it will change. The person I report (I'll call him Mike) to has very little involvement and has only really seen it twice. I'm not supposed to be dealing with the manager whose team will be the end users. That person is enthusiastic about it and interested in it. Only prob was he was on holidays for 3 weeks in the middle of it. So then I was dealing with Mike. Every time we have a meeting I feel that he is putting pressure on me to have it done soon and end up estimating things will take less time than they will. I'm bad at estimating the time it will take anyways. Also with IT projects I just think that its very difficult to estimate as unforseen problems come up or is that just because I son't have enough experience?

I have been working exclusively with Access for nearly a year now. Two of the projects I've developed are being used daily - one is the main system used by document control and they are quite dependant on it. The others is used by the Materials section to track goods delivered to them. Unfortunately there is no-one in the company with more experience than I have with Access so there is no-one I can ask for help when I need to. Thank God for this forum or I would have been completely lost.

On Monday for instance they want me to research the vacation side of it and have a list of all the questions to do with it complete by that evening! the employees are not regular employees at all - some work on rotations, some are contractors, most are on short term jobs..And my boss also wants me to have looked into the billing side for each person - their rates are billled to different customers. And I have to have a list of questions done. I'm supposed to do all this on Mon!

Maybe I need a new job where I have a boss that knows more about Access than I do and they can estimate how long it would take.. Think my chances of getting a pay rise are slim to none anyways, given that they think its taking too long to do everything.

So how do other people estimate how long projects will take??

.
.
.
.
Quote: THIS HAS GOT TO BE PASSED ALONG TO AS MANY AS POSSIBLE OR WE WILL ALL GO DOWN THE DRAIN BECAUSE A FEW DON'T CARE.

This English teacher has phrased it the best I've seen yet

Tomatoes and Cheap Labor

CHEAP TOMATOES?
This should make everyone think, be you Democrat, Republican or Independent

From a California school teacher - - -


"As you listen to the news about the student protests over illegal immigration, there are some things that you should be aware of:

I am in charge of the English-as-a-second-language department at a large southern California high school which is designated a Title 1 school, meaning that its students average lower socioeconomic
and income levels.

Most of the schools you are hearing about, South Gate High, Bell Gardens , Huntington Park , etc., where these students are protesting, are also Title 1 schools.

Title 1 schools are on the free breakfast and free lunch program... When I say free breakfast, I'm not talking a glass of milk and roll -- but a full breakfast and cereal bar with fruits and juices that would make a Marriott proud. The waste of this food is monumental, with trays and trays of it being dumped in the t rash uneaten. ( OUR TAX DOLLARS AT WORK )

I estimate that well over 50% of these students are obese or at least moderately overweight. About 75% or more DO have cell phones. The school also provides day care centers for the unwed teenage pregnant girls (some as young as 13) so they can attend class without the inconvenience of having to arrange for babysitters or having family watch their kids. (OUR TAX DOLLARS AT WORK)

I was ordered to spend $700,000 on my department or risk losing
funding for the upcoming year even though there was little need for anything; my budget was already substantial. I ended up buying new computers for the computer learning center, half of which, one month later, have been carved with graffiti by the appreciative students who obviously feel humbled and grateful to have a free education in America . (OUR TAX DOLLARS AT WORK)

I have had to intervene several times for young and substitute teachers whose classes consist of many illegal immigrant students here in the country less then 3 months who raised so much hell with the female teachers, calling them "Putas" whores and throwing things that the teachers were in tears.

Free medical, free education, free food, day care
etc., etc, etc. Is it any wonder they feel entitled to not only be in this country but to demand rights, privileges and entitlements ?

To those who want to point out how much these illegal immigrants contribute to our society because they LIKE their gardener and housekeeper and they like to pay less for tomatoes: spend some time in the real world of illegal immigration and see the TRUE costs.

Higher insurance, medical facilities closing, higher medical costs, more crime, lower standards of education in our schools, overcrowding, new diseases etc., etc, etc. For me, I'll pay more for tomatoes.

We need to wake up. The guest worker program will be a disaster because we won't have the guts to enforce it . Does anyone in their right mind really think they will voluntarily leave and return?


It does, however, have everything to do with culture: A third-world culture that does not value education, that accepts children getting pregnant and dropping out of school by 15 and that refuses
to assimilate , and an American culture that has become so weak and worried about " politically correctness" that we don't have the will to do anything about it.

If this makes your blood boil, as it did mine, forward this to everyone you know.

CHEAP LABOR? Isn't that what the whole immigration issue is about?

Business doesn't want to pay a decent wage.

Consumers don't want expensive produce.

Government will tell you Americans don't want the jobs.

But the bottom line is cheap labor. The phrase "cheap labor" is a myth , a farce, and a lie. There is no such thing as "cheap labor."

Take, for example, an illegal alien with a wife and five children. He takes a job for
$5.00 or 6.00/hour. At that wage, with six dependents, he pays no income tax, yet at the end of the year, if he files an Income Tax Return, he gets an "earned income credit" of up to $3,200 free.

He qualifies for S ection 8 housing and subsidized rent.

He qualifies for food stamps.

He qualifies for free (no deductible, no co-pay) health care.

His children get free breakfasts and lunches
at school.
He requires bilingual teachers and books.

He qualifies for relief from high ener gy bills.

If they are or become, aged, blind or disabled, they qualify for SSI. Once qualified for SSI they can qualify for Medicare. All of this is at (our) taxpayer's expense .

He doesn't worry about car insurance, life insurance, or homeowners insurance.

Taxpayers provide Spanish language signs, bulletins and printed material.

He and his family receive the equivalent of $20.00 to $30.00/hour in benefits.

Working Americans
are lucky to have $5.00 or $6.00/hour left after paying their bills and his.

The American taxpayers also pay for increased crime, graffiti and trash clean-up.

Cheap labor? YEAH RIGHT! Wake up people!

THESE ARE THE QUESTIONS WE SHOULD BE ADDRESSING TO THE PRESIDENTIAL CANDIDATES FOR EITHER PARTY. 'AND WHEN THEY LIE TO US AND DON'T DO AS THEY SAY, WE SHOULD REPLACE THEM AT ONCE!'

THIS HAS GOT TO BE PASSED ALONG TO AS MANY AS POSSIBLE OR WE WILL ALL GO DOWN THE DRAIN BECAUSE A FEW DON'T CARE


Not finding an answer? Try a Google search.