Office Word Microsoft

SB1 accelerates in getting is ERP and MRP market share.  If you are in small business manufacturing, light assembly, picking and packing, transportation and logistics, shipping and receiving, collection management, inventory control, consignment, warehouse management business. International midsize business, you should include SAP B1 into your accounting application research list.  Plus SAP BO is open through SAP Business One SDK and Data Transformation Workbench to simple and complex integration and data conversion projects, including CSV Excel templates and ODBC data source (such as Microsoft SQL Server Views).  If you are facing technical challenge of SB1 implementation, modification, data massage, EDI, and if your current SAP Business One Reseller, consultant or Technology partner doesn’t fit to your increasing programming requirements, you should launch your search to locate new VAR.  In this small publication we would like to introduce Alba Spectrum and help you with SAP Business One Partner selection:

1.       ERP and MRP common features for small businesses.  It is not a big secret, that around the beginning of XXI-st century Microsoft, Oracle, SAP and other MRP vendors launched the program of converging ERP functionality into building blocks, that should be easily integrated (assuming that you are sticking to the same vendor) for all you subsidiaries, branches and legal companies

2.       Service Industry and SB1.  Here we have excellent fit, typically not available through other small and midsize ERP software vendors – SAP B1 covers service warranty contracts with serial number linking functionality, scheduling, alerts, timecards (for your technicians to go onsite and have expenses in the form of parts, travel, lodging).  If you are growing small service oriented business, and if you are having fields technicians – SAP B1 if must to consider in the ERP system switch from legacy to the future one

3.       Intuition – either Microsoft Office Outlook or SAP Business One intuitive interface.  If you compare SB1 with Microsoft Dynamics family of ERP applications: Dynamics GP, AX, SL, NAV, CRM, you will quickly realize that Microsoft is moving its ERP apps toward the integration with Microsoft Office, Excel, Powerpoint, Word, Sharepoint (Business Portal for Axapta, Great Plains).  SAP Business One has good potential in this direction as it has robust cooperation with Microsoft in MS Office integration (email, faxing, exporting to Word, Excel. etc).  In our opinion Microsoft future ERP intuition as well as SAP Business One intuitive interface are coming in synch and to the same MRP future development direction

There is no denying the fact that the server is a multi-user computer where there is no unusual hardware prerequisite that turns a computer into a server and as such the hardware platform needs to be preferred based on application demands and financial stringency. Servers for client/server applications work unsurpassed when they are configured with an operating system that supports shared memory, application isolation, and preemptive multitasking. An operating system with preemptive multitasking enables a higher priority task to preempt or take control of the processor from a currently executing, lower priority task. The server provides and controls shared access to server resources. Applications on a server must be isolated from each other so that an error in one cannot damage another. Preemptive multitasking ensures that no single task can take over all the resources of the server and thwart other tasks from providing service. There must be a means of defining the relative priority of the tasks on the server. These requirements are specific to the client/server accomplishment and not to the file server implementation. Because file servers execute only the single task of file service, they can operate in a more limited operating background without the need for application isolation and anticipatory multitasking.

The conventional minicomputer and mainframe hosts have acted as de facto enterprise servers for the network of terminals they support. Because the only functionality available to the terminal user is through the host, personal productivity data as well as business systems information is stored on this host server. Network services, application services, and database services are provided centrally from the host server. Many organizations download data from legacy enterprise servers for local manipulation at workstations. In the client/server model, the definition of server will continue to include these functions, perhaps still implemented on the same or similar platforms. Moreover, the advent of open systems based servers is facilitating the placement of services on many different platforms. Client/server computing is a phenomenon that developed from the ground up. Remote workgroups have needed to share expensive resources and have connected their desktop workstations into local area networks LANs have grown until they are pervasive in the organization. However, frequently, they are isolated one from the other. Many organizations have integrated the functionality of their dumb terminals into their desktop workstations to support character mode, host-based applications from the single workstation. The next wave of client/server computing is occurring now, as organizations of the mid-1990s begin to use the cheaper and more available processing power of the workstation as part of their enterprise systems. The Novell Network Operating System (NOS), NetWare, is the most widely installed LAN. It provides the premier file and print server supports. However, a limitation of NetWare for the needs of reliable client/server applications has been the requirement for an additional separate processor running as a database server. The availability of database server software—from companies such as Sybase and Oracle—to run on the NetWare server, is plateful to disseminate this limitation.

Apropos to the functions, Servers provide application, file, database, print, fax, image, communications, security, systems, and network management services. These are each described in some detail in the following sections. It is important to understand that a server is an architectural concept, not a physical implementation explanation. Client and server functions can be provided by the same physical device. With the movement toward peer computing, every device will potentially operate as a client and server in response to requests for service. Application servers provide business functionality to support the operation of the client workstation. In the client/server model these services can be provided for an entire or partial business function invoked through an Inter Process Communication (IPC) request for service. Either message-based requests RPCs can be used. A collection of application servers may work in concert to provide an entire business function. For example, in a payroll system the employee information may be managed by one application server, earnings calculated by another application server, and deductions calculated by a third application server. These servers may run different operating systems on various hardware platforms and may use different database servers. The client application invokes these services without consideration of the technology or geographic location of the various servers. Object technology provides the technical basis for the application server, and widespread acceptance of the CORBA standards is ensuring the viability of this trend. File servers provide record level data services to no database applications. Required memory space for storage is allocated, and free space is managed by the file server.

Catalog functions are provided by the file server to support file naming and directory structure. Filename maximum length ranges from 8 to 256 characters, depending on the particular server operating system support. Stored programs are typically loaded from a file server for execution on a client or host server platform. Database servers are managed by a database engine such as Sybase, IBM, Ingress, Informix, or Oracle. The file server provides the initial space, and the database engine allocates space for tables within the space provided by the file server. These host services are responsible for providing the specialized data services required of a database product—automatic blackout and recovery after power, hardware, or software failure, space management within the file, database reorganization, record locking, deadlock detection, and management. Print servers provide support to receive client documents, queue them for printing, prioritize them, and execute the specific print driver logic required for the selected printer. The print server software must have the necessary logic to support the unique characteristics of each printer. Effective print server support will include error recovery for jams and operator notification of errors with instructions for restart. Fax servers provide support similar to that provided by print servers. In addition, fax servers queue up outgoing faxes for later distribution when communications charges are lower. Because fax documents are distributed in compressed form using either Group III or Group IV compression, the fax server must be capable of dynamically compressing and decompressing documents for distribution, printing, and display. This operation is usually done through the addition of a fax card to the server. If faxing is rare, the software support for the compression and decompression options can be used. Image servers operate in a manner similar to fax servers.

Infrastructure servers provide support for wide area network (WAN) communications. This support typically includes support for a subset of IBM System Network Architecture (SNA), asynchronous protocols, X.25, ISDN, TCP/IP, OSI, and LAN-to-LAN NetBIOS communication protocols. In the Novell NetWare implementation, Gateway Communications provides a leading communications product. In the LAN Server and LAN Manager environments, OS/2 communications server products are available from IBM and DCA. In the Banyan VINES environment, the addition of DCA products to VINES provides support for SNA connectivity. UNIX servers provide a range of product add-ons from various vendors to support the entire range of communications requirements. VMS servers support Decent, TCP/IP, and SNA as well as various asynchronous and serial communications protocols. MVS servers provide support for SNA, TCP/IP, and some support for other asynchronous communications. Security at the server restricts access to software and data accessed from the server. Communications access is controlled from the communications server. In most implementations, the use of a user login ID is the primary means of security. Using LAN Server, some organizations have implemented integrated Response Access/Control Facility (RACF) security by creating profiles in the MVS environment and downloading those to the LAN server for domain control. Systems and network management services for the local LAN are managed by a LAN administrator, but WAN services must be provided from some central location. Typically, remote LAN management is done from the central data center site by trained MIS personnel. The discussion in the following sections more specifically describes the functions provided by the server in a NOS environment. Requests are issued by a client to the NOS services software resident on the client machine. These services format the request into an appropriate RPC and issue the request to the application layer of the client protocol stack. This request is received by the application layer of the protocol stack on the server. File services handle access to the virtual directories and files located on the client workstation and to the server\’s permanent storage. These services are provided through the redirection software implemented as part of the client workstation operating environment.

To diminish the effort and effect of installation and maintenance of software, software should be loaded from the server for execution on the client. New versions can be updated on the server and made immediately available to all users. In addition, installation in a central location reduces the effort required for each workstation user to knob the installation process. Because each client workstation user uses the same installation of the software, optional parameters are consistent, and remote help desk operators are aware of them. This simplifies the analysis that must occur to provide support. Sharing information, such as word processing documents, is easier when everyone is at the same release level and uses the same default setup within the software. Central productivity services such as style sheets and macros can be set up for general use. Most personal productivity products do permit local parameters such as colors, default printers, and so forth to be set locally as well. Backups of the server can be scheduled and monitored by a trained support person. Backups of client workstations can be scheduled from the server, and data can be stored at the server to facilitate recovery. Tape or optical backup units are typically used for backup; these devices can readily provide support for many users. Placing the server and its backups in a secure location helps prevent theft or accidental destruction of backups. A central location is readily monitored by a support person who ensures that the backup functions are completed. With more organizations looking at multimedia and image technology, large optical storage devices are most appropriately implemented as shared servers. High-quality printers, workstation-generated faxes, and plotters are natural candidates for support from a shared server. The server can accept input from many clients, queue it according to the priority of the request and handle it when the device is available. Many organizations realize substantial savings by enabling users to generate fax output from their workstations and queue it at a fax server for transmission when the communication costs are lower. Incoming faxes can be queued at the server and transmitted to the appropriate client either on receipt or on request. In concert with workflow management techniques, images can be captured and distributed to the appropriate client workstation from the image server. In the client/server model, work queues are maintained at the server by a supervisor in concert with default algorithms that determine how to distribute the queued work. Incoming paper mail can be converted to image form in the mail room and sent to the appropriate client through the LAN rather than through interoffice mail. Centralized capture and distribution enable images to be centrally indexed. This index can be maintained by the database services for all authorized users to query. In this way, images are captured once and are available for distribution immediately to all authorized users. Well-defined standards for electronic document management will allow this technology to become fully integrated into the desktop work environment. There are dramatic opportunities for cost savings and improvements in efficiency if this technology is properly implemented and used. Article 10 discusses in more detail the issues of electronic document management.

In the early hours database servers were actually file servers with a different interface. Products such as dBase, Clipper, FoxPro, and Paradox execute the database engine primarily on the client machine and use the file services provided by the file server for record access and free space management. These are new and more powerful implementations of the original flat-file models with extracted indexes for direct record access. Currency control is managed by the application program, which issues lock requests and lock checks, and by the database server, which creates a lock table that is interrogated whenever a record access lock check is generated. Because access is at the record level, all records satisfying the primary key must be returned to the client workstation for filtering. There are no facilities to execute procedural code at the server, to execute joins, or to filter rows prior to returning them to the workstation. This lack of capability dramatically increases the likelihood of records being locked when several clients are accessing the same database and increases network traffic when many unnecessary rows are returned to the workstation only to be rejected. The lack of server execution logic prevents these products from providing automatic partial update blackout and recovery after an application, system, or hardware failure. For this reason, systems that operate in this environment require an experienced system support programmer to assist in the recovery after a failure. When the applications are very straightforward and require only a single row to be updated in each interaction, this recovery issue does not arise. However, many client/server applications are required to update more than a single row as part of one logical unit of work. Client/server database engines such as Sybase, IBM\’s Database Manager, Ingress, Oracle, and Informix provide support at the server to execute SERVER APPLICATION requests issued from the client workstation. The file services are still used for space allocation and basic directory services, but all other services are provided directly by the database server. Relational database management systems are the current technology for data management. The major disadvantage with the hierarchical technique is that only applications that access data according to its physical storage sequence benefit from locality of reference. Changes to application requirements that necessitate a different access approach require the data to be reorganized. This process, which involves reading, sorting, and rewriting the database into a new sequence, is not transparent to applications that rely on the original physical sequence. Indexes that provide direct access into the database provide the capability to view and access the information in a sequence other than the physical sequence. However, these indexes must be known to the user at the time the application is developed. The developer explicitly references the index to get to the data of interest. Thus, indexes cannot be added later without changing all programs that need this access to use the index directly. Indexes cannot be removed without changing programs that currently access the index. Most implementations force the application developer to be sensitive to the ordering and occurrence of columns within the record. Thus, columns cannot be added or removed without changing all programs that are sensitive to these records. Application sensitivity to physical implementation is the main problem with hierarchical database systems. Application sensitivity to physical storage introduced considerable complexity into the navigation as application programmers traverse the hierarchy in search of their desired data. Attempts by database vendors to improve performance have usually increased the complexity of access. If life is too easy today, try to create a bidirectional virtually paired IMS logical relationship; that is why organizations using products such as IMS and IDMS usually have highly paid database technical support staff. As hardware technology evolves, it is important for the data management capabilities to evolve to use the new capabilities. Relational database technology provides the current data management solution to many of the problems inherent in the flat-file and hierarchical technologies. In the late 1970s and early 1980s, products such as Software AG\’s ADABAS and System 2000 were introduced in an attempt to provide the application flexibility demanded by the systems of the day. IBM with IMS and Cull net with IDMS attempted to add features to their products to increase this flexibility. The first relational products were introduced by ADR with Dotcom DB and Computer Corporation of America with Model 204. Each of these implementations used extracted indexes to provide direct access to stored data without navigating the database or sorting flat files. All the products attempted to maintain some of the performance advantages afforded by locality of reference (storage of related columns and records as close as possible to the primary column and record).

The development of a relational algebra defining the operations that can be performed between tables has enabled efficient implementations of RDBMS. The establishment of industry standards for the definition of and access to relational tables has speeded the acceptance of RDBMS as the de facto standard for all client/server applications today. Similar standards do not yet exist for OODBMSs. There is a place for both models. To be widely used, OODBMSs need to integrate transparently with RDBMS technology. Table 4.1 compares the terminology used by RDBMS and OODBMS proponents. Relational databases are characterized by a simple data structure. All access to data and relationships between tables are based on values. A data value occurrence is uniquely determined by the concatenation of the table name, column name, and the value of the unique identifier of the row (the primary key). Relationships between tables are determined by a common occurrence of the primary key values. Applications build a view of information from tables by doing a join based on the common values. The result of the join is another table that contains a combination of column values from the tables involved in the stick together. There remain some applications for which RDBMS have not achieved acceptable performance. Primarily, these are applications that require very complex data structures. Thousands of tables may be defined with many relationships among them. Frequently, the rows are sparsely populated, and the applications typically require many rows to be linked, often recursively, to produce the necessary view. The major vendors in this market are Objectivity Inc., Object Design, onto, and Versant. Other vendors such as HP, Borland, and Ingress have incorporated object features into their products. The application characteristics that lead to an OODBMS choice are shown in Figure 4.3. OODBMS will become production capable for these types of applications with the introduction of 16Mbps D-RAM and the creation of persistent (permanent) databases in D-RAM. Only the logging functions will use real I/O. Periodically, D-RAM databases will be backed up to real magnetic or optical disk storage. During 1993, a significant number of production OODBMS applications were implemented. With the confidence and experience gained from these applications, the momentum is building, and 1994 and 1995 will see a significant increase in the use of OODBMSs for business critical applications. OODBMSs have reached a maturity level coincident with the demand for multimedia enabled applications. The complexities of dealing with multimedia demands the features of OODBMS for effective storage and manipulation.

Client/server applications require LAN and WAN communication services. Basic LAN services are integral to the NOS. WAN services are provided by various communications server products. Article 5 provides a complete discussion of connectivity issues in the client/server model. Client/server applications require similar security services to those provided by host environments. Every user should be required to log in with a user ID and password. If passwords might become visible to unauthorized users, the security server should insist that passwords be changed regularly. The enterprise on the desk implies that a single logon ID and logon sequence is used to gain the authority once to access all information and process for the user has a need and right of access. Because data may be stored in a less physically secure area, the option should exist to store data in an encrypted form. A combination of the user ID and password should be required to decrypt the data. New options, such as floppy less workstation with integrated data encryption standard (DES) coprocessors, are available from vendors such as Beaver Computer Company. These products automatically encrypt or decrypt data written or read to disk or a communication line. The encryption and decryption are done using the DES algorithm and the user password. This ensures that no unauthorized user can access stored data or communications data. This type of security is particularly useful for laptop computers participating in client/server applications, because laptops do not operate in surroundings with the same physical security of an office. To be able to access the system from a laptop without properly utilizing an ID number and password would be courting disaster. NetWare is a family of LAN products with support for IBM PC-compatible and Apple Macintosh clients and IBM PC-compatible servers. NetWare is a proprietary NOS in the strict sense that it does not require another OS, such as DOS, Windows, Windows NT, OS/2, Mac System 7, or UNIX to run on a server. A separate Novell product—Portable NetWare for UNIX—provides server support for leading RISC-based UNIX implementations, IBM PC-compatible systems running Windows NT, OS/2, high-end Apple Macs running Mac System 7, and Digital Equipment Corporation VAXs running VMS. NetWare provides the premier LAN environment for file and printer resource sharing. It had 62 percent of the market share in 1993. It is widely installed as the standard product in many organizations.

Suffice it to say that LAN Manager and its IBM derivative, LAN Server, are the standard products for use in client/server implementations using OS/2 as the server operating system. LAN Manager/X is the standard product for client/server implementations using UNIX System V as the server operating system. Microsoft released its Advanced Server product with Windows NT in the third quarter of 1993. During 1994, it will be enhanced with support for the Microsoft network management services, currently referred to as \”Hermes,\” and Banyan\’s Enterprise Network Services (ENS). Advanced Server is the natural migration path for existing Microsoft LAN Manager and IBM LAN Server customers. Existing LAN Manager/X customers probably won\’t find Advanced Server an answer to their dreams before 1995. AT&T has taken over responsibility for the LAN Manager/X version. Vendors such as Hewlett-Packard (HP) have reticence the product from AT&T. AT&T and Microsoft has an agreement to maintain compatible APIs for all base functionality. LAN Manager and Advanced Server provide client support for DOS, Windows, Windows NT, OS/2, and Mac System 7. Server support extends to NetWare, AppleTalk, UNIX, Windows NT, and OS/2. Client workstations can access data from both NetWare and LAN Manager Servers at the same time. LAN Manager supports NetBIOS and Named Pipes LAN communications between clients and OS/2 servers. Redirection services are provided to map files and printers from remote workstations for client use. Advanced Server also supports TCP/IP communication. In early 1994, Advanced Server still will be a young product with many missing pieces. Even more troublesome, competitiveness between Microsoft and Novell is delaying the release of client requestor software and NetWare Core Protocol (NCP) support. Microsoft has added TCP/IP support to LAN Manager 2.1 and Advanced Server along with Net View and Simple Network Management Protocol (SNMP) agents. Thus, the tools are in place to provide remote LAN management for LAN Manager LANs. Microsoft has announced support for IBM Net View 6000 for Advanced Server management.

Advanced Server provides integrated support for peer-to-peer processing and client/server applications. Existing support for Windows NT, OS/2, UNIX, and Mac System 7 clients lets application, database, and communication servers run on the same machine as the file and print server. This feature is attractive in small LANs. The native operating system support for preemptive multitasking and storage protection ensures that these server applications do not reduce the reliability of other services. Even as Windows NT is rolled out to provide the database, application, and communications services to client/server applications, the use of Novell as the LAN NOS of choice will continue for peripheral resource sharing applications. Microsoft has attempted to preempt the small LAN market with its Windows for Workgroups product. This attacks the same market as NetWare Lite with a low-cost product that is tightly integrated with Windows. It is an attractive option for small organizations without a requirement for larger LANs. The complexities of systems management make it less attractive in an enterprise environment already using Novell. WWW can be used in conjunction with Novell for a workgroup wishing to use some WFW services, such as group scheduling. IBM has entered into an agreement to resell and integrate the Novell NetWare product into environments where both IBM LAN Server and Novell NetWare are required. NetWare provides more functional, easier-to-use, and higher-performance file and print services. In environments where these are the only LAN functions, NetWare is preferable to LAN Manager Derivatives. The capability to interconnect to the SNA world makes the IBM product LAN Server attractive to organizations that prefer to run both products. Most large organizations have department workgroups that require only the services that Novell provides well but may use LAN Server for client/server applications using SNA services such as APPN. IBM and Microsoft had an agreement to make the APIs for the two products equivalent. However, the dispute between the two companies over Windows 3.x and OS/2 has ended this cooperation. The most recent releases of LAN Manager NT 3 and LAN Server 3 are closer to the agreed equivalency, but there is no guarantee that this will continue. In fact, there is every indication that the products will diverge with the differing server operating system focuses for the two companies. IBM has priced LAN Server very attractively so that if OS/2 clients are being used, LAN Server is a low-cost option for small LANs. LAN Server supports DOS, Windows, and OS/2 clients. No support has been announced for Mac System 7, although it is possible to interconnect AppleTalk and LAN Server LANs to share data files and communication services.

Street Talk enables resources to be uniquely identified on the network, making them easier to access and manage. All resources, including file services, users, and printers, are defined as objects. Each object has a Street Talk name associated with it. Street Talk names follow a three-level hierarchical format: Item@Group@Organization. For example, a user can be identified as Psmith@Cerritos@Tnet. All network objects are stored in a distributed database that can be accessed globally. Novell\’s NDS is similar to Street Talk in functionality. However, there are key differences. NDS can partition and replicate the database, which will generally improve performance and reliability. NDS is X.500-compliant and enables multiple levels of hierarchy. Street Talk supports a fixed three-level hierarchy. The NDS architecture offers more flexibility but with corresponding complexity and Street Talk is less flexible but fewer complexes to manage. One advantage the current version of Street Talk has over NDS is that Street Talk objects can have unlimited attributes available for selection. Novell and Microsoft have announced support for Banyan ENS within their products to be available in Q2 1994. Banyan and DCA provide SNA services to the VINES environment. VINES support UNIX, DOS, Windows, OS/2, and Mac System 7 clients. NFS is the standard file system support for UNIX. PC NFS is available from Sun Select and FTP to provide file services support from a UNIX server to Windows, OS/2, Mac, and UNIX clients. Client/server computing requires that LAN and WAN topologies be in place to provide the necessary internetworking for shared applications and data. Gartner Group1 surveyed and estimated the Microsystems\’ integration topologies for the period 1986-1996; the results appear in Figure 4.6. Of special interest is the projection that most workstations will be within LANs by 1996, but only 14 percent will be involved in an enterprise LAN by that date. These figures represent a fairly pessimistic outlook for interconnected LAN-to-LAN and enterprise-wide connectivity. These figures probably will prove to be substantially understated if organizations adopt an architectural perspective for the selection of their platforms and tools and use these tools within an organizationally optimized systems development environment (SDE). Routers and communication servers will be used to provide communication services between LANs and into the WAN. In the client/server model, these connections will be provided transparently by the SDE tools. There are significant performance implications if the traffic volumes are large. IBM\’s LU6.2 implementation in APPC and TCP/IP provides the best support for high-volume, LAN-to-LAN/WAN communications. DEC\’s implementation of DECnet always has provided excellent LAN-to-WAN connectivity. Integrated support for TCP/IP, LU6.2, and IPX provides a solid platform for client/server LAN-to-WAN implementation within DECnet.

The lack of real estate on the desktop encouraged most organizations to move to a single device—using terminal emulation from the workstation—to access existing mainframe applications. It will take considerable time and effort before all existing host-based applications in an organization are replaced by client/server applications. In the long term, the host will continue to be the location of choice for enterprise database storage and for the provision of security and network management services. Mainframes are expensive to buy and maintain, hard to use, inflexible, and large, but they provide the stability and capacity required by many organizations to run their businesses. As Figure 4.7 notes, in the view of International Data Corporation, they will not go away soon. Their roles will change, but they will be around as part of the enterprise infrastructure for many more years. Only organizations who create an enterprise architecture strategy and transformational plans will accomplish the migration to client/server in less than a few years. Without a well-architected strategy, gradual evolution will produce failure. Information that is of value or interest to the entire business must be managed by a central data administration function and appear to be stored on each user\’s desk. These applications are traditionally implemented as Online Transaction Processing (OLTP) to the mainframe or minicomputer. With the client/server model, it is feasible to use database technology to replicate or migrate data to distributed servers. Wherever data resides or is used, the location must be transparent to the user and the developer. Data should be stored where it best meets the business need. Online Transaction Processing applications are found in such industries as insurance, finance, government, and sales—all of which process large numbers of transactions. Each of these transactions requires a minimal amount of user think time to process. In these industries, data is frequently collected at the source by the knowledgeable worker. As such, the systems have high requirements for availability, data integrity, performance, concurrent access, growth potential, security, and manageability. Systems implemented in these environments must prove their worth or they will be rejected by an empowered organization. They must be implemented as an integral part of the job process. OLTP has traditionally been the domain of the large mainframe vendors—such as IBM and DEC—and of special-purpose, fault-tolerant processors from vendors such as Tandem and Stratus. The client/server model has the capability to provide all the services required for OLTP at much lower cost than the traditional platforms. All the standard client/server requirements for a GUI—application portability, client/server function partitioning, software distribution, and effective development tools—exist for OLTP applications. The first vendor to deliver a production-quality product in this arena is Cooperative Solutions with its Ellipse product. Prior to Ellipse, OLTP systems required developers to manage the integrity issues of unit-of-work processing, including currency control and transaction rollback. Ellipse provides all the necessary components to build systems with these features. Ellipse currently operates with Windows 3.x, OS/2 clients, and OS/2 servers using the Sybase database engine. Novell is working with Cooperative Solutions to port Ellipse as a Novell NetWare Loadable Module (NLM). It provides a powerful GUI development environment using a template language as shorthand for development. This language provides a solid basis for building an organizational SDE and lends itself well to the incorporation of standard components. As UNIX has matured, it has added many of the features found in other commercial operating systems such as VMS and MVS. There are now several offerings for OLTP with UNIX. IBM is promoting CICS 6000 as a downsizing strategy for CICS MVS. Database services will be provided by a combination of AIX and MVS servers.

With the release of Windows NT (New Technology) in September of 1993, Microsoft staked its unique position with a server operating system. Microsoft\’s previous development of OS/2 with IBM did not create the single standard UNIX alternative that was hoped for. NT provides the preemptive multitasking services required for a functional server. It provides excellent support for Windows clients and incorporates the necessary storage protection services required for a reliable server operating system. Its implementation of C2 level security goes well beyond that provided by OS/2 and most UNIX implementations. It will take most of 1994 to get the applications and rugged zing necessary to provide an industrial strength platform for business critical applications. With Microsoft\’s prestige and marketing muscle, NT will be installed by many organizations as their server of choice. IBM provides MVS as a platform for large applications. Many of the existing application services that organizations have purchased operate on System 370-compatible hardware running MVS. The standard networking environment for many large organizations—SNA—is a component of MVS. IBM prefers to label proprietary systems today under the umbrella of SAA. The objective of SAA is to provide all services on all IBM platforms in a compatible way—the IBM version of the single-system image. There is a commitment by IBM to provide support for the LAN Server running natively under MVS. This is an attractive option for organizations with large existing investments in MVS applications. The very large data storage capabilities provided by System 370-compatible platforms with MVS make the use of MVS for LAN services attractive to large organizations. MVS provides a powerful database server using DB2 and LU6.2. With broad industry support for LU6.2, requests that include DB2 databases as part of their view can be issued from a client/server application. Products such as Sybase provide high-performance static SERVER APPLICATION support, making this implementation viable for high-performance production applications. Digital Equipment Corporation provides OPENVMS as its server platform of choice. VMS has a long history in the distributed computing arena and includes many of the features necessary to act as a server in the client/server model. DEC was slow to realize the importance of this technology, and only recently did the company enter the arena as a serious vendor. NetWare supports the use of OPENVMS servers for file services. DEC provides its own server interface using a LAN Manager derivative product called Patchworks. Patchworks run native on the VAX and RISC Alpha RXP. This is a particularly attractive configuration because it provides access on the same processor to the application, database, and file services provided by a combination of OPENVMS, NetWare, and LAN Manager. Digital and Microsoft have announced joint agreements to work together to provide a smooth integration of Windows, Windows NT, Patchworks, and OPENVMS. This will greatly facilitate the migration by OPENVMS customers to the client/server model. VAX OPENVMS support for database products such as RDB, Sybase, Ingress, and Oracle enables this platform to execute effectively as a database server for client/server applications. Many organizations have large investments in VAX hardware and DECnet networking. The option to use these as part of client/server applications is attractive as a way to maximize the value of this investment. DECnet provides ideal support for the single-system image model. LAN technology is fundamental to the architecture of DECnet. Many large organizations moving into the client/server world of computing have standardized on DECnet for WAN processing. For example, Kodak selected Digital as its networking company even after selecting IBM as its mainframe outsourcing company.

UNIX is a primary player as a server system in the client/server model. Certainly, the history of UNIX in the distributed computing arena and its open interfaces provide an excellent opportunity for it to be a server of choice. To understand what makes it an open operating system, look at the system\’s components. UNIX was conceived in the early 1970s by AT&T employees as an operating environment to provide services to software developers who were discouraged by the incompatibility of new computers and the lack of development tools for application development. The original intention of the UNIX architecture was to define a standard set of services to be provided by the UNIX kernel. These services are used by a shell that provides the command-line interface. Functionality is enhanced through the provision of a library of programs. Applications are built up from the program library and custom code. The power and appeal of UNIX lie in the common definition of the kernel and shell and in the large amount of software that has been built and is available. Applications built around these standards can be ported to many different hardware platforms. The objectives of the original UNIX were very comprehensive and might have been achieved except that the original operating system was developed under the auspices of AT&T. Legal ramifications of the consent decree governing the breakup of the Regional Bell Operating Companies (RBOCs) prevented AT&T from getting into the computer business. As a result, the company had little motivation early on to promote UNIX as a product. To overcome this, and in an attempt to achieve an implementation of UNIX better suited to the needs of developers, the University of California at Berkeley and other institutions developed better varieties of UNIX. As a result, the original objective of a portable platform was compromised. The new products were surely better, but they were not compatible with each other or the original implementation. Through the mid-1980s, many versions of UNIX that had increasing functionality were released. IBM, of course, entered the fray in 1986 with its own UNIX derivative, AIX. Finally, in 1989, an agreement was reached on the basic UNIX kernel, shell functions, and APIs. The computing community is close to consensus on what the UNIX kernel and shell will look like and on the definition of the specific APIs. Figure 4.8 shows the components of the future standard UNIX operating system architecture.

During all of these gyrations, one major UNIX problem has persisted that differentiates it from DOS, Windows NT, and OS/2 in the client/server world. Because the hardware platforms on which UNIX resides come from many manufacturers and are based on many different chip sets, the \”off-the-shelf\” software that is sold for PCs is not yet available for UNIX. Software is sold and distributed in its executable form, so it must be compiled and linked by the developer for the target platform. This means that organizations wishing to buy UNIX software must buy it for the specific target platform they are using. This also means that when they use many platforms in a distributed client/server application, companies must buy different software versions for each platform.

UNIX is particularly desirable as a server platform for client/server computing because of the large range of platform sizes available and the huge base of application and development software available. Universities are contributing to the UNIX momentum by graduating students who see only UNIX during their student years. Government agencies are insisting on UNIX as the platform for all government projects. The combination of these pressures and technology changes should ensure that UNIX compatibility will be mandatory for server platforms in the last half of this decade. OSF initially developed Motif, a graphical user interface for UNIX, that has become the de facto UNIX GUI standard. The Distributed Computing Environment (DCE) is gaining acceptance as the standard for distributed application development although its Distributed Management Environment has yet to achieve such widespread support. OSF/1, the OSF defined UNIX kernel, has been adopted only by DEC, although most other vendors have made promises to support it. OSF/1 brings the promise of a UNIX micro kernel more suitable to the desktop environment than existing products. The desire for a standard UNIX encourages other organizations. For example, the IEEE tackled the unified UNIX issue by establishing a group to develop a standard portable operating system called POSIX. The objective is to develop an ANSI standard operating system. POSIX isn\’t UNIX, but it is UNIX-like. POSIX standards (to which most vendors pledge compliance) exist today. DEC\’s OPENVMS operating system, for example, supports published POSIX standards. POSIX at this point, however, does little to promote interoperability and portability because so little of the total standard has been finalized. Simple applications that will run across different POSIX-compliant platforms will be written. However, they will be limited applications because developers will be unable to use any of the rich, non-POSIX features and functions that the vendors offer beyond the basic POSIX-compliant core. X/Open started in Europe and has spread to include most major U.S. computer makers. X/Open is having significant impact in the market because its goal is to establish a standard set of Application Programming Interfaces (APIs) that will enable interoperability. These interfaces are published in the X/Open Portability Guide. Applications running on operating systems that comply with these interfaces will communicate with each other and interoperate, even if the underlying operating systems are different. This is the key objective of the client/server model. The COSE announcement by HP, IBM, SCO, Sun, and Univel (Novell/USL) in March 1993 at the Uniforms Conference is the latest attempt to create a common ground between UNIX operating systems. The initial COSE announcement addresses only the user\’s desktop environment and graphical user interface; although in time it is expected to go further. COSE is a more pragmatic group attempting to actually \”get it done.\” Another major difference from previous attempts to create universal UNIX standards is the involvement of SCO and Sun. These two organizations own a substantial share of the UNIX market and have tended to promote proprietary approaches to the desktop interface. SCO provides its Open Desktop environment, and Sun offers Open Look. The commitment to Motif is a significant concession on their part and offers the first real opportunity for complete vendor interoperability and user transparency to platform.

In October of 1993, Novell decided to bestow the rights to the UNIX name to X/Open so that all vendors can develop to the UNIX standards and use the UNIX name for their products. This largely symbolic gesture will eliminate some of the confusion in the marketplace over what software is really UNIX. COSE is looking beyond the desktop to graphics, multimedia, object technology, and systems management. Networking support includes Novell\’s NetWare UNIX client networking products, OSF\’s DCE, and SunSoft\’s Open Network Computing. Novell has agreed to submit the NetWare UNIX client to X/Open for publication as a standard. In the area of graphics, COSE participants plan to support a core set of graphics facilities from the X Consortium, the developer of X Windows. Addressing multimedia, the COSE participants plan to submit two joint specifications in response to the Interactive Multimedia Association\’s request for technology. One of those specifications, called Distributed Media Services (DMS), defines a network-independent infrastructure supporting an integrated API and data stream protocol. The other—the Desktop Integrated Media Environment—will define multimedia access and collaboration tools, including at least one basic tool for each data type supported by the DMS infrastructure. The resulting standard will provide users with consistent access to multimedia tools in MultiFinder environments. COSE also addresses object technology, an area targeted by IBM and Sun. The group will support the efforts of the Object Management Group (OMG) and its Common Object Request Broker (CORBA) standard for deploying and using distributed objects. IBM already has a CORBA-compliant object system in beta test for AIX. Sun built an operating system code named spring as a proof of concept in 1992. Sun has a major project underway, called Distributed Objects Everywhere (DOE), that is producing very exciting productivity results. Finally, COSE will focus on the management of distributed file systems, distribution, groups and users, print spooling, software installation licensing, and storage. It is not a coincidence that these vendors are coming together to define a standard UNIX at this time. The COSE effort is a defensive reaction to the release of Microsoft\’s Windows NT. With this commitment to a 32-bit desktop and server operating system, Microsoft has taken the wind out of many of the UNIX claims to technical superiority. Despite its numerous advantages as a desktop and server operating system, UNIX never has been widely accepted in the general corporate world that favors DOS/Windows and Novell\’s NetWare. A key drawback to UNIX in the corporate arena has been the lack of a single UNIX standard. UNIX has a well established position as the operating system of choice for distributed relational databases from vendors like Informix, Ingress, Oracle, and Sybase. Most of these vendors, however, will port their products to Windows NT as well. Any effort to reduce the problems associated with the multiple UNIX variants will do much to bolster the stature of UNIX as a worthwhile alternative to Windows NT.

Spin this fantasy around in your mind. All the major hardware and software vendors get together and agree to install a black box in their systems that will, in effect, wipe away their technological barriers. This black box will connect a variety of small operating systems, dissimilar hardware platforms, incompatible communications protocols, all sorts of applications and database systems, and even unlike security systems. And the black box will do all this transparently, not only for end users but also for systems managers and applications developers.2 OSF proposes the distributed computing environment (DCE) as this black box. DCE is the most important architecture defined for the client/server model. It provides the bridge between existing investments in applications and new applications based on current technology. Figure 4.10 shows this architecture defined by the OSF. The first product components of DCE were released in the third quarter of 1991. DCE competes directly with Sun\’s open network computing (ONC) environment and indirectly with many other network standards. OSF/1 and DCE are almost certain to win this battle because of the massive market presence of the OSF sponsors. IBM has now committed to making its AIX product OSF/1 compatible by early 1994. It will be 1995 before the product is mature and complete enough to be widely used as part of business applications. In the interim, product vendors and systems integrators will use it to build portable products and applications. The general availability of code developed for previous, similar product components will speed the process and enable new development to be modeled on the previous releases. DCE has been described as another layer grouping in the OSI model.3 DCE provides the link between pure communications on the lower layers and end-user applications.

These components become active whenever a local application requests data, services, or processes from somewhere. The OSF says that DCE will make a network of systems from multiple vendors appear as a single stand-alone computer to applications developers, systems administrators, and end users. Thus, the single-system image is attained. Remote Procedure Call (RPC) and Presentation Services: Interface Definition Languages (IDLs) and RPCs enable programmers to transfer control and data across a network in a transparent manner that helps to mask the network\’s complexity. DCE uses the RPC originally developed by the HP Apollo Network Computing System (NCS), with some enhancements by DEC and IBM. NCS also provides the Network Data Representation (NDR), a virtual data representation. NDR enables data to be exchanged between various vendor products transparently. Conversions (as necessary) will take place with no intervention by the caller. Naming, security, file system, and data type conversions may take place as data is transported between various platforms. Naming: User-oriented names, specifying computers, files, and people should be easily accessible in a distributed environment. These directory services must offer standard appearance and rules for all clients. DCE supports the X.500 directory services standard, adding extensions from DEC\’s Domain Name Service (DECdns). The standardized X.500 code is Siemens Nixdorf\’s DIR-X X.500 service. Security: Distributed applications and services must identify users, control access to resources, and guard the integrity of all applications. DCE uses the Kerberos authentication service, developed by MIT as part of its Athena networking project and enhanced by Hewlett-Packard. This service is one of the major challenges to making products available quickly, because very few products today are developed with an awareness of this specification. Threads: This terminology represents a method of supporting parallel execution by managing multiple threads of control within a process operating in a distributed environment. Threads enable systems to start up multiple processes and forget about them until they are completed. This is especially important for network servers that may have to handle many requests from many clients at the same time. They must be able to do this without waiting for the previous request to complete. DCE is using DEC\’s Concert Multithread Architecture (CMA) implementation. Time Service: A time service synchronizes all system clocks of a distributed environment so that executing applications can depend on equivalent clocking among processes. Consider that many machines operating in many time zones may provide processes as part of a single application solution.

It is essential that they agree on the time in order to manage scheduled events and time-sequenced events. DCE is using a modification of DEC\’s Distributed Time Synchronization Service. Distributed File Services: By extending the local file system throughout the network, users gain full access to files on remote configurations. DCE uses Sun\’s Network File System (NFS) Version 2 and provides next-generation capabilities with the Andrew File System (AFS), developed at Carnegie-Mellon University and commercialized by Transact Corp. Diskless operations under AFS are supported by development work done by Hewlett-Packard. PC Integration: Integration enables PCs using MS-DOS, Windows NT, and OS/2 to access file and print services outside the MS-DOS environment. DCE uses Microsoft\’s LAN Manager/X. Management: Although partly addressed by the previous components, management is so complex in a distributed, heterogeneous configuration that OSF has defined a new architecture: distributed management environment (DME). DME provides a common framework for the management of stand-alone and distributed systems. This framework provides consistent tools and techniques for managing different types of systems and enables vendors to build system management applications that work on a variety of platforms. OSF will base DME on technology from Hewlett-Packard\’s Open View product.

SAA is IBM\’s distributed environment. SAA was defined by IBM in 1986 as an architecture to integrate all IBM computers and operating systems, including MVS, VM/CMS, OS/400, and OS/2-EE. SAA defines standards for a common user access (CUA) method, common programming interfaces (CPI), and a common communication link (APPC). To support the development of SAA-compliant applications, IBM described SAA frameworks (that somewhat resemble APIs). The first SAA framework is AD/Cycle, the SAA strategy for CASE application development. AD/Cycle is designed to use third-party tools within the IBM SAA hardware and mainframe Repository Manager/MVS data storage facility. Several vendors have been selected by IBM as AD/Cycle partners, namely: Intervolve, Knowledge Ware, Bachman, Synod, Systematic a, and Easel Corp. Several products are already available, including the Easel Workbench toolkit, Bachman DB2, CSP tools, and the Knowledge Ware Repository and MVS tools. Unfortunately, the most important component, the Repository Manager, has not yet reached production quality in its MVS implementation and as yet there are no plans for a client/server implementation. Many original IBM customers involved in evaluating the Repository Manager have returned the product in frustration. Recently, there has been much discussion about the need for a production-quality, object-oriented database management system to support the entity relationship (ER) model underlying the repository. Only this, say some sources, will make implementation and performance practical. A further failing in the SAA strategy is the lack of open systems support. Although certain standards, such as Motif, SERVER APPLICATION, and LU6.2, are identified as part of SAA; the lack of support for AIX has prevented many organizations from adopting SAA. IBM has published all the SAA standards and has licensed various protocols, such as LU6.2. The company has attempted to open up the SAA software development world. IBM\’s director of open systems strategy, George Siegel, says that IBM believes in openness through interfaces. Thus, the complete definition of APIs enables other vendors to develop products that interface with IBM products and with each other. Recent announcements, such as support for CICS AIX, point to a gradual movement to include AIX in the SAA platforms. The first SAA application that IBM released, Office Vision, was a disaster. The product consistently missed shipping dates and lacked much of the promised functionality. IBM has largely abandoned the product now and is working closely with Lotus and its workgroup computing initiatives. IBM has consistently defined common database, user interface, and communications standards across all platforms. This certainly provides the opportunity to build SAA-compliant client/server applications.

IBM has clarified System View as its DME product. System View defines APIs to enable interoperability between various vendor products. It is expected to be the vehicle for linking AIX into centralized mainframe sites. IBM has stated that System View is an open structure for integrating OSI, SNA, and TCP/IP networks. At this time, System View is a set of guidelines to help third-party software developers and customers integrate systems and storage management applications, data definitions, and access methods. The guidelines are intended to further support single-system image concepts.

In view of the above, it is a significant fact that The recent introduction of CICS for OS/2, AIX, and OS/400 and the announcement of support for AIX mean that a single transaction-processing platform is defined across the entire range of products. Applications developed under OS/2 can be ported to interoperate between OS/2, OS/400, MVS, and eventually AIX, without modification. COBOL and C are common programming languages for each platform. SERVER APPLICATION is the common data access language in all platforms. The failure of SAA is attributable to the complexity of IBM\’s heterogeneous product lines and the desire of many organizations to move away from proprietary to open systems solutions. This acknowledgment piloted IBM to announce its new Open Enterprise plan to replace the old System Application Architecture (SAA) plan with an open network strategy. System View is a key IBM network product linking OS/2, UNIX, and AS/400 operating systems. Traditional Systems Network Architecture (SNA) networking will be replaced by new technologies, such as Advanced Peer-to-Peer Communications (APPC) and Advanced Peer-to-Peer Networking.

Written by: Kh. Atiar Rahman

Counter Part Officer

Financial Management Reform Programme

They Work on Today\’s Computers Too!

If you\’re familiar with MS-DOS at all, you\’ll recall that it\’s a command-driven operating system that performs functions issued at the C:> prompt. The only way to get an MS-DOS computer to do something was to type a command at this prompt and if you can imagine, it was a rather cumbersome way to use a computer.

As an example, to load up Microsoft\’s simple editing program, you had to type the name of the drive that the program was on, the directory that the program was in, and then the name of the program. So if Microsoft Edit was in a directory or folder named \”Process,\” you could start the program by typing, \”C:>process\\edit.com\” Then, and only then would the program load up for use.

This is a small command, but just imagine if you had a program that was deeply nested within a series of folder. You could end up typing a command as wide as your computer screen or worse, long enough that the entire command would have to wrap onto the next line! Now imagine having to type these long commands every time that you wanted to start a program. Yikes!

That\’s one of the reasons why batch files became so popular. Batch files are small text-based documents that contain a bunch of these commands on their own lines. When executed, they would process each command without the user having to type each and every one of them.

When Windows was developed, the need for typing commands was essentially eradicated thanks to the introduction of the point-and-click (mouse) interface. But this didn\’t stop the batch file fever that started under MS-DOS – and in some small circles, batch files are still as popular as they were in the beginning.

Even though you may use Windows XP or Vista, batch files can save you tons of time by automatically starting multiple programs and performing different tasks at the single click of a button. They don\’t require any extensive programming background and they don\’t need to be encrypted with some weird, expensive compiler. Batch files are plain text files, and you can build one for your own personal use with Windows\’ Notepad.

You could make a batch file that loads up your favorite websites at once for example, or you could make a batch file that fills your desktop with the most important applications for the day. To do so only requires a little knowledge about the locations of these applications.

Let\’s say that every day we need to load up the Yahoo web browser, Microsoft Word, and then the calculator that comes with Windows. Instead of doing this by hand, we could write a batch file to do it for us.

First, we\’d load up Notepad and type in the following:

START \”http://www.yahoo.com\”
START \”c:/program files/microsoft office/office/winword.exe\”
START \”c:/windows/calc.exe\”

We would then save this data into a file named, \”mytasks.bat\” onto the Desktop for easy access. Each time we double-clicked on this file, the Yahoo website would load up, Microsoft Word would start, and the simple calculator would pop up.

Since we want these programs to load every day, we could create a shortcut to this file and then place the shortcut inside our computer\’s Start Up folder. That way, these three programs would load every time we turn on the computer. If you wanted these programs to start minimized, you could type the following into a batch file instead:

START http://www.yahoo.com /m
START \”c:/program files/microsoft office/office/winword.exe\” /m
START \”c:/windows/calc.exe\” /m

This will run all three programs as before, however the \”/m\” parameter will minimize them so that they don\’t clutter up the desktop.

Other people have found much more creative and effective ways to use batch files, but the important thing is that you know they\’re a resource you can use to save a few seconds or minutes in performing important tasks. We\’ve come a long way from MS-DOS, but it\’s still a valuable source of automation that anyone can use with no programming knowledge at all.

In the past couple weeks I’ve been evaluation job ads that are looking for administrative assistants and evaluation the administrative assistant qualifications that employers think are important.  There is a lot of variety from job to job that will depend on the field in question but some of the skills that employers look for are consistent.  

Here are the top 5 administrative assistant qualifications that I’ve found employers are looking for:

• 70% are looking for people that are able to work with the public and provide information. This is not as easy as it sounds.  This includes having excellent written communication skills as well as verbal communication skills.  And don’t forget there is also body language to consider.  How good are you are reading people’s non-verbal signs?  Of course,  you also need to be able to handle challenging customers and you need to be able to recognize which ones are going to be the most challenging for you.
• 55% require a good knowledge of Microsoft Word. Word is used often by administrative assistants.  Through the day they will use it to compose memos, reports, and both informal and formal documents.  They may also use it to create PDF files or newsletters.
• 50% want all around knowledge of Windows and Microsoft Office. Windows and Microsoft Office knowledge is one of the most highly sought skills because most offices use them today.  While some offices use others this software is the most affordable and easiest to understand.
• 50% expect administrative assistants to have excellent verbal communications. Every day administrative assistants are expect to answer the phone and greet customers and business partners that come into the office and it is imperative that they are able to relay information efficiently.
• 45% require a good knowledge of Microsoft Excel. While Word is likely used most often by administrative assistants, Excel come in right behind it.  Creating and maintaining spreadsheets of company information is one of the essential administrative assistant qualifications because it helps managers make decisions about future business.

So, do you have these qualifications? If not, it might be time to consider upgrading your education!

Although the phrase \”less if more\” is closely related to modern architecture, you can easily apply it the hottest upcoming trend in software design and engineering.

At first glance it would seem that simplicity flies in the face of the high tech world where one often needs technical manuals to navigate the increasingly sophisticated programs and gadgets.

When asked recently if a certain feature would be possible to add to a program, a Google product development employee said that yes, it was possible, but that he wouldn\’t do it. The feature was too complex and would cause confusion.

This is a sea change in the high tech world. It symbolizes a new, fresh approach that is the driving force behind today\’s best tech products. The principles of simplicity adopted by companies such as Google will alter the balance of power in the tech industry.

The old school model

A classic example of the old way of doing things can be best illustrated with a product such as Microsoft Word.

We are talking about one of the most popular applications ever. It was one of the first word processors to feature WYSIWYG (what you see is what you get) technology, along with a toolbar. By the mid 1990\’s Word had delivered a knockout punch to Word Perfect as the most popular word processor.

However, as the popularity of Word grew, both Windows and Mac flooded the company with suggestions on changes that were supposed to make it better. Microsoft took many of those suggestions, and each incarnation of Word had a greater array of features than the former. Today, the application is so bloated and bogged down that even basic tasks can be difficult for an inexperienced user.

This scenario has played itself out many times over. Large products such as ERP suites and

Microsoft Office fell victim to this mentality, as well as smaller applications such as line-of-business apps, which are used extensively in niche industries such as government and health care. Even hardware has been subject to this approach to some degree. An example of this is laptops and desk tops with redundant ports, confusing buttons and unused function keys.

The ever increasing demand for computer technology resulted in these kinds of traditional tech products. The development process became inefficient with less thought dedicated to the overall design and functionality of the products. To put it simply, simplicity flew out the door.

An evolution of user experience

We return now to the phrase \”less is more.\” Call it the new mantra of building tech products. Removing redundant or rarely used features is just the opposite of the old way, where new features and functions were tacked on to the existing product. In the past, user requests were implemented that may not have reflected the larger user base. A more disciplined approach mandates moving back to the core functionality of a product and avoiding the \”product creep\” of the past.

That is the basic philosophy of our own Australia-based company, Clinical Excellence Technologies, (clinicalexcellence.com.au) which creates web solutions for critical clinical needs. This software revolution is transforming the way patient care is managed and shared among mental health professionals.

From the start of the engineering process we created the software to be so intuitive and easy-to-use that a nurse could create a comprehensive care plan for a patient with only a few clicks of the mouse. If in the past it might have taken her an hour to accomplish this task, with the self-evident software we created it can take her two minutes. This allows her to spend more time with patients and can save hospitals many hours in wasteful labor costs.

The result of this new, disciplined approach to building products is self-evident. Stripped down GUI\’s (graphical user interface), along with the success of products and services like iPad, Android, Gmail and Salesforce.com are becoming the standard. The self-evidence the user experiences is obvious: There is no need to consult user manual, nor is any significant training required to use those products.

As user experiences become more self-evident, the expectation for easy-to-use products will continue to grow. Product builders may have difficulty with the new discipline. Many ideas and features that in the past may have been added will now be deemed unnecessary. The discipline comes with paring down a product to its absolute core functionality.

There are many companies that do not possess the talent, corporate culture, or ability to follow-through with this kind of discipline and sophistication. Some companies, such as Nokia and BlackBerry have backward compatibility issues that are holding them back. Both of these companies are being overtaken by self-evident products such as iPhone and Android. In the case of Nokia and BlackBerry, their large, installed bases make them hesitant to iterate too quickly. The result is complex products that have many of the same issues as Microsoft Word.

There are signs though, that even companies such as Microsoft are starting to adopt the discipline necessary to produce self-evident products. Windows Phone 7 and the Bing search engine fall into the category of simpler, self-evident products. What they will ultimately do with Windows and Office is another matter, but there are signs they are moving in the right direction.

It may be tempting to think that the idea of a self-evident user experience means products will be less sophisticated or \”dumbed down,\” so to speak. Many new products will have fewer features, and the ones that will be included are going to be aimed at core functionality. At Clinical Excellence Technologies we embrace the words of Leonardo da Vinci, \”Simplicity is the ultimate sophistication.\”

Gateway NV5370u

Gateway NV5370u
Save on Gateway NV5370u. Free Shipping, Order Now!

You can Buy Gateway NV5370u In Stock. Gateway NV5370u Shops or Buy Online – At Lowest Pirce you Save BIG!

This is a gift for me to replace my old Gateway 2004 laptop. What a contract! For less than $ 600 you get super-fast processor, plenty of space, and Windows 7 (which, incidentally, is leaps better than Vista). I like the feeling of the keyboard. Is not as tight as a typical laptop keyboard, so it hurts your hands after playing. It also has a number of buttons on the right side of the letter keys, which I like. This computer has a built-in wireless card, and an Internet connection very easy. I just had to do something to connect to my wireless home network. Wow! The screen is bright and clear. And it all weighs about 5 or 6 pounds … much easier on the shoulders when lugging around the airport! 

In a few drawbacks I found with this laptop handle mouse pad. I had to play a little mouse pad properties is as sensitive as I like. It took a little \’digging to find the \”Mouse and indicators\” folder in Control Panel, but I think Windows 7 questions, and Gateway is not a problem. The second thing is the mouse button. Sometimes the left click is too sensitive to the wind in the selection / remove a certain point, when all I want to do is choose. Not a big problem … just a little \’uncomfortable. But I\’m very gesture of the mouse pad is very cool. This makes it very easy to scroll through long documents and web pages. 

With the only office suite is supplied with the others (and I think that the Windows-based PCs today): It comes with Microsoft Works rather than Microsoft Office. MS thesis type of smell … And \’watered-down version of Office I have to worry much, because they are not the same opportunities and practical programs such as Word and Excel. You can buy MS Office 60-day trial, but I would not have to deal with appeals. I\’d rather pay more to do ahead and do it again. 

In general, I found all the advantages outweigh the disadvantages. I love this computer and I am very satisfied. Gateway computer served me well over the past 15 years, and I would not buy anything else.

Yes! we have \”Gateway NV5370u\”. You can Buy Gateway NV5370u In Stock. Lowest Prices on Gateway NV5370u Shops & Purchase Online – Buy today you Save BIG!

Gateway NV5370u 15.6-Inch Laptop (Black)

Great computer, great price!

This was a present to myself to replace my old 2004 Gateway laptop. What a deal! For less than $600 you get a super-fast processor, tons of storage space, and Windows 7 (which, BTW, is leaps and bounds better than Vista). I like the feel of the keyboard. It\’s not quite as cramped as a typical laptop keyboard, so your hands don\’t ache after typing a lot. It\’s also got a set of number keys at the right of the letter keys, which I love. This computer has a built-in wireless card, and it makes connecting to the internet extremely easy. I hardly had to do anything at all to make it connect to my home wireless network. Yay! The screen is bright and crisp. And the whole thing weighs about 5 or 6 pounds…SO much easier on my shoulders when lugging it through an airport! 

The very few cons I found with this laptop deal with the mouse pad. I had to play around a bit with the mouse pad properties to make it as sensitive as I like. It took a bit of digging to find the \”Mouse & Pointers\” folder in the Control Panel, but I think that is a Windows 7 issue and not a Gateway issue. The other thing is the mouse buttons. Sometimes the left-click button is too sensitive, so you wind up selecting/unselecting an item when all you want to do is just select it. It\’s not a huge deal…just a little annoying. But I do find the multi-gesture mouse pad to be pretty cool. It makes it very easy to scroll through long documents or web pages. 

The only other con is the Office package it comes with (and I think this is across the board with Windows-based computers these days): It comes with Microsoft WORKS rather than Microsoft OFFICE. MS Works kind of stinks…it\’s a watered down version of Office, which I don\’t care for much because it doesn\’t have the same capabilities as the real programs like Word and Excel. You do have the option to purchase MS Office after a 60-day trial, but I wish I didn\’t have to bother with the download. I\’d rather just pay extra up front and have it already. 

Overall, I found all the pros outweigh the cons. I love this computer and I am very happy with it. Gateway computers have served me well over the last 15 years and I wouldn\’t buy anything else.

BuyingGateway NV5370u 15.6-Inch Laptop (Black)

Gateway NV5370u 15.6 inch laptop – Love it!!!

Of course this is my FIRST laptop so I don\’t have much to compare to but I absolutely love it! It has all the features, built in\’s and programs that I need and more. I can finally multi task and keep up with the jones!!  

There are however just a couple lil things I\’m having issues with… The battery life is only about 3 hours and I didn\’t realize how fast that REALLY flies… So that\’s a bit of a bummer. 

I absolutely needed and wanted the number pad on the right like on a regular keyboard but I was disappointed to see the decimal point is on the top and so I\’m not as quick as I used to be keying in figures. But that may just be a matter of getting used to… Still glad I got one with the number key. 

Lastly, my biggest pet peeve is that the mousepad (also taking some time to get used to) is not centered right in the middle of the laptop. I\’m funny about having things being all even and this is mostly a \’look\’ issue. If the mousepad was centered, the number keys like a desktop keyboard and a longer lasting battery, this would be absolutely PERFECT! 

Overall I am very pleased with it and would recommend it to anyone. I can watch a movie, play a game, chat on IM and go through email with ease and of course with Windows 7, it just makes it all the more easier!! 

If I had to do it all over again, I would still get this one in an instant!! 

Can\’t beat the price either. After all said and done, I paid just under $600 which was about $400 less than what I was expecting to pay!! Kudos to Gateway for a great laptop!!

CheapGateway NV5370u 15.6-Inch Laptop (Black)

Wonderful Laptop

This laptop is everything you could ever want and MORE! It performs very well, and looks great. I have nothing but great things to say about it!

CheapestGateway NV5370u 15.6-Inch Laptop (Black)

Fast, reliable, but not without some warts

I\’ve been using this machine for about a month now. The basics of this Gateway notebook are solid, for the most part. Fast, lots of storage, good functionality. 

All the same, there are some problem areas. The single biggest is the keyboard, which is poorly designed and a pain to use. Tiny control keys in the corners of the keyboard, an even tinier delete key in the top row, and other issues make this hard to use me. But this is subjective, of course, so it may not be a problem for you. 

Documentation: Gateway provides an icon on the desktop intended to provide info on the computer. But if you want to eg. find out what features the machine comes with, …it tells you to look at the label on the box the machine came in. ;-< It doesn\’t provide a lot of info on other aspects of functionality either. 

The touchpad is sometimes oversensitive. The case seems to be a dust magnet. And there are a few other minor issues. Otherwise, though, it performs as advertised. 

I\’d recommend this machine only if the keyboard isn\’t a deal-breaker for you. I probably would\’ve bought some other machine had I been able to try this one out before ordering. IAC I\’ll be using an external keyboard whenever I\’m not on the road. 

Read More About Gateway NV5370u 15.6-Inch Laptop (Black)

Best buy for \”Gateway NV5370u\”, Lowest Price Gateway NV5370u + Free shipping. Don\’t miss Gateway NV5370u, Cheapest Gateway NV5370uBuy Online – Get it Now!

Copyright © 2009 All rights reserved.

We associated with Amazon

Windward Reports Announces New Gauges and Dashboards

12/23/2009

Boulder, CO – Windward Reports announced today the latest addition to their versatile reporting package: sophisticated gauges and dashboards easily created in Microsoft Office. These unique and powerful tools will help provide companies with solid the business intelligence so crucial to better business decision making.
AutoTag, the Windward Reports design tool, lets users create reports and other business documents in Microsoft Word, Excel and PowerPoint. Businesses save time and money while gaining increased understanding into company data. Organizations can now use Windward Reports to create sophisticated gauges and dashboards, giving companies up-to-the-minute information on where they\’ve been, where they stand, and where they\’re headed.

\”With gauges and dashboards in Windward Reports, we’re revolutionizing the way companies incorporate reporting into their daily lives,\” said David Thielen, CTO of Windward. \”Not only are our customers getting real-time access to the information they need to run their business, but they’re able to use that information to make more informed business decisions. This directly leads to a competitive advantage in our rapidly evolving world where every second counts.\”

Because reports are designed in Office, there\’s little learning curve. Users create gauges and dashboards with the help of step-by-step wizards that make inserting data a snap. Windward Reports works with a wide range of data sources, including SQL databases, XML files, Excel spreadsheets and custom sources, to create complete and comprehensive reporting, document generation, mail merge, dashboard and BI systems.

\”Gauges help Windward Reports deliver critical information to anyone in any company whenever it is needed,\” said Tomas Ramirez, a lead software developer at Windward. \”Critical information is now available at the click of a button, and gauges and dashboards are changing the way the world does business.\”

For more information about enhanced business intelligence with gauges and dashboards, please visit: http://www.windwardreports.com/

About Windward Reports
Launched in 2002, Windward Reports is the only full-featured, robust Java.NET reporting engine to use Microsoft Word (or other MS Office programs) as a layout tool, putting report-design and generation power in the hands of the end user, technical or non-technical. Any Word user can easily and securely create reports with almost no learning curve. Also unique, Windward Reports implements in hours, offers affordable server -based pricing, and offers ?prompt, fantastic? technical support via a 24/7 support forum and support contracts. Windward Reports works by merging any XML, SQL or custom data source—or any combination thereof—with a Microsoft Word report template. It feeds data into the template to create a what-you-see-is-what-you-get report that can be generated in PDF, .RTF, HTML, WordML, .XLS, SpreadsheetML, .TXT, or multipart- MIME-email format. Windward Reports runs as a standalone application or in an enterprise computing environment. Windward Reports developer and production systems are available for purchase or free trial at www.windwardreports.com.
Windward Reports’ user group spans 70 countries. User applications include financial statements, inventory reports, product-usage reports, purchase orders, invoices, training certificates, timesheets, and licenses. Other applications include reporting to meet requirements of Sarbanes-Oxley, Patriot Act, ARRA, HIPAA, Health Level Seven, Gramm-Leach-Blailey, Basel II, and other U.S. and international acts and accords affecting financial services, real estate, government, and insurance industries and the consultants and integrators serving them.

For Immediate Release
Press Contact: Lisa Harris
VP, Marketing
303-499-2544 x1184
lisah@windward.net

Computing technology has designed a perpetual modification in the style of professional exertion circuitously of the world. Information that was at one time emporium in storehouse safeguarding management can now be entranced without delay at the small noise of mouse identification. Instruction placed by customers in foreign countries can now be forthwith prepared on the bottom surface of any room of a fabrication facility. Although 15 years ago much of this information had been enchanted onto corporate mainframe databases, offices still worked in a batch-processing environment. If a query is needed to be accomplished, someone may apprise the management information systems department; the requested data are delivered as soon as possible nevertheless often not speedy and sufficient in normal manner.
In summing up to the outgrowth of the relational database archetype, two technologies led to the rapid growth of what are now called client/server database assemblage. The important momentous technology was the personal computer. Reasonable, easy-to-use applications such as Spreadsheet and Word Perfect enabled employees to create documents and accomplish data dashing and decently. The people, who are chain used to consecutively modernising systems, as the rate of modification was so expeditious, even as the price of the more highly evolved systems protracted to decline. The next substantial technology was the local area network (LAN) and its solidarity into offices across the world. Although users our established to end connections to a corporate mainframe, now word processing files could be stored locally within an office and accessed from any computer attached to the network. After the Apple Macintosh introduced a friendly graphical user interface, computers our not only economical and powerful but also easy to use. In addition, they could be accessed from remote sites, and large amounts of data could be off-loaded to departmental data servers.

In the course of rapid change and betterment, a new sort of system has appeared known as client/server development because processing is split between client computers and a database server; this new breed of application was a radical change from mainframe-based application programming. Among the many advantages of this type of the system are:
•Simplified supporting costs
•Uncomplicated network load (processing occurs on database server or client computer)
•Manifold functioning systems that can inordinate as long as they share a common network etiquette
•Improved data integrity owing to centralized data location
In developing Client/Server Computing, Bernard H. Boar defines client/server computing as follows:
\”Client/server computing is a processing model in which a single application is partitioned between multiple processors (front-end and back-end) and the processors cooperate (transparent to the end user) to complete the processing as a single unified task. Implementing Client/Server Computing a client/server bond product ties the processors together to provide a single system image (illusion). Shareable resources are positioned as requestor clients that access authorized services. The architecture is endlessly recursive; in turn, servers can become clients and request services of other servers on the network, and so on and so on. \”This type of application development requires an entirely new set of programming skills. User interface programming is now written for graphical user interfaces, whether it is MS Windows, IBM OS/2, Apple Macintosh, or the UNIX X-Window system. Using STRUCTURED QUERY LANGUAGE and a network connection, the application can interface to a database residing on a remote server. The increased power of personal computer hardware enables critical database information to be stored on a relatively inexpensive standalone server. In addition, this server can be replaced later with little or no change to the client applications. We can apply the basic concepts introduced in this book in many environments–for example, Microsoft Access running on a single-user Windows application or STRUCTURED QUERY LANGUAGE Server running with 100 user connections. One of STRUCTURED QUERY Language’s greatest benefits is that it is truly a cross-platform language and a cross-product language. Because it is also what programmers refer to as a high-level or fourth-generation language (4GL), a large amount of work can be done higher-level language 4GL (fourth-generation) language fourth-generation (4GL) language in fewer lines of code.

Oracle Corporation unconstrained the first mercantile RDBMS that promulgated STRUCTURED QUERY LANGUAGE. Although the original versions our developed for VAX/VMS systems, Oracle was one of the first vendors to release a DOS version of its RDBMS. (Oracle is now available on more than 70 platforms.) In the mid-1980s Sybase released its RDBMS, STRUCTURED QUERY LANGUAGE Server. With client libraries for database access, support for stored procedures (discussed on Day 14, \”Self-motivated Uses of STRUCTURED QUERY LANGUAGE\”), and interoperability with various networks, STRUCTURED QUERY LANGUAGE Server became a successful product, particularly in client/server environments. One of the strongest points for both of these STRUCTURED QUERY LANGUAGE Server powerful database systems is their scalability across platforms. C language code (combined with STRUCTURED QUERY LANGUAGE) written for Oracle on a PC is virtually identical to its counterpart written for an Oracle database running on a VAX system.
STRUCTURED QUERY LANGUAGE and Client/Server Application Development
The common thread that runs throughout client/server application development is the use client/server computing of STRUCTURED QUERY LANGUAGE and relational databases. Also, using this database technology in a single-user business application positions the application for future growth.
An Overview of STRUCTURED QUERY LANGUAGE
STRUCTURED QUERY LANGUAGE is the de facto standard language used to manipulate and retrieve data from these relational databases. STRUCTURED QUERY LANGUAGE enables a programmer or database administrator to do the following:
•Modify a database\’s structure
•Change system security settings
•Add user permissions on databases or tables
•Query a database for information
•Update the contents of a database
NOTE: The term STRUCTURED QUERY LANGUAGE can be confusing. The S, for Structured, and the L, for Language, is straightforward enough, but the Q is a little misleading. Q, of course, stands for \”Query,\” which–if taken literally–would restrict we to asking the database questions. But STRUCTURED QUERY LANGUAGE does much more than asks questions. With STRUCTURED QUERY LANGUAGE we can also create tables, add data, delete data, splice data together, trigger actions based on changes to the database, and store our queries within our program or database.
Unfortunately, there is no good substitute for Query. Obviously, Structured Add Modify Delete Join Store Trigger and Query Language (SAMDJSTQL) are a bit burdensome. In the interest of agreement, we will stay with STRUCTURED QUERY LANGUAGE. However, we now know that its function is larger than its name.

The most commonly used statement in STRUCTURED QUERY LANGUAGE is the SELECT statement that retrieves data from the database and returns the data to the user. The EMPLOYEE table example illustrates a typical illustration of a SELECT statement situation. In addition to the SELECT statement, STRUCTURED QUERY LANGUAGE provides statements for creating new databases, tables, fields, and indexes, as well as statements for inserting and deleting records. ANSI STRUCTURED QUERY LANGUAGE also recommends a core group of data manipulation functions. As we will find out, many database systems also have tools for ensuring data integrity and enforcing security (see Day 11, \”Controlling Transactions\”) that enable programmers to stop the execution of a group of commands if a certain condition occurs.
Popular STRUCTURED QUERY LANGUAGE Implementations
This section introduces some of the more popular implementations of STRUCTURED QUERY LANGUAGE, each of which has its own strengths and weaknesses. Where some implementations of STRUCTURED QUERY LANGUAGE have been developed for PC use and easy user interactivity, others have been developed to accommodate very large databases (VLDB). This section introduces selected key features of some implementations.
Microsoft Access
We use Microsoft Access, a PC-based DBMS, to illustrate some of the examples in this text. Access is very easy to use. We can use GUI tools or manually enter our STRUCTURED QUERY LANGUAGE statements.
Personal Oracle7
We use Personal Oracle7, which represents the larger corporate database world, to demonstrate command-line STRUCTURED QUERY LANGUAGE and database management techniques. (These techniques are important because the days of the standalone machine are drawing to an end, as are the days when knowing one database or one operating system was enough. This tool then returns data to the screen for the user to see, or it performs the appropriate action on the database.
Most examples are directed toward the beginning programmer or first-time user of STRUCTURED QUERY LANGUAGE. We begin with the simplest of STRUCTURED QUERY LANGUAGE statements and advance to the topics of transaction management and stored procedure programming. The Oracle RDBMS is distributed with a full complement of development tools. It includes a C++ and Visual Basic language library (Oracle Objects for OLE) that can link an application to a Personal Oracle database. It also comes with graphical tools for database, user, and object administration, as well as the STRUCTURED QUERY LANGUAGE Loader utility, which is used to import and export data to and from Oracle.
We select the Personal Oracle7 RDBMS for several reasons that are vitally important for creating object oriented database customised software
•It includes nearly all the tools needed to demonstrate the topics discussed in this book.
•It is available on virtually every platform in use today and is one of the most popular RDBMS products worldwide.
•A 90-day trial copy can be downloaded from Oracle Corporation\’s World Wide Web server.
Microsoft Query is a useful query tool that comes packaged with Microsoft\’s Windows development tools, Visual C++, and Visual Basic. It uses the ODBC standard to communicate with underlying databases. Microsoft Query passes STRUCTURED QUERY LANGUAGE statements to a driver, which processes the statements before passing them to a database system. ODBC is a functional library designed to provide a common Application Programming Interface (API) to underlying database systems. It communicates with the database through a library driver, just as Windows communicates with a printer via a printer driver. Depending on the database being used, a networking driver may be required to connect to a remote database.

The unique feature of ODBC as compared to the Oracle or Sybase libraries is that none of its functions are database-vendor specific. For instance, we can use the same code to perform queries against a Microsoft Access table or an Informix database with little or no modification. Once again, it should be noted that most vendors add some proprietary extensions to the STRUCTURED QUERY LANGUAGE standard, such as Microsoft\’s and Sybase\’s Transact-STRUCTURED QUERY LANGUAGE and Oracle\’s PL/STRUCTURED QUERY LANGUAGE. We should always consult the documentation before beginning to work with a new data source. ODBC has developed into a standard adopted into many products, including Visual Basic, Visual C++, FoxPro, Borland Delphi, and Power Builder. As always, application developers need to meditate on the advantage of using the emerging ODBC standard, which enables we to design code without regard for a specific database, versus the speed gained by using a database specific function library. In other words, using ODBC will be more portable but slower than using the Oracle7 or Sybase libraries.

STRUCTURED QUERY LANGUAGE in Application Programming including Object linking and embedding

STRUCTURED QUERY LANGUAGE was in the beginning created an ANSI criterion in 1986. The ANSI 1989 standard (often called STRUCTURED QUERY LANGUAGE-89) defines three types of interfacing to STRUCTURED QUERY LANGUAGE within an application program:
•Module Language– Uses procedures within programs. These procedures can be called by the application program and can return values to the program via parameter passing.
•Embedded STRUCTURED QUERY LANGUAGE–Uses STRUCTURED QUERY LANGUAGE statements embedded with actual program code. This method often requires the use of a precompiled to process the STRUCTURED QUERY LANGUAGE statements. The standard defines statements for Pascal, FORTRAN, COBOL, and PL/1.
•Direct Invocation–Left up to the implementers.
Before the concept of dynamic STRUCTURED QUERY LANGUAGE evolved, embedded STRUCTURED QUERY LANGUAGE was the most popular way to use STRUCTURED QUERY LANGUAGE within a program. Embedded STRUCTURED QUERY LANGUAGE, which is still used, uses static STRUCTURED QUERY LANGUAGE–meaning that the STRUCTURED QUERY LANGUAGE statement is compiled into the application and cannot be changed at runtime. The principle is much the same as a compiler versus an interpreter. The performance for this type of STRUCTURED QUERY LANGUAGE is good; however, it is not flexible–and cannot always meet the needs of today\’s changing business environments. Dynamic STRUCTURED QUERY LANGUAGE is discussed shortly.
The ANSI 1992 standard (STRUCTURED QUERY LANGUAGE-92) extended the language and became an international standard. It defines three levels of STRUCTURED QUERY LANGUAGE compliance: entry, intermediate, and full. The new features introduced include the following:
•Connections to databases
•Scrollable cursors
•Dynamic STRUCTURED QUERY LANGUAGE
This obsession covers not only all these extensions but also some proprietary extensions used by RDBMS vendors. Dynamic STRUCTURED QUERY LANGUAGE allows we to prepare the STRUCTURED QUERY LANGUAGE statement at runtime. Although the performance for this type of STRUCTURED QUERY LANGUAGE is not as good as that of embedded STRUCTURED QUERY LANGUAGE, it provides the application developer (and user) with a great degree of flexibility. A call-level interface, such as ODBC or Sybase\’s DB-Library, is an example of dynamic STRUCTURED QUERY LANGUAGE. Call-level interfaces should not be a new concept to application programmers. When using ODBC, for instance, we simply fill a variable with our STRUCTURED QUERY LANGUAGE statement and call the function to send the STRUCTURED QUERY LANGUAGE statement to the database. Errors or results can be returned to the program through the use of other function calls designed for those purposes. Results are returned through a process known as the binding of variables.

 The world today has gone literally gone acronym crazy. Every industry has its own plethora of acronyms to bamboozle the uninitiated. Acronyms are also often a source of great pain for those people who have to create procedure documents for their industry. There is a way to survive this turmoil through the power of Autocorrect and it will definitely save you time.

Autocorrect was originally developed by Microsoft to help those people using Microsoft Office and in particular Microsoft Word overcome typing issues but it has also become the saviour to those working in an acronym world.

I hear you saying it, HOW!

An acronym in essence is short couple of characters that have a special meaning for example in Australia we have a term called the Australian Business Number which has an acronym abn. If you were producing a lot of documents that refer to the term Australian Business Number you would find it takes a little time to right that whole name. In many cases it would be inappropriate to actually use the acronym. What Autocorrect allows you to do is to program into the application the term abn and associate it with the full name Australian Business Number.

What this means is that when you are typing your documents and you need to refer to the term Australian Business Number, you simply type in abn and as you press the space bar Microsoft Word will then convert the acronym abn to Australian Business Number.

So why does it do this?

Like I mentioned before, Autocorrect was really developed to overcome the issue of people mistyping words. Essentially as you type Autocorrect checks to see if what you are typing is correct and if its not it will correct it with the options in the Autocorrect list. Some of the common typing mistakes you might incur would cna instead of can. If you open Microsoft Word and type in cna it will automatically correct it to can.

Autocorrect is actually available in all Microsoft Office Applications which include Microsoft Word, Excel, PowerPoint, Access, Publisher, Outlook and FrontPage. Now the really cool part about this is that if you setup an Autocorrect entry in say Microsoft PowerPoint, it will also be available in all of the other applications. This means that you are going to save time both in the initial setup but also whilst you are creating these documents.

If you find that when you tried the example I gave to you before that it did not convert the misspelt word to the correct word then most likely the AutoCorrect function has been turned off. To turn it on in Microsoft Word 2003 simply choose the Tools menu and then choose AutoCorrect Options. You will see a checkbox next to the words \”Replace Text as you type\”. If the checkbox does not have a tick next to it then you need to click once on the check box to activate it. Then finish off the process by pressing the OK button.

There are three autocorrect entries which I think are absolutely essential to know and that is how you can insert the Trade Mark Symbol, Registered Symbol and Copyright Symbol without using the symbol command. All you do is type the following -

(tm) – Creates the Trade Mark Symbol

(c) – Creates the Copyright Symbol

(r) – Creates the Registered Symbol

Autocorrect is certainly one of the tools that I think is really cool but is often misunderstood and not used to its full potential. Using AutoCorrect in this way will save you hours of time when dealing with acronyms. It might take a little time setting up your acronyms but once its completed it will save you countless hours and make you far more efficient and effective in using the Microsoft Office Suite

Pick up any \”business opportunity\” magazine at your local newsstand and you\’ll see a glossy attractive publication designed to attract people who are actively seeking ways to earn extra money, buy a franchise, or open a business of their own. After all, it\’s the American Dream to own your own business and get rich, right?

You\’ve probably heard the old saying, \”Most people are too busy earning a living to make any money.\” Common sense tells us that we\’re not going to get rich working for someone else, with the exception of lucky folks like those who started with Microsoft or Google in their early days and got rich through stock options. The average American employee lives from paycheck to paycheck with barely enough income to cover their living expenses, leaving nothing for investment toward building wealth for a comfortable retirement. Hence the allure of the \”Business Opportunity.\”

As you flip through one of these \”BizOpp\” magazines, you\’ll see a wide variety of advertisements for different types of businesses, ranging from simple \”starter kits\” for around $29 all the way to sophisticated franchises costing $100,000 or more. For most people, it\’s impossible to raise enough capital to consider opening a true franchise. The franchise fees alone are often prohibitive, running into tens of thousands of dollars even for the lesser known businesses, or several hundred thousand dollars for better known companies. And that\’s not even including the outlay required to actually open the doors for business.

At the other end of the scale, most people are aware that the cheap starter kits and \”business in a box\” packages are basically junk. But that leaves a whole host of medium-priced business startup concepts, ranging in price from around $500 on the low end to $10,000 on the upper end. I refer to these as \”pre-packaged business opportunities.\”

To explain why pre-packaged businesses are usually a waste of time and money, I\’ll use windshield repair as an example. As I write this, I\’m looking at an ad for a training program that costs $3,000, including starter materials. In case you don\’t know what I\’m referring to here, the basic idea is that small chips, cracks, or holes in automobile windshields can be repaired using a special liquid material that seals and repairs defects. This is obviously much cheaper than replacing an entire windshield. Hence the \”opportunity\” to start a business that helps people save money on their windshield repairs.

Now, in case you\’re thinking, \”There\’s no way I would want to be in that business,\” please bear in mind I\’m just using this as an example out of hundreds of possible different business concepts advertised in the same fashion. And of course there are many people who would be attracted to such a \”business opportunity\” — people who really like cars, people who already know quite a bit about auto repair, and so on. Plenty of individuals are attracted to a business idea like this, which is why this particular \”opportunity\” has been around for decades.

Now, here\’s the real question. Can you seriously expect to shell out $3,000 for some starter materials and training in the windshield repair business, then put a sign out, and expect to start earning money right away? Of course not! This is the #1 flaw with pre-packaged business opportunities: you still have to figure out how to market the product or service on your own.

Let\’s take a closer look at the windshield repair business. Let\’s say your goal is to make $50,000 per year in net income. If we assume that you can charge around $50 per windshield repair, at a material cost of around $10, then you have a gross profit (not counting your labor) of $40 per repair. To make $50,000 net, you\’d need to find 1,250 windshields per year that required fixing. That translates to more than 100 repairs per month, and you\’d need to keep this up month in and month out to meet your income goal. That works out to 3-5 repairs per day, depending on how many days per month you work.

Now, if you had 1,250 cars lined up down the road, all ready for the repair work, it would be nice easy money, right? But FINDING those 1,250 cars and then SELLING those 1,250 car owners on your service will be the real problem. In other words, you don\’t really have a windshield repair job here. You have a SALES job, pure and simple. Most of your time will be spent finding business. Obviously, finding one car at a time will be totally impractical. Instead, you\’ll need fleet accounts with major car dealerships, auto repair shops, car rental agencies, and so on. And you can bet that a number of other people (some of whom bought the same pre-packaged business that you did) have also solicited the same companies for their windshield repair business.

So again, what you really have here is a sales job. If this were a truly profitable business, then the company selling you the \”opportunity\” would not be making all their money selling pre-packaged businesses to people like yourself. Instead, they would be making their money by rolling out the service across the country and selling windshield repair directly to fleet accounts on a nationwide basis. But they know that there is actually more money to be made in the BizOpp world, preying on people who have the dream of starting their own business.

The message here is that any pre-packaged business opportunity that sells in the $500 to $10,000 range is typically worthless and a complete waste of your time and money. Please bear in mind that these numbers are just a guideline, and you must always exercise good judgment when evaluating any business opportunity. Just because a \”hot\” pre-packaged opportunity is selling for more than $10,000 does not mean that it is necessarily legitimate. Many rip-offs cost a lot more than that. But generally speaking, the promoters of these schemes realize they are aiming at people who can\’t pay a lot of money to get started in business. So the packages are marketed in a way that will maximize the number of people that can afford to buy in.

If you are serious about starting your own business, then a pre-packaged opportunity is not the way to go. It might seem like an easy answer to your problem, but the very fact that it\’s being sold as a packaged business probably means that there\’s no real money to be made without a long hard sales grind. You\’re much better off doing your own research, coming up with your own business ideas, and then testing your ideas with small advertisements to see if your concepts have any real potential. That\’s how many businesses get their start. You\’ll have a much better chance of making it in the world of business or self-employment if you ignore those BizOpp magazines entirely!