Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
|
Got an interview tomorrow for an IT Assistant job, but it is 'desirable' if the applicant has a knowledge/understanding of: Citrix Meta Frame, Fox Pro, SQL and Microsoft Exchange...
Can you guys give me some info to help me look clever tomorrow please 
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
why?
why not tell him what you do know?
If you make up shit and pretend to be really clever, he puts you in a position where you need to talk/explain about it and you look like an idiot.
|
SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
dont do that mate.. cos otherwise you could look really stupid when they ask you something about it 
just trying to help matey
|
James_DT
Member
Registered: 9th Apr 04
Location: Cambridgeshire
User status: Offline
|
Maybe you should go for a job you're qualified to do.
|
Melville
Member
Registered: 4th Jun 03
Location: Newcastle upon Tyne
User status: Offline
|
tell them that if you type =sum(cellrange) in excel it will add it up for you 
|
Mark Petty
Member
Registered: 26th Jul 01
Location: Bournemouth Drives: Suzuki gsf600
User status: Offline
|
Help on SQL:
SQL is a Standard - BUT....
SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc.
Unfortunately, there are many different versions of the SQL language, but to be in compliance with the ANSI standard, they must support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others).
Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!
--------------------------------------------------------------------------------
SQL Database Tables
A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.
Below is an example of a table called "Persons":
LastName FirstName Address City
Hansen Ola Timoteivn 10 Sandnes
Svendson Tove Borgvn 23 Sandnes
Pettersen Kari Storgt 20 Stavanger
The table above contains three records (one for each person) and four columns (LastName, FirstName, Address, and City).
--------------------------------------------------------------------------------
SQL Queries
With SQL, we can query a database and have a result set returned.
A query like this:
SELECT LastName FROM Persons
Gives a result set like this:
LastName
Hansen
Svendson
Pettersen
Note: Some database systems require a semicolon at the end of the SQL statement. We don't use the semicolon in our tutorials.
--------------------------------------------------------------------------------
SQL Data Manipulation Language (DML)
SQL (Structured Query Language) is a syntax for executing queries. But the SQL language also includes a syntax to update, insert, and delete records.
These query and update commands together form the Data Manipulation Language (DML) part of SQL:
SELECT - extracts data from a database table
UPDATE - updates data in a database table
DELETE - deletes data from a database table
INSERT INTO - inserts new data into a database table
--------------------------------------------------------------------------------
SQL Data Definition Language (DDL)
The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables.
The most important DDL statements in SQL are:
CREATE TABLE - creates a new database table
ALTER TABLE - alters (changes) a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
Information on FoxPro:
With its local cursor engine, tight coupling between language and data, and powerful features, Visual FoxPro 9.0 is a great tool for building database solutions of all sizes. Its data-centric, object-oriented language offers developers a robust set of tools for building database applications for the desktop, client-server environments, or the Web. Developers will have the necessary tools to manage data—from organizing tables of information, running queries, and creating an integrated relational database management system (DBMS) to programming a fully-developed data management application for end users.
XML Web services created with Visual FoxPro 9.0 can be consumed by XML Web service clients of Visual Studio .NET 2003 including ASP.NET, and XML Web services created with Visual Studio .NET 2003 and any other standards-based XML Web service can be consumed by Visual FoxPro 9.0.
Product Highlights
Data-Handling and Interoperability
Create .NET compatible solutions with hierarchical XML and XML Web services. Exchange data with SQL Server through enhanced SQL language capabilities and newly supported data types.
Extensible Developer Productivity Tools
Enhance your user interfaces with dockable user forms, auto-anchoring of controls, and improved image support. Personalize the Properties Window with your favorite properties, custom editors, fonts, and color settings.
Flexibility to Build All Types of Database Solutions
Build and deploy stand-alone and remote applications for Windows based Tablet PCs. Create and access COM components and XML Web Services compatible with Microsoft .NET technology.
Reporting System Features
Extensible new output architecture provides precision control of report data output and formatting. Design with multiple detail banding, text rotation, and report chaining. Output reports supported include in XML, HTML, image formats, and customizable multi-page print preview window. Backward compatible with existing Visual FoxPro reports.
Easy to Upgrade
Upgrading to Visual FoxPro 9.0 is easy and rewarding, as it is the most advanced and reliable version of FoxPro ever released, and is 100-percent compatible with Visual FoxPro 8.0. Developers can even create applications with Visual FoxPro 9.0 and deploy them using the Visual FoxPro 8.0 runtime, as long as no new commands and features are implemented in the distributed application. This allows developers and teams to upgrade to Visual FoxPro 9.0 and benefit from the wealth of new productivity features, while transitioning existing applications to the newer runtime engine.
Info on ms Exchange:
What Is Exchange Server?
Published: June 8, 2004
Exchange Server, the Microsoft messaging and collaboration server, is software that runs on servers that enables you to send and receive electronic mail and other forms of interactive communication through computer networks. Designed to interoperate with a software client application such as Microsoft Outlook, Exchange Server also interoperates with Outlook Express and other e-mail client applications.
Meet the requirements for small and large organizations and get easy administration, support, and reliability with Exchange Server. Readily available deployment and support tools also make Exchange Server easy to manage.
E-mail messages are sent and received through what is commonly referred to as a client device such as a personal computer, workstation, or a mobile device including mobile phones or Pocket PCs. The client typically connects to a network of centralized computer systems comprised of servers or mainframe computers where the e-mail mailboxes are stored. The centralized e-mail servers connect to the Internet and private networks where e-mail messages are sent to and received from other e-mail users.
Client access functionality. Exchange Server offers you integrated collaborative messaging features such as scheduling, contact, and task management capabilities. Exchange Server 2003 runs on Microsoft Windows Server 2003 and Microsoft Windows 2000 Server operating systems. Microsoft Office Outlook 2003 runs on Windows-based computers and communicates with the server running Exchange Server through the MAPI protocol that includes powerful messaging and rich collaboration capabilities. Exchange Server also accommodates other client access through its support for Post Office Protocol 3 (POP3) and Internet Message Access Protocol 4 (IMAP4) protocols as well as support for Simple Mail Transfer Protocol (SMTP). Microsoft Outlook Web Access, a service in Exchange Server, accommodates what are known as thin clients (Web browser–based access clients).
Mobile access functionality. Exchange Server 2003 supports mobile devices such as Pocket PC and Smartphones and enables you to synchronize your Inbox, Calendar, and Contacts and Tasks lists so you can remotely check your appointments and other important information. Mobile device browsers are also supported through Exchange Outlook Mobile Access, which enables HTML, compressed HTML (CHTML), and Wireless Application Protocol (WAP) browser–based devices to access Exchange Server.
The Exchange Server collaboration features help you to share information quickly and efficiently. Typical collaborative scenarios include maintaining shared address lists that everyone can view and edit, scheduling meetings that include people and conference rooms by viewing associated free or busy schedules, the ability to grant other people, such as administrators, access to your mailbox on your behalf. You can also manage "rules" for processing messages on Exchange Server, giving you the flexibility to create auto-responses and automatic filing of incoming messages. For maximum collaboration productivity, choose the combination of Exchange Server 2003 and Outlook 2003.
Have fun mate 
|
Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
|
 cheers mark
|
|
