Sapientech Products

XFileClean Delux Version 6.1.2.0 

In today's economy can you really afford to purchase a new computer? One of the leading causes of system crashes, speed and performance issues can be attributed to excessive temporary files and unwanted trash left onto the hard drive by windows and other applications. XFileClean allows you to correct slow system problems by removing temporary files, clear windows temp directory, check files and backup files as well as defrag safely and efficiently from your Microsoft Windows XP computer. Allow XFileClean to find and delete these unwanted files from your system freeing valuable space. Also, clear the recycle bin, clear the temp directory and history as well as defrag the hard drive. With this version of XFileClean you can:

• Clear backup files (.bak)
  
• Clear Temp files (.tmp)
  
• Clear check files (.chk)
  
• Clear the history
  
• Clear the recycle bin
  
• Clear the windows temp directory
  
• Defrag the hard disk
  

 
 

Improve the speed of your computer and save money. Download you copy today:

http://sapientech.com/NewHome/Downloads/XFileCleanDelux.msi

 
 

New from Sapientech, "Sapientech Small Business Office"

Sapientech Small Business Office combines the two most popular software packages offered by Sapientech into one package. CyQuest is an essential tool for managing clients, contact, documents, notes, images and resources from one central database as well as generate custom forms for storing information. The application allows the user to create databases and forms without any knowledge of programming or database management. It also allows the user to manage meeting and telephone notes as well as documentation in a single database complete with version control. Utilizing barcode technology, InTrek gives businesses a simple and inexpensive way to track the quantity, description, location and history of assets. In addition, InTrek allows you to manage location and contact information. With InTrek you can: Create Custom asset templates to speed up the entry of common asset information. For example create a custom template for your desktops, laptops, printers, etc..

Where can I get an evaluation copy of Sapientech Small Business Office?

http://sapientech.com/newhome/Downloads/SapientechSmallBusinessOfficeLiteIT.msi

http://sapientech.com/newhome/Downloads/SapientechSmallBusinessOfficeLiteGeneral.msi

http://sapientech.com/newhome/Downloads/SapientechSmallBusinessOfficePremiumIT.msi

http://sapientech.com/newhome/Downloads/SapientechSmallBusinessOfficePremiunGeneral.msi

http://sapientech.com/newhome/Downloads/SapientechSmallBusinessOfficeUltraIT.msi

http://sapientech.com/newhome/Downloads/SapientechSmallBusinessOfficeUltraGeneral.msi

What is InTrek?

Using barcode technology, InTrek gives businesses a simple and inexpensive way to manage and track the quantity, location and history of products/assets.

With InTrek Lite you can:

• Customize asset templates to define what asset information goes into the system
  
• Track an asset's current location
  
• Get a history of where a product has been assigned previously
  
• Search for asset information using a bar code scanner
  
• Use a bar code scanner to input asset information into the system
  
• View all asset associated with a particular location.
  
• Check for duplicates before information is entered into the system.
  
• Store, View and Edits notes associated with an asset
  
• Store, View and Delete documents associated with an asset
  
• Apply version control to the asset documentation
  
• Add up to an additional 20 customized data fields to further define assets and location
  

Where can I get an evaluation copy of InTrek?

http://sapientech.com/newhome/downloads/InTrek Lite.msi

http://sapientech.com/newhome/downloads/InTrek Lite.msi

http://sapientech.com/newhome/downloads/InTrek Lite.msi

http://sapientech.com/newhome/downloads/InTrek Lite.msi

http://sapientech.com/newhome/downloads/InTrek Lite.msi

http://sapientech.com/newhome/downloads/InTrek Lite.msi

What customers are saying about InTrek

As a small owner, I needed help managing my inventory but didn't' have a great deal to invest. The Nature of my business dictates a high volume of working inventory; computers, monitors, servers, kiosks, and POS's etc… spread out over large geographical regions in multiple locations. A great deal of my time is spent in the field, so for me, it was critical to find and application that didn't require a large learning curve or a great deal of time to operate. With the InTrek system, I was able satisfy all my initial requirements, and found that I was able to do a great deal more. One of my favorite characteristics of InTrek, is the ease with which I can define and enter the necessary information, to identify my equipment in the system. I am also impressed with the fact that I can store my data by locations and changes, when necessary, are easy to enter. I would defiantly recommend the InTrek system to anyone looking to manage growing inventory needs and demands.

JSJ

CEO

The Cambrian Group Inc

What is CyQuest?

Built on Microsoft office technology, CyQuest is the ultimate in contact management and tracking. Going far beyond the capability of Microsoft Outlook, CyQuest provides the user with a rich platform that can be customized to fit the user's needs without having to change the way in which they conduct business. The user friendly interface ensures that even the computer novice can easily navigate the application like a professional.

• Manage all contact information from one central location (database).
  
• Upload emails, documents, graphics, etc.
  
• Sort clients by either last name or company name.
  
• Define new forms and database fields using the form editor.
  
• No programming experience required.
  
• Automatic version control for attachments.
  
• Create, store and track notes and attachments related to a particular client.
  
• Locate clients by name, location, or even keywords in their associated documents, etc.
  
• Upload, assign and manage common resources.
  
  

Where can I get an evaluation copy of CyQuest?

http://Sapientech.com/NewHome/Downloads/CyQuest.msi

What customers are saying about CyQuest

"As a project manager, I'm always looking for ways to increase productivity while saving time. I've used several different types of project management software, and none has compared to CyQuest. It's easy to use and makes sense in a linearly thinking way. It basically has all the features I need to manage multiple projects simultaneously and none of the features that clutter my organization."

Brian Coovert

 

So Purchase your copy of Business Products today!

Database Maintenance

 

Is a process by which existing data infrastructure is periodically examined and critiqued to ensure that the data integrity is enforced and business processes followed. Database maintenance is also essential to ensure that data is optimized for OLTP or OLAP applications and that necessary backups and disaster recovery plans (DRPs) are being followed.

 

Database maintenance consists of:

• Creating backup scenarios and DRPs
  
• Optimizing data for indexing, search and retrieval based on the database type (OLAP vs. OLTP)
  
• Examining server logging facilities and media to ensure correct operation of the database
  

Verifying that data in the data store is compliant with data integrity rules, setup by the company at design time

Database Design and Development

 

Is a fundamental process of converting business practices and logic flow into a data infrastructure that will support and automate current business processes and enhance performance and prosperity of a company. Properly designed and implemented databases will not only allow businesses to utilize its current data more efficiently, but will also lay the foundations for advanced decision support and reporting systems, which could be built on top of existing databases.

 

Database Design and Development process consists of:

• Describing current business practices
  
• Laying out data flow which corresponds to these practices
  
• Implementing data structures to support logic flow in the company
  

Building and coding those data structures

Web Development

Successful Web development requires knowledge and skills in many areas, and constant attention to processes and key web elements.

Web Development consists of:

• Define target audience, purpose, objectives, and policies for information development and use.
  
• Check technical construction of web with validation tools; evaluate information consistency and verify correctness of domain information.
  
• Separate information into page-sized chunks; connect pages along routes of use and user thinking; provide information, context, and navigation cues; create a consistent look and feel.
  
• Create an extendible directory and file structure; use HTML tools where helpful; use templates for supporting consistent look and feel; check implementation in various browsers.
  
• Target publicity releases for general Web audiences, potential users, and current users; follow online community norms and practices; innovatively connect with users to meet their needs.
  
• Continuously and creatively work for improvement to meet user needs; use testing, evaluation, and focus groups to shift and change web's content as user needs change.
  

 

Web Design

A good web designer takes into account the web's purpose and audience. A good designer knows how to achieve the effects called for in the most flexible, efficient, and elegant way. A web designer should have a thorough grounding in implementation processes and possibilities as well as knowledge about how particular web structures affect an audience.

Web Design consists of:

• Create a consistent look and feel for the web.
  
• Separate information into manageable page-sized chunks
  
• Provide cues for the reader about the web's information structure and contents, context, and navigation.
  
• Use links to connect pages along the routes of use and user thinking.
  

Application Technology

Today, information is being consumed by companies at an alarming rate. Gone are the simple applications of yesterday in which the name and address was all that was needed to process business applications. Applications are becoming more and more suffocated in which different types of data are being merged into super data classes. Examples such as the combining audio and video data with textual data are becoming more prevalent. Also, applications are becoming less dependent upon the user interaction and intervention. Meaning that applications are becoming smarter.

 

Database Technology

In today's business environment companies rely on the constant flow of information from various sources. Therefore, getting the necessary information in a timely manner is not only desirable but critical to the life of any organization. When developing applications that access information, Database Design and Development are of the utmost importance

Technology Evaluation and Audits

A successful audit can help you determine whether you have the best practices in place to meet your business's continual needs for security, access and resiliency. The purpose of an audit is not to rehash past mistakes but to look at past events with a view toward improving future performance. Findings from an audit can be used as a basis for adjusting policies, priorities, structure or procedures in order to make operations as efficient, economical and effective as possible.

Information Technology Evaluation and Audit consists of:

• Information technology management
  
• Information technology policies and procedure
  
• Systems development
  
• Programming control
  
• Physical security
  
• Logical security
  
• Basic network control
  
• Input, processing, and output control
  
• Data backup procedure
  

Disaster recovery planning and testing

Application Design and Development

 

Is a fundamental process of converting business practices and logic infrastructure that will support the current business model as well as automate current business processes while enhancing the performance and prosperity of a company

Application Design and Development consists of:

• Creating a Summary and Overview of a company's goals.
  
• Requirements Gathering
  
• Preliminary Design
  
• Detailed Design Development
  
• Infrastructure Upgrades
  
• Testing and Acceptance
  
• Data Importing
  
• Implementation and Training
  
• Ongoing Support and Enhancement
  

 

Application Maintenance

Is a process by which existing applications are periodically examined and critiqued to ensure that the current business model is enforced and business processes followed. It is also critical that application performance be maintained and current technologies utilized to aid in a company's growth potential.

Application maintenance consists of:

• Reviewing current business requirements for a particular application
  
• Reviewing technologies used by current applications to determine their feasibility
  
• Review applications to determine if it is in compliancy with current industry standards •
  

 

 

Application Conversions

Is a process by which applications that have been developed using yesterday's technology are brought back to current industry standards using updated technologies and languages.

Application Conversions consists of:

• Updating the applications business requirements
  
• Updating the applications stakeholders requirements
  
• Determine which technologies should be deployed by the application
  
• Determine how the new technology are to be used by the application
  

 

Application Technology

Today, information is being consumed by companies at an alarming rate. Gone are the simple applications of yesterday in which the name and address was all that was needed to process business applications. Applications are becoming more and more suffocated in which different types of data are being merged into super data classes. Examples such as the combining audio and video data with textual data are becoming more prevalent. Also, applications are becoming less dependent upon the user interaction and intervention. Meaning that applications are becoming smarter.

 

Database Technology

In today's business environment companies rely on the constant flow of information from various sources. Therefore, getting the necessary information in a timely manner is not only desirable but critical to the life of any organization. When developing applications that access information, Database Design and Development are of the utmost importance

Getting Started

INSTALLING AND STARTING VISUAL BASIC FOR APPLICATIONS
As with most Windows-based programs, the installation and startup process for Vi- sual Basic is quite simple. In fact, if you are using VBA, the installation and startup process is accomplished almost automatically when you install and start AutoCAD.


Note: The following installation and startup process is for VBA. For stand-alone VB
installation procedures, see the boxed article on page 18.

INSTALLING VISUAL BASIC FOR APPLICATIONS
To install AutoCAD VBA, all you have to do is make sure you include the VBA module when you install AutoCAD. If you select the Full or Typical option as shown in Figure 2–1, VBA will be installed automatically. The Compact option will not install VBA. If you select the Custom option, you will need to make sure VBA is one of the options selected for installation.


INSTALLING AND STARTING STAND-ALONE VISUAL BASIC
The stand-alone editions of Visual Basic are installed like most other Windows programs on the market today. The software is usually provided on a CD-ROM, and it contains an automated Setup program.

1. With Windows running, insert the CD in the appropriate drive.

2. Click the Start button on the Taskbar. Windows will open the Start menu.

3. Click Run. Windows will open the Run dialog box.

4. Type or select the Setup program and click the OK button.

5. Follow the on-screen directions to complete the installation.

You can run Setup as many times as necessary, meaning you can later change installation options selected during your first installation. Once installation is complete, stand-alone Visual Basic is installed in its own program group.

The Setup program automatically adds Visual Basic to the Programs menu of the Windows Start button. To start Visual Basic, simply click the Start button, highlight Programs, and select the version of Visual Basic installed on your com-
puter. As with other Windows programs, you can also start Visual Basic in several
other ways, such as by using Windows Explorer to find the directory in which
Visual Basic was installed and double-clicking on the EXE file.


STARTING VISUAL BASIC FOR APPLICATIONS
To start AutoCAD VBA, click the Tools menu in AutoCAD and select Macro. You will see the pull-down menu, shown previously in Figure 1–2. From the pull-down menu, select Visual Basic Editor. Alternately, you can type “VBAIDE” in the com- mand line and press Enter. Both methods will open the Visual Basic Interactive Development Environment (IDE), as shown in Figure 2–2. The IDE can be thought
of as the main window where you develop VB programs. It is also sometimes referred
to as the Integrated Development Environment, although some programming pur- ists claim that VBA is not a truly integrated environment like stand-alone VB. Don’t get caught up in the semantics here. The VB Editor in AutoCAD can gener- ally be referred to as the IDE.



EXPLORING THE VISUAL BASIC ENVIRONMENT

ELEMENTS OF THE IDE
The IDE initially consists of five main components: the title bar, the menu bar, the toolbar, the Project Explorer, and the Properties window. Two additional components, the UserForm window and the Toolbox, are displayed when you insert a UserForm to develop a user interface for your program. When you are ready to type code, you display and work with the Code window. A brief description of each component follows.

The Title Bar
The title bar, located at the top of the screen, displays the words “Microsoft Visual Basic,” along with the name of the project you are working on. Initially, the name of the project will be displayed as “Global1.” When you have created and named a project, which we will do later in this chapter, the name of the project will be dis- played in the title bar.

The Menu Bar
The menu bar, located immediately beneath the title bar, provides pull-down menus with some of the key tools you will need to develop VB programs. Many of these menus, like File, Edit, and View, are similar to those of other Windows applications; others, like the Debug and Run menus, are unique to the VB environment. The stand-alone VB menu is similar to the VBA menu, with a couple of minor excep- tions not worth discussing right now. You will learn more about VB and VBA menu commands throughout this book.

The Toolbar
The toolbar, located immediately beneath the menu bar, provides shortcuts to fre- quently used menu commands. Each tool button is represented by a graphical sym- bol, or icon. For example, the button depicting a diskette provides a quick way to save
a file, an alternative to clicking on the File menu and selecting Save. When you
place the cursor over one of the buttons, a brief description, or tool tip, is displayed adjacent to the button. A summary of the toolbar buttons is shown in Figure 2–3.


The toolbar shown in Figure 2–3 is also referred to as the standard toolbar, since VBA also provides additional toolbars for other tasks like editing and debugging. These toolbars are turned off by default, but you can activate them by clicking on the View menu and selecting Toolbars.

The Project Explorer
The VB programs or applications you develop are referred to as projects. To help you manage projects, the Project Explorer displays a listing of the items associated with the project currently loaded. These items—objects, forms, and modules—constitute the building blocks of your program, and they will be discussed in more detail later. If you used previous versions of VB or VBA, the Project Explorer may have been referred to as the Project window. It can still be thought of as a window, and it generally appears in the upper left portion of the screen.

The Properties Window
The Properties window, located below the Project Explorer, lists the properties
for selected objects and their current settings. For the time being, consider
properties as object characteristics, like size, color, and location. When you
first open the IDE, the Properties window will be empty because you have not
yet created any objects. You are essentially starting with a blank page, but that
will change shortly!


The UserForm Window and the Toolbox
We now need to add one key piece to the screen before we can develop a VBA program. The UserForm is the display area, or form, where you develop the window that users will see when they run the program. It is contained in the UserForm window, which appears when you have inserted a form. Insert a form now by clicking on the Insert menu and selecting UserForm. A blank form will be dis- played along with the Toolbox, which is a palette of controls, or components like command buttons, text boxes, and checkboxes that you can place on your form. The Properties window will also display properties of the UserForm and any ob- jects added to it. The updated display showing the UserForm window and Toolbox appears in Figure 2–4.

Note: In stand-alone Visual Basic, the UserForm window is simply referred to as the
Form window, and it is displayed automatically at startup.



The Code Window
At this point you may be wondering where to see the program code—the statements that tell the program what to do. Code is contained in the Code window, which is initially hidden. To display the Code window at any time, click the View menu and select Code, or simply press F7 KEY. Another way to display the Code window is to double-click a control in a UserForm, as you will see in the exercise that follows.