SF330 ACCESS DATABASE

SIMPLE INSTRUCTIONS
FORMS IN WORD
ACCESS DATABASE FOR THE SF330

Wordsworth/Forms in Word has created a simple database in Microsoft Access to help companies track their projects, employees and subconsultants for the new SF330 form. This database is not locked or secure. This means that you can edit, add, or delete fields, as well as change the look of your reports. Information retrieved through queries and reports can be cut and paste directly into your SF330 Word document! The reports are very flexible and allow you to select information from any field or table.

Although our database is simple, it will do everything that you need it to do in order to compile your company information and fill out the new SF330. The best part is that it can be changed and tailored for your specific needs. We are going to give you a few simple instructions that should help you fully use the program in the next few pages. If you have any questions or would like some assistance, please e-mail (forms@formsinword.com) or call our office (907-745-5674).

ADDING INFORMATION TO YOUR DATABASE

HOW TO OPEN THE FORMS
#1 Double click and open the database
#2 There is no need to input data into tables in our simple Access database! Instead, there are three forms to input your information into: project, employee, and subconsultants. To open the projects form, for example, do the following: Find the objects tab and open the “projects form.” The screen view is fully adjustable for all three forms.

PROJECT INFORMATION
• Project #: Use your company project number here. It will help you find and locate projects.
• Project Title: This is where you name the project with a title for the SF330
• Profile Code: This is a drop-down list of profile codes supplied by the federal government.
• Contract Number: This is not a mandatory field but it has proved helpful in the writing of proposals for identifying projects.
• Contract Amount: Your portion of the entire contract amount.
• Entire Contract Amount: Fill this in if known.) Sometimes this is an unknown quantity.)
• Professional Services Completed: Completion date of your portion of project.
• Construction Completed: Completion date of entire project
• Project Owner: You will be able to choose a project owner from the drop-down list.
• Prime Contractor: You will be able to choose the Prime Contractor from the drop-down list.
• Duration: This is not a mandatory field although some agencies are requesting to know the length of time your company spent on the project. (for instance: This was a 2-year contract with 3 option years or this was a six month project)
• Fill in the checkbox that indicates whether you were the prime contractor, subconsultant, or this was a joint venture project.
• Short Description: Use this description to help with the resume portion of the SF330. Write a few short sentences only.
• Long Description: Enter the long description for your project here. There is no limit to the length.
• Employee: Choose an employee(s) and move them to the employee on project screen using the right arrow you will be asked to choose a role for that employee. You can choose and add multiple employees to the project. You can come back later and choose more.
• Subconsultant: Chose a subconsultant(s) for the project. Move them to the subconsultant on project screen using the right arrow. You will be asked to choose a role on project:

EMPLOYEE INFORMATION
• Name
• Address
• City
• State
• Zip
• Education:
• License and State: (For example: PLS#64567, Alaska)
• Discipline: Job title for projects
• Prior Years Experience
• Hire Date: 01/01/2004
• Years Experience:
• Years Experience Current Firm:
• Total Years Experience: The ACCESS database will calculate for you.
• Personal Experience: You can be creative here and add one job description or multiple descriptions for projects.
• Other Qualifications: Additional certifications, publications and papers, etc.

SUBCONSULTANT/CLIENT INFORMATION
• Name
• Contact
• Phone
• E-mail
• Address
• City
• State
• Role: This is a large field. You can write a long description of the services that were performed by the subconsultant if you want to add their capability to your proposals.

RETRIEVING INFORMATION FROM YOUR ACCESS DATABASE
Queries: On the left tab, select queries. Use the Design Wizard to choose the field(s) that you want to query. This is a helpful tool for finding projects. You can query all fields or choose one.

Reports: Use the Design Wizard to choose the fields you would like to include in your report. The report layout (or screen view) can be changed.

Queries and Reports can be easily deleted from the database; just recreate them each time you use the program. Or, leave them in for the next proposal.

CUT AND PASTE. Information retrieved through queries and reports can be cut and paste into your SF330 Word document!

IMPORTANT: Open your Microsoft Word document (SF330) in Rich Text Format prior to cutting and pasting information. This can be accomplished by opening your document; giving it a file name and saving as type: Rich Text Format.

The best thing about this program is that you are able to tailor it to meet your company’s needs. Fields can be lengthened or shortened. You can add and delete fields. The program automatically updates. Records can be easily edited, added, and OOPS deleted. You will be surprised with the program’s capabilities.

Detailed instructions, as well as helpful hints, on how to use the program are contained at the Microsoft Access home page and can be found at
http://office.microsoft.com/en-us/FX010857911033.aspx