Q: What is Software Installation and Setup? A:
Installing new software on your computer and setting all the options and
properties settings of the program to optimal values. Sometimes problems are
encountered that can only be resolved by communicating with the software
manufacturer or the manufacturer of your computer or one of its peripheral
devices.
Q: What is Software Configuration? A:
Setting all the options and properties settings of the program to optimal
values.
Q: What is Computer Configuration? A:
Setting all the options and properties settings of the computer to optimal
values.
Q: What is Network Configuration? A:
The layout and settings of every computer and piece of equipment on your LAN
(Local Area Network) or Intranet. This includes devices like routers and
gateways that interconnect your LAN with other LANS or the Internet.
Q: What is Database Design? A: Database servers like SQL Server,
Sybase, Oracle, and DB2 are referred to as RDBMS which stands for
Relational Data Base Management System. The word Relational in this name refers
to the way related information is stored and organized. In the real world items
of business data are also related. Good database design faithfully embodies and
reproduces these real world relationships into a data model which can be
represented electronically. This electronic data model can be viewed graphically
or used to create the tables and other database structures necessary to store
and retrieve data.
Q: What is Database Implementation? A: Creating the tables and
other database structures necessary to store and retrieve data must be done
before any data can be stored in a database. Reading, Writing and Updating the
data in a database system is done by submitting SQL queries to the database
server. The SQL Queries must be written before any data can be written to or
read from the database.
Q: What is a Multi-User System? A:
A Multi-User system allows several people to access data from the same database
at the same time. It is commonly implemented using a RDBMS Server like SQL
Server, Sybase, Oracle or DB2 to do the really tricky stuff like handling record
locking and other conflicts that might arise like 2 airline agents trying to
book the same last seat on a busy flight.
Q: What is a Work Flow Automation Script? A:
A Work Flow application has tasks that must be completed by several people on
their computers. This flow is analogous to the path a piece of paper takes in a
paper based system. An example would be a purchase requisition which needs to be
created by the person requesting an item then approved by his manager and
possibly their manager before being approved. After approval the requisition
would be routed to the Purchasing Agent who might split the requisition into
several Purchase Orders before submitting them to their manager for Approval and
purchase.
MS Word, Office and many other software packages can be "Automated"
with small scripts and programs. This feature can be used to customize the
software packages to your business and handle work flow. Automation
scripts can also be used to simplify repetitive tasks.
Q: What is Active X Automation and Scripting? A:
ActiveX® controls are among the many types of components that use COM
technologies to provide interoperability with other types of COM components and
services. ActiveX controls are the third version of OLE controls (OCX),
providing a number of enhancements specifically designed to facilitate
distribution of components over high-latency networks and to provide integration
of controls into Web browsers. These enhancements include features such as
incremental rendering and code signing, to allow users to identify the authors
of controls before allowing them to execute.
Active X Controls can be controlled and manipulated by scripts and programs.
WSH (Windows Scripting Host) scripts are very useful for this.
Q: What is Windows Scripting Host Scripting? A:
Windows Scripting Host (WSH) is a language-independent scripting host that
allows you to run any script engine on the Windows operating system. For
example, one script can be run with the VBScript script engine, and another
could be run with Jscript, and yet another could be run with perl. WSH also
extends the functionality of the scripting engines it supports by providing
access to the Windows Common Object Model (COM) and all of the COM objects built
into or installed on a Windows System. Distributed COM (DCOM) provides WSH
scripts access to COM objects residing on other systems on a network.
Q: What is Dynamic Data Exchange? A: Windows DDE (Dynamic Data
Exchange) sends messages between applications that share data and uses shared
memory to exchange data between applications. Applications can use the DDE
protocol for one-time data transfers and for continuous exchanges in which
applications send updates to one another as new data becomes available.
Q: What is AppleScript? A:
AppleScript is an English-like language used to
write script files which can control the actions of the Apple Macintosh computer and the
applications which run on it. Scripts can make decisions based on
user-interaction or by parsing and analyzing data, documents or situations.
AppleScript scripts can automate much of what you do, make actions on your
computer more productive.
Q: What is an Electronic Form? A: An on screen form that can be used
to gather data from users or to display data in a form that can be printed out
and look like exactly like the paper form that it replaces.
Q: What is a Spread Sheet? A:
A spread sheet represents data in a table like fashion consisting of rows of
data organized in columns. Spread Sheet Programs like Lotus 123 and Microsoft
Excel are like erector sets for building these smart self calculating marvels.
Spread sheets can be used to calculate and display financial projections or
financial statements.
Q: What is Data Table? A:
A Data Table is a database object that stores 1 or more rows of tabular data
stored in columns. Data Tables can be linked together or related by a common
column.
Q: What is an Accounting System Add-On? A:
A small external custom program, script or database stored procedure that
performs some special task that could not be performed by the accounting system
by itself as received from its manufacturer.
Q: What is MS Access Scripting? A:
Automation scripts that manipulate data in MS Access. These types of scripts can
be used for Work Flow automation to repeat tedious tasks.
Q: What is MS Outlook Scripting? A:
Automation scripts that send receive or manipulate e-mail data in MS Outlook.
These types of scripts can be used for Work Flow automation to repeat tedious
tasks.
Q: What is MS Word Scripting? A:
Automation scripts that send receive or manipulate word processor data in MS
Word. These types of scripts can be used for Work Flow automation to repeat
tedious tasks.
Q: What is MS Excel Scripting? A:
Automation scripts that send receive or manipulate Spread Sheet data in MS
Excel. These types of scripts can be used for Work Flow automation to repeat
tedious tasks.
Q: What is MS Office Scripting? A:
Automation scripts that send receive or manipulate data in MS Office
Applications. These types of scripts can be used for Work Flow automation to
repeat tedious tasks.
Q: What is SSL? A:
The SSL (Secure Sockets Layer) Handshake Protocol was
developed by Netscape Communications Corporation to provide security and privacy
over the Internet. The protocol supports server and client authentication.
The SSL protocol maintains the security and integrity of the transmission
channel by using encryption, authentication and message authentication codes. SSL is widely used to protect sensative information like E-Commerce credit card and customer data.
Q: What is Back Office Development? A:
Application Programs that run on servers (dedicated computers located in closets
or data centers which are not normally used by humans). They might be utility
programs for massaging or converting data or the middle tiers of a client server
system. Back End Server programs are a way to plug in specific new functionality
to the programmable database and server programs that support your company.
Q: What is a SQL Server Add-On? A:
?A stored procedure or external stored procedure program or script that performs
some special task that could not be performed by SQL Server by itself as
received from Microsoft.
Q: What is a Crystal Report? A:
Crystal reports is a tool for creating reports based on the information in a
RDBMS (Relational Data Base Management System). The reports can show the latest
data in the database or the data for a particular date.
Q: What is System Administration? A:
Setting all the options and properties settings of the programs you use to optimal
values.
Q: What is Data Conversion? A:
Converting or transforming data from one format to another format.
Q: What is Data Migration? A:
Exporting data from one database system and Importing that same data into a new
database system.
Q: What is Data Import and Export? A:
A Data Export takes all the data in a database system and exports it to a file
in a standard de limited format. A Data Import takes standard de limited data
from a Data Export File and loads it into a database system.
|