Microsoft Excel 2003 - Quick Reference Guide
File title:
Microsoft Excel 2003 - Quick Reference Guide
File content:
Starting Excel
Opening a New Workbook, Opening an Existing File, Saving a Worksheet, Viewing the Task Pane, Saving a Worksheet as a Web Page, Entering Data, Closing Worksheets, Using Repeat, Undo and Redo, Moving or Copying Data, Insert a Comment.
Output
Previewing your Workbook, Printing a Workbook or Worksheet, Emailing a Workbook, Previewing Printed Worksheets.
Working with Toolbars
Viewing the Various Toolbars, Repositioning a Toolbar.
Viewing Worksheets
Changing Views, Viewing Multiple Worksheets, Comparing Workbooks Side by Side.
Formatting Worksheets
Changing Font Properties, Inserting Hyperlinks, Formatting Margins.
Using Pictures in Worksheets
Inserting Images/Objects, Resizing Images/Objects.
Worksheet Manipulation
Selecting Worksheets, Selecting Rows and Columns, Adding a New Sheet, Moving a Sheet, Copying a Sheet, Deleting a Worksheet, Renaming a Worksheet, Color Coding a Worksheet Tab, Inserting Rows and Columns, Deleting Rows and Columns, Adjusting Column Width and Row Height, Freezing a Row or Column, Creating Footers and Headers, Using the Format Painter, Applying or Removing Cell Boarders, Merging Cells, Clearing Cell Format or Contents, Using AutoFill Feature to Create a Calendar, Using AutoFill Feature to Create a List of #, Using the AutoSum Button.
How to Graph Data
Getting Started for All Graphs.
File size: 517 kb
File url:
http://www.uml.edu/it/documents/Excel2003_QuickRef.pdf
VISUAL BASIC
Tools For Visual Basic
http://download.microsoft.com/download/7/b/2/7b284f3f-dcbc-4b21-ac48-66cb751d3969/Microsoft_Dynamics_SL_ToolsforVisualBasic.pdf
Visual Basic Guide
http://dl.extensis.com/downloads/PF/EN/P/Portfolio8_VisualBasic_Guide.pdf
Tutorial: Programming in Visual Basic 6.0
http://www.hsc.csu.edu.au/sdd/core/package/solution_package/tutorials/visualbasic_tutorial.pdf
Visual Basic .NET Tutorial
http://www.cs.iusb.edu/internship/papers/pmichelbrink/VisualStack.pdf
XML Support In Visual Basic 9
http://research.microsoft.com/~emeijer/Papers/PlanXDemo.pdf
Chapter 25
Compatibility With Visual BASIC
http://www.pitonyak.org/OOoBasicVBCompare.pdf
THE BOOK OF™ VISUAL BASIC 2005
.NET Insight for Classic VB Developers
http://nostarch.com/download/vb2005_ch11.pdf
Visual Basic - Arrays
http://www.hep.ucl.ac.uk/undergrad/1b40/vba/1B40_VBA_arrays.pdf
Integrating Visual Basic 6.0 and Surround SCM
http://downloads.seapine.com/pub/resources/scm/VisualBasic_SCMIntegration.pdf
Programming Acrobat JavaScript Using Visual Basic
http://www.adobe.com/devnet/acrobat/pdfs/VBJavaScript.pdf
VB.NET Quick Reference
http://www.digilife.be/quickreferences/QRC/VB.NET%20Quick%20Reference.pdf
Advancing Your Office 2007 Power: Using Visual Basic
http://www.informit.com/content/downloads/que/office/Office2007withVisualBasic.pdf
DIGITAL CAMERA
Digital Camera Identification from Sensor Pattern Noise
http://www.ws.binghamton.edu/fridrich/Research/double.pdf
Western European Consumer Digital Camera Forecast: 2007 - 2013
http://www.infotrends.com/public/EmailImages/storesnapshots/W.EuropeConsumerDigCameraForecast.pdf?ObjectID=93006&ViewMode=0&PreviewState=0
Technical camera digital capture vs. retouching
Save time, money and create a better product with classic tools and techniques!
http://www.phaseone.com/upload/techcam_rnp006.pdf
Storing and archiving digital images
http://www.rcseng.ac.uk/fds/it_guidance/docs/Storing%20And%20Archiving%20Digital%20Images%20Sept%2008.pdf
Digital Presenter (Document Camera)
http://technology.qatar.tamu.edu/_ITS/xhowto/Digital_presenter.pdf
Digital Camera
http://www.frc.utn.edu.ar/comvis07/material/DigitalCameras.pdf
Classroom Applications for the Digital Camera
http://k-12.pisd.edu/multimedia/peripherals/camera/mavicas-online/camideas.pdf
DVR4
Four Camera Digital Video Multiplex Recorder
http://www.tycoemea.com/english/pdf/datasht/cctv/PSS113A.pdf
Monster in a Box Transitioning to Digital Photography GWA 2005 Symposium Handout
Glossary of Some Digital Photography Terms
http://www.gardenwriters.org/Meetings/tapes/handouts/RichPomerantz.pdf
Digital Camera Systems
http://www.air-resource.com/pdfs/Digital%20Camera%20Monitoring%20brochure.pdf
QImaging Digital Camera Data Processing
http://www.qimaging.com/support/downloads/documents/DigCamDataProc.pdf
digital imaging IN THE EXOTIC ANIMAL PRACTICE
http://www.trustedpartner.com/docs/library/000087/digital.pdf
Eastern European Digital Camera Market Study:
The First in a Series of Emerging Market Studies Focusing on Digital Cameras and Digital Photo Printing
http://www.lyra.com/lh3m.nsf/96b9df1601689f6b852574be004fa2d8/$FILE/CII%20Digital%20Camera%20Market%20Study.pdf
FAQs for Penn Camera “Digital Imaging Editing” Class
https://www.penncamera.com/UserFiles/File/FAQs_for_classes/Class_FAQs_edit_8_16.pdf
Digital Camera System Solution
http://www.sharp-world.com/products/device/solution/pdf/camera.pdf
Tech mini Lesson: Digital Image and Application
http://www.ausd.k12.ca.us/dana/ghelmberger/tech_lessons/camera.PDF
3 ft USB Cable for Canon, Sony, & Hewlett Packard Digital Camera
http://www.startech.com/Share/ProductSpecs/PDF/USB2HABM3.pdf
Digital Camera Battery Standards Powering Portability
http://www.i3a.org/wp-content/uploads/2008/03/digitalcamerabatterystandards.pdf
Using Your Digital Camera
http://www.billings.k12.mt.us/tutorials/tips/camera_settings.pdf
BETTER DIGITAL PHOTOGRAPHS
http://www.haascnc.com/training/InfoMods/Better%20Digital%20Photographs.pdf
Digital Camera v. Dec 2004
Downloading Pictures from a Digital Camera
http://www.cesu.k12.vt.us/profdevelopment/basicskillsforteachers/digitalcamerahelpfulhints.pdf
Algebraic Reconstruction Techniques for Tomographic Particle Image Velocimetry
http://espace.library.uq.edu.au/eserv/UQ:120774/Atkinson2_afmc_16_07.pdf
Digital Camera Buying Guide RSS 1.0
http://www.softahead.com/pdf/60521/Digital_Camera_Buying_Guide_RSS.pdf
Digital Camera CANON
http://www.parshant.com/Canon.pdf
CMOS Digital Camera Controller and Frame Capture Device
http://www.xess.com/projects/Digital_Camera.pdf
DVR4-Net-PLUS
4 Camera Digital Video Recorder for Network & Web Monitoring with USB
http://www.mcmconnect.com/pdf/electronics/spec_sheet/82-11955.pdf
Digital Camera Web Resources
An Internet Hotlist on Digital Cameras
http://fdlrs.brevard.k12.fl.us/digicam/PDF_Handouts/DigiCam%20Resources%20Website.pdf
DIGITAL CAMERA CALIBRATION METHODS:
CONSIDERATIONS AND COMPARISONS
http://www.photogrammetry.ethz.ch/general/persons/fabio/Remondino_Fraser_ISPRSV_2006.pdf
Topic Map Solutions for Kodak Digital Camera Accessories
http://www.idealliance.org/papers/dx_xmle03/papers/02-03-02/02-03-02.pdf
Digital Still Camera Forensics
http://www.ssddfj.org/papers/SSDDFJ_V1_1_Cohen.pdf
Hidden Cap Camera with Digital VCR/ Monitor
Spy camera with remote control and LCD screen
http://news.softpedia.com/newsPDF/Hidden-Cap-Camera-With-Digital-VCR-Monitor-51265.pdf
EUROSDR NETWORK ON DIGITAL CAMERA CALIBRATION
http://www.cartesia.org/geodoc/isprs2004/comm6/papers/707.pdf
Retro-Look Digital Rangefinder Camera Merges Tradition with Innovation
http://www.epson.co.jp/e/newsroom/tech_news/tnl0405single.pdf
Digital Mapping Camera
Reducing your cost to go digital
http://www.aerial-survey-base.com/pdfs/Cameras_PDF/Intergraph/DMC-Latest_Tech_Features.pdf
BUYING A DIGITAL CAMERA
http://scscc.com/bkk/Digital%20Camera,%20Buying%20a.pdf
MySQL Reference Manual
File title:
MySQL Reference Manual
File content:
General Information About MySQL
What Is MySQL, About This Manual (Conventions Used in This Manual), History of MySQL, Books About MySQL, The Main Features of MySQL, How Stable Is MySQL?, Year 2000 Compliance, General SQL Information and Tutorials, Useful MySQL-related Links.
MySQL Mailing Lists
The MySQL Mailing Lists, Asking Questions or Reporting Bugs, How to Report Bugs or Problems, Guidelines for Answering Question on the Mailing List.
MySQL Licensing and Support
MySQL Licensing Policy, Copyrights Used by MySQL (Copyright Changes), Example Licensing Situations (Selling Products that use MySQL, ISP MySQL Services, Running a Web Server Using MySQL), MySQL Licensing and Support Costs (Payment information, Contact Information), Types of Commercial Support (Basic E-mail Support, Extended E-mail Support, Login Support, Extended Login Support).
Installing MySQL
How to Get MySQL, Operating Systems Supported by MySQL, Which MySQL Version to Use, How and When Updates Are Released, Installation Layouts, Installing a MySQL Binary Distribution (Linux RPM Notes, Building Client Programs, System-speci c Issues (Linux Notes for Binary Distributions, HP-UX Notes for Binary Distributions)), Installing a MySQL Source Distribution (Quick Installation Overview, Applying Patches, Typical configure Options), Installing from development source tree, Problems Compiling?, MIT-pthreads Notes, Perl Installation Comments (Installing Perl on UNIX, Installing ActiveState Perl on Windows, Installing the MySQL Perl Distribution on Windows, Problems Using the Perl DBI/DBD Interface), System-speci c Issues (Solaris Notes, Solaris 2.7/2.8 Notes, Solaris x86 Notes, SunOS 4 Notes), Linux Notes (All Linux Versions), (Linux-x86 Notes, RedHat Version 5.0 Notes, RedHat Version 5.1 notes, Linux-SPARC Notes, Linux-Alpha Notes, MkLinux Notes, Qube2 Linux Notes, Linux IA64 Notes), Alpha-DEC-UNIX Notes (Tru64), Alpha-DEC-OSF1 Notes, SGI-Irix Notes, FreeBSD Notes, NetBSD notes, OpenBSD 2.5 Notes, BSD/OS Notes (BSD/OS Version 2.x Notes, BSD/OS Version 3.x Notes, BSD/OS Version 4.x Notes), SCO Notes, SCO Unixware Version 7.0 Notes, IBM-AIX notes, HP-UX Version 10.20 Notes, HP-UX Version 11.x Notes, Mac OS X Notes, BeOS Notes), Windows Notes (Installing MySQL on Windows, Starting MySQL on Windows 95 or Windows 98, Starting MySQL on NT or Windows 2000, Running MySQL on Windows, Connecting to a Remote MySQL from Windows with SSH, Splitting Data Across Di erent Disks Under Windows, Compiling MySQL Clients on Windows, Windows and BDB Tables, MySQL-Windows Compared to UNIX MySQL), OS/2 Notes, MySQL Binaries, Post-installation Setup and Testing (Problems Running mysql_install_db, Problems Starting the MySQL Server, Starting and Stopping MySQL Automatically, Command-line Options, Option Files), Is There Anything Special to Do when Upgrading/Downgrading MySQL? (Upgrading From Version 3.22 to Version 3.23, Upgrading from Version 3.21 to Version 3.22, Upgrading from Version 3.20 to Version 3.21, Upgrading to Another Architecture).
How Standards-compatible Is MySQL?
MySQL Extensions to ANSI SQL92, Running MySQL in ANSI Mode, MySQL Di erences Compared to ANSI SQL92, Functionality Missing from MySQL (Sub-selects, SELECT INTO TABLE, Transactions, Stored Procedures and Triggers, Foreign Keys (Reasons NOT to Use Foreign Keys constraints), Views, `–’ as the Start of a Comment), What Standards Does MySQL Follow?, How to Cope Without COMMIT/ROLLBACK.
The MySQL Access Privilege System
General Security, How to Make MySQL Secure Against Crackers, What the Privilege System Does, MySQL User Names and Passwords, Connecting to the MySQL Server, Keeping Your Password Secure, Privileges Provided by MySQL, How the Privilege System Works, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification, When Privilege Changes Take Effect, Setting Up the Initial MySQL Privileges, Adding New User Privileges to MySQL, Setting Up Passwords, Causes of Access denied Errors.
MySQL Language Reference
Literals: How to Write Strings and Numbers (Strings, Numbers, Hexadecimal Values, NULL Values, Database, Table, Index, Column, and Alias Names (Case Sensitivity in Names), User Variables, Column Types (Column Type Storage Requirements, Numeric Types, Date and Time Types (Y2K Issues and Date Types, The DATETIME, DATE, and TIMESTAMP Types, The TIME Type, The YEAR Type), String Types (The CHAR and VARCHAR Types, The BLOB and TEXT Types, The ENUM Type, The SET Type), Choosing the Right Type for a Column, Column Indexes, Multiple-column Indexes, Using Column Types from Other Database Engines), Functions for Use in SELECT and WHERE Clauses (Grouping Functions, Normal Arithmetic Operations, Bit Functions, Logical Operations, Comparison Operators, String Comparison Functions, Cast Operators, Control Flow Functions, Mathematical Functions, String Functions, Date and Time Functions, Miscellaneous Functions, Functions for Use with GROUP BY Clauses), CREATE DATABASE Syntax, DROP DATABASE Syntax, CREATE TABLE Syntax (Silent Column Specification Changes), ALTER TABLE Syntax, RENAME TABLE Syntax, DROP TABLE Syntax, OPTIMIZE TABLE Syntax, CHECK TABLE Syntax, BACKUP TABLE syntax, RESTORE TABLE syntax, ANALYZE TABLE syntax, REPAIR TABLE syntax, DELETE syntax, TRUNCATE syntax, SELECT syntax, JOIN syntax, INSERT syntax, REPLACE syntax, LOAD DATA INFILE syntax, UPDATE syntax, USE syntax, FLUSH syntax (clearing caches), KILL syntax, SHOW syntax (Get information about tables, columns,…) (SHOW information about database, tables, columns and index, SHOW status information about tables, SHOW status information, SHOW VARIABLES, SHOW information about connected threads (processes), SHOW GRANTS (privileges) for a user, SHOW CREATE TABLE), EXPLAIN syntax (Get information about a SELECT), DESCRIBE syntax (Get information about columns), BEGIN/COMMIT/ROLLBACK syntax, LOCK TABLES/UNLOCK TABLES syntax, SET syntax, GRANT and REVOKE syntax, CREATE INDEX syntax, DROP INDEX syntax, Comment syntax, CREATE FUNCTION/DROP FUNCTION syntax, Is MySQL picky about reserved words?.
MySQL table types
MyISAM tables (Space needed for keys, MyISAM table formats (Static (Fixed-length) table characteristics, Dynamic table characteristics, Compressed table characteristics)), MERGE tables, ISAM tables, HEAP tables, BDB or Berkeley db tables.
MySQL Tutorial
Connecting to and disconnecting from the server, Entering queries, Examples of common queries (The maximum value for a column, The row holding the maximum of a certain column, Maximum of column per group, The rows holding the group-wise maximum of a certain field, Using user variables, Using foreign keys), Searching on two keys, Creating and using a database (Creating and selecting a database, Creating a table, Loading data into a table, Retrieving information from a table (Selecting all data, Selecting particular rows, Selecting particular columns, Sorting rows, Date calculations, Working with NULL values, Pattern matching, Counting rows), Using more than one table), Getting information about databases and tables, Using mysql in batch mode, Queries from twin project (Find all non-distributed twins, Show a table on twin pair status).
MySQL server functions
What languages are supported by MySQL? (The character set used for data and sorting, Adding a new character set, String collating support, Multi-byte character support), How big MySQL tables can be.
Replication in MySQL
Introduction, Replication Implementation Overview, HOWTO, Replication Features, Replication Options in my.cnf, SQL commands related to replication, Replication FAQ.
Getting maximum performance from MySQL
Optimization overview, System/Compile time and startup parameter tuning (How compiling and linking a ects the speed of MySQL, Disk issues (Using symbolic links for databases and tables), Tuning server parameters, How MySQL opens and closes tables, Drawbacks of creating large numbers of tables in the same database, Why so many open tables?, How MySQL uses memory, How MySQL locks tables, Table locking issues), Get your data as small as possible, How MySQL uses indexes, Speed of queries that access or update data (Estimating query performance, Speed of SELECT queries, How MySQL optimizes WHERE clauses, How MySQL optimizes DISTINCT, How MySQL optimizes LEFT JOIN and RIGHT JOIN, How MySQL optimizes LIMIT, Speed of INSERT queries, Speed of UPDATE queries, Speed of DELETE queries), Other optimization tips, Using your own benchmarks, Design choices, MySQL design limitations/tradeoffs, Portability, What have we used MySQL for?.
The MySQL benchmark suite
MySQL Utilites
Overview of the different MySQL programs, safe mysqld, the wrapper around mysqld, The command line tool, Administering a MySQL server, Dumping the structure and data from MySQL databases and tables, Importing data from text files, Showing databases, tables and columns, The MySQL compressed read-only table generator.
Maintaining a MySQL installation
Using myisamchk for table maintenance and crash recovery (myisamchk invocation syntax (General options for myisamchk, Check options for myisamchk, Repair options for myisamchk, Other options for myisamchk), myisamchk memory usage), Setting up a table maintenance regimen, Getting information about a table, Using myisamchk for crash recovery (How to check tables for errors, How to repair tables, Table optimization), Log file maintenance.
Adding new functions to MySQL
Adding a new user-definable function (UDF calling sequences, Argument processing, Return values and error handling, Compiling and installing user-de nable functions), Adding a new native function.
Adding new procedures to MySQL
Procedure analyse, Writing a procedure.
MySQL ODBC Support
Operating systems supported by MyODBC, How to fill in the various elds in the ODBC administrator program, How to report problems with MyODBC, Programs known to work with MyODBC, How to get the value of an AUTO_INCREMENT column in ODBC, Reporting problems with MyODBC.
Using MySQL with some common programs
Using MySQL with Apache
Problems and common errors
How to determine what is causing problems, What to do if MySQL keeps crashing, Problems when linking with the MySQL client library, Some common errors when using MySQL (MySQL server has gone away error, Can’t connect to [local] MySQL server error, Host ‘…’ is blocked error, Too many connections error, Out of memory error, Packet too large error, Communication errors / Aborted connection, The table is full error, Can’t create/write to file error, Commands out of sync error in client, Ignoring user error, Table ‘xxx’ doesn’t exist error), How MySQL handles a full disk, How to run SQL commands from a text file, Where MySQL stores temporary files, How to protect `/tmp/mysql.sock’ from being deleted, Access denied error, How to run MySQL as a normal user, How to reset a forgotten password, Problems with file permissions, File not found, Problems using DATE columns, Timezone problems, Case sensitivity in searches, Problems with NULL values, Problems with alias, Deleting rows from related tables, Solving problems with no matching rows, Problems with ALTER TABLE, How to change the order of columns in a table.
Solving some common problems with MySQL
Database replication with update log, Database backups, The update log, The binary log, The slow query log, Running multiple MySQL servers on the same machine.
MySQL client tools and APIs
MySQL C API, C API datatypes, C API function overview, C API function descriptions (mysql_affected_rows(), mysql_close(), mysql_connect(), mysql_change_user(), mysql_character_set_name(), mysql_create_db(), mysql_data_seek(), mysql_debug(), mysql_drop_db(), mysql_dump_debug_info(), mysql_eof(), mysql_errno(), mysql_error(), mysql_escape_string(), mysql_fetch_field(), mysql_fetch_fields(), mysql_fetch_field_direct(), mysql_fetch_lengths(), mysql_fetch_row(), mysql_field_count(), mysql_field_seek(), mysql_field_tell(), mysql_free_result(), mysql_get_client_info(), mysql_get_host_info(), mysql_get_proto_info(), mysql_get_server_info(), mysql_info(), mysql_init(), mysql_insert_id(), mysql_kill(), mysql_list_dbs(), mysql_list_fields(), mysql_list_processes(), mysql_list_tables(), mysql_num_fields(), mysql_num_rows(), mysql_options(), mysql_ping(), mysql_query(), mysql_real_connect(), mysql_real_escape_string(), mysql_real_query(), mysql_reload(), mysql_row_seek(), mysql_row_tell(), mysql_select_db(), mysql_shutdown(), mysql_stat(), mysql_store_result(), mysql_thread_id(), mysql_use_result(), Why is it that after mysql_query() returns success, mysql_store_result() sometimes returns NULL?, What results can I get from a query?, How can I get the unique ID for the last inserted row?, Problems linking with the C API, How to make a thread-safe client), MySQL Perl API (DBI with DBD::mysql, The DBI interface, More DBI/DBD information), MySQL Eiffel wrapper, MySQL Java connectivity (JDBC), MySQL PHP API (Common problems with MySQL and PHP), MySQL C++ APIs, MySQL Python APIs, MySQL Tcl APIs.
How MySQL compares to other databases
How MySQL compares to mSQL (How to convert mSQL tools for MySQL, How mSQL and MySQL client/server communications protocols differ, How mSQL 2.0 SQL syntax differs from MySQL),How MySQL compares to PostgreSQL.
MySQL internals
MySQL threads, MySQL full-text search.
Appendix A Environment variables
Appendix B Some MySQL users
General news sites, Some Web search engines, Some Information search engines concentrated on some area, Online magazines, Web sites that use MySQL as a backend, Some Domain/Internet/Web and related services, Web sites that use PHP and MySQL, Some MySQL consultants, Programming, Uncategorized pages.
Appendix C Contributed programs
APIs, Clients, Web tools, Performance Benchmarking tools, Authentication tools, Converters, Using MySQL with other products, Useful tools, RPMs for common tools (Most are for RedHat 6.1), Useful functions, Windows programs, Uncategorized.
Appendix D Contributors to MySQL
Appendix E MySQL change history
Changes in release 3.23.x (Recommended; beta) (Changes in release 3.23.28, Changes in release 3.23.27, Changes in release 3.23.26, Changes in release 3.23.25, Changes in release 3.23.24, Changes in release 3.23.23, Changes in release 3.23.22, Changes in release 3.23.21, Changes in release 3.23.20, Changes in release 3.23.19, Changes in release 3.23.18, Changes in release 3.23.17, Changes in release 3.23.16, Changes in release 3.23.15, Changes in release 3.23.14, Changes in release 3.23.13, Changes in release 3.23.12, Changes in release 3.23.11, Changes in release 3.23.10, Changes in release 3.23.9, Changes in release 3.23.8, Changes in release 3.23.7, Changes in release 3.23.6, Changes in release 3.23.5, Changes in release 3.23.4, Changes in release 3.23.3, Changes in release 3.23.2, Changes in release 3.23.1, Changes in release 3.23.0), Changes in release 3.22.x (Changes in release 3.22.35, Changes in release 3.22.34, Changes in release 3.22.33, Changes in release 3.22.32, Changes in release 3.22.31, Changes in release 3.22.30, Changes in release 3.22.29, Changes in release 3.22.28, Changes in release 3.22.27, Changes in release 3.22.26, Changes in release 3.22.25, Changes in release 3.22.24, Changes in release 3.22.23, Changes in release 3.22.22, Changes in release 3.22.21, Changes in release 3.22.20, Changes in release 3.22.19, Changes in release 3.22.18, Changes in release 3.22.17, Changes in release 3.22.16, Changes in release 3.22.15, Changes in release 3.22.14, Changes in release 3.22.13, Changes in release 3.22.12, Changes in release 3.22.11, Changes in release 3.22.10, Changes in release 3.22.9, Changes in release 3.22.8, Changes in release 3.22.7, Changes in release 3.22.6, Changes in release 3.22.5, Changes in release 3.22.4, Changes in release 3.22.3, Changes in release 3.22.2, Changes in release 3.22.1, Changes in release 3.22.0), Changes in release 3.21.x (Changes in release 3.21.33, Changes in release 3.21.32, Changes in release 3.21.31, Changes in release 3.21.30, Changes in release 3.21.29, Changes in release 3.21.28, Changes in release 3.21.27, Changes in release 3.21.26, Changes in release 3.21.25, Changes in release 3.21.24, Changes in release 3.21.23, Changes in release 3.21.22, Changes in release 3.21.21a, Changes in release 3.21.21, Changes in release 3.21.20, Changes in release 3.21.19, Changes in release 3.21.18, Changes in release 3.21.17, Changes in release 3.21.16, Changes in release 3.21.15, Changes in release 3.21.14b, Changes in release 3.21.14a, Changes in release 3.21.13, Changes in release 3.21.12, Changes in release 3.21.11, Changes in release 3.21.10, Changes in release 3.21.9, Changes in release 3.21.8, Changes in release 3.21.7, Changes in release 3.21.6, Changes in release 3.21.5, Changes in release 3.21.4, Changes in release 3.21.3, Changes in release 3.21.2, Changes in release 3.21.0), Changes in release 3.20.x (Changes in release 3.20.18, Changes in release 3.20.17, Changes in release 3.20.16, Changes in release 3.20.15, Changes in release 3.20.14, Changes in release 3.20.13, Changes in release 3.20.11, Changes in release 3.20.10, Changes in release 3.20.9, Changes in release 3.20.8, Changes in release 3.20.7, Changes in release 3.20.6, Changes in release 3.20.3, Changes in release 3.20.0), Changes in release 3.19.x (Changes in release 3.19.5, Changes in release 3.19.4, Changes in release 3.19.3).
Appendix F Known errors and design deficiencies in MySQL
Appendix G MySQL and the future (The TODO)
Things that should be in 4.0, Things that must done in the real near future, Things that have to be done sometime, Some things we don’t have any plans to do.
Appendix H Comments on porting to other systems
Debugging a MySQL server, Debugging a MySQL client, The DBUG package, Locking methods, Comments about RTS threads, Differences between different thread packages.
Appendix I Description of MySQL regular expression syntax
Appendix J What is Unireg?
Appendix K GNU General Public License
Appendix L GNU Library General Public License
SQL command, type and function index
Concept Index
File type: PDF
File size: 2,363 KB
File url:
http://zid-luxinst.uibk.ac.at/mysql/manual.pdf
INTERMEDIATE EXCEL
File title:
INTERMEDIATE EXCEL
File content:
Introduction, Lists, PivotTables (Elements of a PivotTable, Setting up a PivotTable, Begin building your pivot table, CompletedPivotTable), Data Forms (Using a Data Form, Advanced Analytical Tools), Scenario Manager (Using the Scenario Manager, To view a Scenario), Goal Seek (Using Goal Seek), Complex Analysis: The Solver (Elements of the Solver, Using the Solver, To Run the Solver, To Generate a Report/Printout of the Solution), Macros (Running the Macro/Macro Options, Assigning a macro to a button, Assigning a macro to a short cut key).
File type: PDF
File size: 224 kb
File url:
http://www.lib.umich.edu/hsl/resources/guides/IntermedExcel.pdf
PHP Tutorial - Learn PHP
File title:
PHP Tutorial - Learn PHP
File content:
PHP - What is it?, PHP - What’s it do?, What You Should Know, Tutorial Overview, PHP - Syntax, How to Save Your PHP Pages, Example Simple HTML & PHP Page, The Semicolon!, White Space, PHP - Variables, A Quick Variable Example, PHP Variable Naming Conventions, PHP - Echo, Outputting a String, Careful When Echoing Quotes!, Echoing Variables, Echoing Variables and Text Strings, PHP - Strings, PHP - String Creation, PHP - String Creation Single Quotes, PHP - String Creation Double-Quotes, PHP - String Creation Heredoc, PHP - Operators, Assignment Operators, Arithmetic Operators, Comparison Operators, Combination Arithmetic & Assignment Operators, Pre/Post-Increment & Pre/Post-Decrement, Using Comments in PHP, PHP Comment Syntax: Single Line Comment, PHP Comment Syntax: Multiple Line Comment, Good Commenting Practices, The Include Function, An Include Example, What do Visitors See?, Include Recap, PHP Require Function, Require vs Include, The If Statement, The PHP If Statement, If Statement Example, A False If Statement, If/Else Conditional Statment, If/Else an Example, Execute Else Code with False, PHP - Elseif, PHP - Elseif What is it?, PHP - Using Elseif with If…Else, PHP Switch Statement, PHP Switch Statement: Speedy Checking, PHP Switch Statement Example, PHP Switch Statement: Default Case, Using PHP With HTML Forms, Creating the HTML Form, PHP Form Processor, PHP & HTML Form Review, PHP - Functions, Creating Your First PHP Function, Using Your PHP Function, PHP Functions - Parameters, PHP Functions - Returning Values, PHP Functions - Practice Makes Perfect, PHP - Arrays, PHP - A Numerically Indexed Array, PHP - Associative Arrays, PHP - While Loop, Simple While Loop Example, A Real While Loop Example, PHP - For Loop, For Loop Example, PHP For Each Loop, PHP For Each: Example, Foreach Syntax: $something as $key => $value, PHP - Do While Loop, PHP - While Loop and Do While Loop Contrast, PHP - POST & GET, POST - Review, PHP - GET, Security Precautions, PHP htmlentities Function, PHP - Converting HTML into Entities, When Would You Use htmlentities?, PHP - Files, PHP - Files: Be Careful, PHP - Files: Overview, PHP - File Create, PHP - Creating Confusion, PHP - How to Create a File, PHP - Permissions, PHP - File Open, PHP - Different Ways to Open a File, PHP - Explanation of Different Types of fopen, PHP - File Open: Advanced, PHP - File Open: Cookie Cutter, PHP - File Open: Summary, PHP - File Write, PHP - File Open: Write, PHP - File Write: fwrite Function, PHP - File Write: Overwriting, PHP - File Read, PHP - File Open: Read, PHP - File Read: fread Function, PHP - File Read: gets Function, PHP - File Delete, PHP - File Unlink, PHP - Unlink Function, PHP - Unlink: Safety First!, PHP - File Append, PHP - File Open: Append, PHP - File Write: Appending Data, PHP - Append: Why Use It?, PHP - File Truncate, PHP - File Open: Truncate, PHP - Truncate: Why Use It?, PHP - File Upload, PHP - File Upload: HTML Form, PHP - File Upload: What’s the PHP Going to Do?, PHP - File Upload: uploader.php, PHP - File Upload: move_uploaded_file Function, PHP - File Upload: Safe Practices!, PHP - String Position - strpos, Searching a String with strpos, Finding All Occurrences in a String with Offset, PHP - String Capitalization Functions, Converting a String to Upper Case - strtoupper, Converting a String to Lower Case - strtolower, Capitalizing the First Letter - ucwords, PHP - String Explode, The explode Function, explode Function - Setting a Limit, PHP - Array implode, PHP implode - Repairing the Damage, PHP Date - Robust Dates and Times, PHP Date - The Timestamp, PHP Date - What Time Is It?, PHP Date - Supplying a Timestamp, PHP Date - Reference, PHP Sessions - Why Use Them?, PHP Sessions - Overview, Starting a PHP Session, Storing a Session Variable, PHP Sessions: Using PHP’s isset Function, Cleaning and Destroying your Session, PHP HTML Form Example, Building the HTML Form, Input Fields, Radios and Checkboxes, Textareas, Drop Down Lists & Selection Lists, Submission Button, Retrieving Form Data - Setting up Variables, $PHP_SELF; - Submission, Page Display, Echo Back the Results.
File type: PDF
File size: 1,094 kb
File url:
http://home.comcast.net/~davnlor/davnlor008/php/php_tizag_tutorial.pdf
Microsoft Excel Hints and Tips
File title:
Microsoft Excel Hints and Tips
File content:
Introduction, Starting Microsoft Excel and Opening Files, Making Good Use of the Keyboard, Data Entry and Cell Formatting, Moving Around and Selecting Cells, Making Good Use of the Mouse, Screen Layout, Using Colours and Adding Comments, Cell Referencing, Charts, Printing Tips, Other Tips.
File type: PDF
File size: 106 kb
File url:
http://www.reading.ac.uk/web/FILES/www_File_Library/Microsoft_Excel_Hints_and_Tips.pdf
Creating Electronic Portfolios using Microsoft Word and Excel
File title:
Step-by-Step
Creating Electronic Portfolios using Microsoft Word and Excel
File content:
What to do? Here is the process we will cover:
Collect the documents in electronic form and store in a single folder, Create a list of the artifacts you have collected using an Excel Spreadsheet, Create the Reflective Portfolio in Word.
Stage 2 - Collecting the Artifacts - The Working Portfolio
Hints on collecting your Artifacts:, Create a list of your Artifacts in Excel.
Stage 3 - Selection, Reflection & Direction - The Reflective Portfolio
Set up the portfolio demonstrating your chosen standards, Copy the Performance Indicators into document, Create Navigation Headings with the Outline View, Using the Document Map, Using the Style Menu, Change the Paragraph Style to Create Page Breaks, Write Reflections on Each Standard, Create a Table of Contents.
Stage 4 - Add hypertext links - The Connected Portfolio
Scanning directly into a Microsoft Word 2001 Document.
File type: PDF
File size: 940 kb
File url:
http://ali.apple.com/ali_media/Users/147/files/others/stepbystep_WordExcelEPs.pdf
Microsoft Excel 2007
File title:
Microsoft Excel 2007
File content:
Things to Note – Data Types and Formulas
Entering Data, Data Types, Formulas.
MS EXCEL 2007 - New Interface
Arrangement of Tools in Excel 2007, MS OFFICE BUTTON, QUICK ACCESS TOOLBAR, RIBBON TABS (Tool Groups, Dialog Box Launch Arrow).
Getting Started
Start a new Workbook, Open an existing Workbook, Open a file from a different version or format, IMPORTANT NOTES: Saving Documents in Excel 2007, Save the current Workbook OR Save the Workbook as a different name - version - or format.
Formatting Data
Insert Data into a cell
Home Tab - Font, Alignment, Number & Cell Groups
Insert more Cells into a Sheet, Change the Type of Data within a Cell or cells (Ex: increase decimal places), Change the Font of the Data in a Cell, Change the Alignment of the Data in a Cell, Format Cells Dialog Box - (has not changed from Word 2000, 2003), Format the Borders of Cells, Format the Column Width or Row Height of Cells, Move a cell(s), Merge Cells Combine several Cells into 1, Automatically fill Data Cells, Sorting Data.
Formulas - The Formula Bar & Functions
To begin a Formula:, Functions & Operators for Formulas, AutoSum Automatically Sum your Data.
Creating and Formatting Charts
Inserting a Chart from Data, Chart Tools Tab: (Design Tab, Layout Tab, Format Tab), Creating a Chart Step 1 Choose / Change a Chart Design.
Creating a Chart - Steps 2 - 4
Creating a Chart Step 2 Data Range, Creating a Chart Step 3 Chart Location, Creating a Chart Step 4 Labels (Chart Titles, Axis Titles, Gridlines, Legend Position, Background), Stretching the Chart.
Formatting Elements of a Chart
Formatting Axes Change the Pattern, Scale, Font, Number Type, and Angle of the X and Y Axes. Of these, the most important is the Scale of the Axes, Formatting a Series of Data Change the appearance of a Data Series Line and its Markers, Display and Format Data Labels Show the Data Values Data Labels The X or Y values can be displayed next to each Data Marker in a Series Line.
Charts - Error Bars and Trendlines
Adding Error Bars to a Series of Data Error Bar A small line extending from each Data Marker that represents the potential error of your data, Creating Trend Lines and their Equations Trendline The line that best represents the average of your data points. Excel can provide an equation for the Trendline.
Printing
Set the Print Area of a spreadsheet, Preview the print-out.
File type: PDF
File url:
http://www.sfg.uvic.ca/assets/pdfs/excel-handout07.pdf
File size: 1411 kb
Importing Data from Microsoft® Excel into LISTSERV® Maestro
File title:
Importing Data from Microsoft® Excel into LISTSERV® Maestro
File content:
Introduction, Setting Up the ODBC Driver Plugin in LISTSERV Maestro, Setting Up the ODBC Driver for Excel in LISTSERV Maestro, Setting Up the ODBC Data Source, Accessing the ODBC Data Source from LISTSERV Maestro, SQL Statements and Excel (Using Named Ranges, Naming Data Ranges in Excel, Using Worksheet Names, Using Cell Ranges), Joining Data from Multiple Named Ranges or Worksheets, Conclusion, References.
File type: PDF
File size: 827 kb
File url:
http://www.lsoft.com/resources/wp-odbc-excel.pdf
Getting Started with Microsoft Excel
File title:
Getting Started with Microsoft Excel
File content:
Starting Excel
Exploring the Excel Interface
Components of the Excel Window, Standard Toolbar, Formatting toolbar, Formula bar, Name box, Row and column headings, Active cell, Fill handle, Worksheet tabs.
Working with Excel documents
Opening and Closing Documents, Saving a Document, Difference between Save As and Save, Creating a New Workbook, Managing Multiple Workbooks.
Entering and Editing Data
Entering Data, Editing Data, Moving the Active Cell, Go To Command, Clearing Cell Contents, Undoing Mistakes, Copying and Moving Data.
Formatting Data
Changing formats using the toolbar, Font tab in Format Cells, Alignment, Format Alignment command, Changing Numeric Formatting, Placing borders around cells, Shading cells, Changing column width with the Format menu, Changing column widths by dragging column borders.
Formulas and Functions
Formulas, Copying Formulas, SUM( ) function, AutoSum button, Using the Insert Function Button, Adjusting Page Setup settings, To change page margins, To change page orientation, To change the header or footer.
Printing
Print preview, Sending your workbook to the printer.
Getting Help
The Contents Tab, The Answer Wizard Tab, The Index Tab.
File size: 280 kb
File type: PDF
File url:
http://www.dartmouth.edu/~rwit/files/database/Excel.pdf
The Misuse of RC4 in Microsoft Word and Excel
File title:
The Misuse of RC4 in Microsoft Word and Excel
File Content:
Introduction
Introduction to the Security of Microsoft Office
The Misuse of RC4 in Microsoft Word
Evidence that RC4 is misused in Microsoft Word, The attack on the Microsoft Word.
The Misuse of RC4 in Microsoft Excel
Modifying the Microsoft Excel document, Evidence that RC4 is misused in Microsoft Excel.
The Countermeasures
Conclusion
References
Encryption in Microsoft Word 2002
File type: PDF
File size: 143 KB
File url:
http://eprint.iacr.org/2005/007.pdf
Microsoft Excel - A Beginner’s Guide to Working With Spreadsheet Applications
File title:
Microsoft Excel
A Beginner’s Guide to Working With Spreadsheet Applications
File content:
What is Microsoft Excel? How to Create an Excel Spreadsheet; Title bar, Menu bar, Toolbars, and Status bar in Word; How to Save an Excel Spreadsheet; Undo is your Friend! What is a Column? What is a Row? What is a Cell? How do I edit the contents of a Cell? How do I Sum a Column of data? What is a Formula? How do I create a Formula? How do I find out how to do more in Excel? Additional Resources.
File format : PDF
File size: 104 kb
File url:
http://main.ascension.lib.la.us/uploads/File/Classes/TutorialIntrotoExcel.pdf
Problems With Using Microsoft Excel for Statistics
File title:
Problems With Using Microsoft Excel for Statistics
File content:
Example: Excel Graphics With False Third Dimension (taken from JSE!), Example: Pyramid Charts, Example: Excel Default Scatterplot, Example: Excel Default Histogram, Example: Excel Histogram (stretched vertically to read labels), Example: Excel 2000 Help Screen for the Two-sample T-Test, Example: Excel 2000 Confidence Function, Example: Excel 2000 STDEV Function.
File format: PDF
File size: 413 kb
File url:
http://www.cs.uiowa.edu/~jcryer/JSMTalk2001.pdf
OpenOffice.org’s Documentation of the Microsoft Excel File Format
File title:
OpenOffice.org’s Documentation of the Microsoft Excel File Format
File content:
Introduction
License Notices, Abstract, Byte Order.
Document Structure
Document Types, The Binary Interchange File Format, File Structure, BIFF Record Structure, Common Record Substructures.
Formulas
Common Formula Structure, Token Classes, Cell Addresses in Tokens, Token Overview, Unary Operator Tokens, Binary Operator Tokens, Function Operator Tokens, Constant Operand Tokens, Operand Tokens, Control Tokens, Built-In Sheet Functions.
Worksheet/Workbook Stream
Worksheet/Workbook Stream, Record Order in Streams and Substreams, Calculation Settings Block, Page Settings Block, Sheet View Settings Block, Cell Formatting, Cell Table and Row Blocks, Array Formulas and Shared Formulas, Multiple Operation Tables, Internal and External References, Shared String Table (BIFF8), Conditional Formatting Table (BIFF8), Hyperlink Table (BIFF8), Data Validity Table (BIFF8), AutoFilter, Advanced Filter, Scenarios, Web Queries (BIFF8), Worksheet/Workbook Protection, File Protection.
Worksheet/Workbook Records
Overview, Ordered by Record Identifier, Overview, Ordered by Record Names, Overview, Ordered by BIFF Versions, ARRAY, BACKUP, BITMAP, BLANK, BOF – Beginning of File, BOOKBOOL, BOOLERR, BOTTOMMARGIN, BUILTINFMTCOUNT, CALCCOUNT, CALCMODE, CFHEADER, CFRULE – Conditional Formatting Rule, CODEPAGE, COLINFO, COLUMNDEFAULT, COLWIDTH, CONTINUE, COUNTRY, CRN, DATATABLE – Multiple Operation Table, DATATABLE2 – Multiple Operation Table, DATAVALIDATION, DATAVALIDATIONS, DATEMODE, DBCELL, DCONREF – Data Consolidation Reference, DEFAULTROWHEIGHT, DEFCOLWIDTH, DEFINEDNAME, DELTA, DIMENSION, DSF – Double Stream File, EOF – End of File, EXTERNALBOOK – External Workbook, EXTERNALNAME, EXTERNCOUNT, EXTERNSHEET, EXTSST – Extended SST, FILEPASS, FILESHARING, FONT, FONT2, FONTCOLOR, FOOTER, FORMAT, FORMULA, GCW – Global Column Width, GRIDSET, GUTS, HCENTER, HEADER, HIDEOBJ, HORIZONTALPAGEBREAKS, HYPERLINK, INDEX, INTEGER, ITERATION, IXFE – Index to XF, LABEL, LABELRANGES, LABELSST, LEFTMARGIN, MERGEDCELLS, MULBLANK – Multiple BLANK, MULRK – Multiple RK, NOTE, NUMBER, OBJECTPROTECT, PAGESETUP, PALETTE, PANE, PASSWORD, PHONETICPR, PLS, PRECISION, PRINTGRIDLINES, PRINTHEADERS, PROTECT, QUICKTIP, RANGEPROTECTION, REFMODE, RIGHTMARGIN, RK, ROW, RSTRING, SAVERECALC, SCENPROTECT, SCL, SELECTION, SHAREDFMLA – Shared Formula, SHEET, SHEETLAYOUT, SHEETPR, SHEETPROTECTION, SORT, SST – Shared String Table, STANDARDWIDTH, STRING, STYLE, TOPMARGIN, UNCALCED, USESELFS, VCENTER, VERTICALPAGEBREAKS, WINDOW1, WINDOW2, WINDOWPROTECT, WRITEACCESS, WRITEPROT, XCT – CRN Count, XF – Extended Format.
Drawing Objects
Charts
Document Integration, General Chart Structure, Common Record Blocks, Record Overview, Ordered by Identifier, Record Overview, Ordered by Name, CHAREAFORMAT, CHAXISLINE, CHBEGIN – Begin of Block, CHEND – End of Block, CHFRAME, CHLINEFORMAT, CHSOURCELINK, CHSTRING.
PivotTables
Change Tracking
Workspace Documents
Workspace Stream, Overview, Ordered by Record Identifier, INDEX, SHEETHDR, SHEETSOFFSET.
File type: PDF
File url:
http://sc.openoffice.org/excelfileformat.pdf
File size: 1.14 mb
Tutorial – Microsoft Office Excel 2003
File title:
Tutorial – Microsoft Office Excel 2003
File content:
Introduction, Opening Excel, Standard Toolbar (New, Open, Save, Permission, Print, Print Preview, Research, Copy, Paste, Undo, Insert Hyperlink, AutoSum, Sort Ascending, Chart Wizard, Microsoft Excel Help, More Options), Formatting Toolbar (FOnt, SIze, Bold, Italics, Underline, Align Left, Center, Align Right, Merge & Center, Currency Style, Percent Style, Decrease Indent, Border, Fill Color, Font Color), Navigating the Spreadsheet, A Simple Spreadsheet, Simple Formulas, Insert Rows & Columns, Sorting, Cell Formatting, Chart Wizard.
File type: PDF
File url:
http://getit.rutgers.edu/tutorials/excel/media/excel.pdf
File size:
246 kb
MySQL®
File title:
MySQL®
File Content:
How cPanel Distributes and Installs MySQL on Linux, How cPanel Distributes and Installs MySQL on FreeBSD, What Version of MySQL does cPanel currently install?, MySQL Version File Example, Choosing the Version of MySQL that is Right for You, Manually Upgrading MySQL, Manually Upgrading MySQL: How it is Actually Done, The cPanel Naming Conventions and how they Work with MySQL, How cPanel and MySQL Interact, Possible Errors with cpwrap, Basic MySQL Troubleshooting, Scripts Included with cPanel to Help Troubleshoot MySQL, MySQL and Perl Scripts, Additional MySQL Troubleshooting.
File url:
http://www.cpanel.net/docs/seminar/MySQL.pdf
File type: PDF
File size: 148 kb
How to setup and secure Snort, MySQL and Acid on FreeBSD 4.7 Release
File title:
How to setup and secure Snort, MySQL and Acid on FreeBSD 4.7 Release
File content:
Purpose of document, Assumptions, Setting up the viewing station, File system layout, Other installation details, On the initial boot, Updating your ports collection, X-windows, Installing and setting up PGP, Patching BSD, Verifying the PGP signature of the patch, Post-installation cleanup, Installing the necessary ports, Adding a user for Snort, Editing the necessary files, For Snort, For Apache, For ACID, Setting up intial MySQL functionality, Setting up MySQL to accept data from Snort, Setting up Stunnel, Mozilla, Preparing your firewall boot options, Kernel configuration, Setting up rules for IPFW, Setting up the sensor(s), File system layout, Other installation details, On the initial boot, Updating your ports collection, Patching BSD, Post-installation cleanup, Installing the necessary ports, Adding a user for Snort, Editing the necessary files, For Snort, Snort startup script, Setting up Stunnel, Preparing your firewall boot options, Kernel configuration, Setting up rules for IPFW, Miscellaneous, Things that the administrator should do on his/her own, To-do list, Example motd, Lists to subscribe to, Resources.
File url:
http://www.snort.org/docs/FreeBSD47RELEASE-Snort-MySQLVer1-3.pdf
File type: PDf
File size: 65 kb
Where can I find article about MySQL GUI Tools Manual ?
File title:
MySQL GUI Tools Manual
File type: PDF
File url:
http://downloads.mysql.com/docs/guibook-en.pdf
File size: 1.89 mb
File content:
MySQL Enterprise
Installation
Introduction, Installing Under Windows (Using the Windows Installer, Installing From the ZIP File), Installing Under Linux (Installing the Generic Tarball, RPM Installation), Installing Under Mac OS X.
Removing MySQL GUI Tools
Uninstall – Windows, Uninstall – Linux, Uninstall – Mac OS X.
Upgrading MySQL GUI Tools
Upgrading – Windows, Upgrading – Linux (Tarball Upgrade, RPM Upgrade), Upgrading – Mac OS X.
Running MySQL GUI Tools
Running Under Windows, Running Under Linux, Running On Mac OS X.
- MySQL Administrator -
Introduction to MySQL Administrator
Connection Dialog
Advanced Options, Configure-service Mode.
Main Window
Introduction, Sidebar, Working Area, Menus (File, Edit, View, Tools, Help).
Server Information
Service Control
Introduction, Start Stop Service, Configure Service.
Startup Variables
Introduction
Server Connections
Introduction, Threads, User Connections
User Administration
Introduction, User Accounts, User Information, Global Privileges, Schema Privileges, Table Column Privileges, Resources.
Health
Introduction, Connection Health, Memory Health, Creating Custom Health Graphs, Status Variables, System Variables.
Server Logs
Introductions, Error Log, Slow Log, General Log.
Backup
Introduction, Backup Project, Advanced Options (Backup Execution Method, Output File Options), Schedule.
Restore
Introduction, The General Tab, Restore Content.
Replication Status
Introduction, Configuring Replication Servers, Using the Replication Status Section.
Catalogs
Introduction, Schema Tables (Table Status, Row Status), Schema Indexes.
- MySQL Query Browser -
Introduction to the MySQL Query Browser
A Tour of the MySQL Query Browser
The Main Query Window, The Query Toolbar (The Navigation Buttons, The Query Area, The Action Buttons), The Advanced Toolbar, The Result Area, The Object Browser (The Database Browser, The Bookmark Browser, The History Browser), The Information Browser (The Syntax Browser, The Function browser, The Parameter Browser, The Transaction Browser), The Script Editor (The Script Debugging Buttons, The Script Area).
Using The MySQL Query Browser
Entering and Editing Queries Manually, Building Queries, Creating Views, Navigating Result Sets Within the Result Area, Exporting Result Sets, Handling BLOB and TEXT Columns, Editing Result Sets Within the Result Area, Comparing Result Sets, Managing Stored Procedures and Functions with MySQL Query Browser, Editing Queries From a Development Tool.
- Common Administrator and Query Browser Components -
Options Dialog
Introduction, General Options, Connections (SSL Connections), Editors, The Browser Section (Display Options, Query Options, Various), Administrators (User Administration, Health Graphs, Backup).
- Common Administrator and Query Browser Components -
The MySQL Table Editor
Introduction, The Main Editor Window, The Columns And Indices Tab (The Column Editor, The Detail Area), The Table Options Tab, The Advanced Options Tab (The Various Section, The Row Options Section, The Storage Options Section, The Merge Table Options Section, The Table RAID Settings Section), Applying Your Changes.
- MySQL Migration Toolkit -
Introduction to the MySQL Migration Toolkit
An Overview of the Migration Process
The Migration Process In-Depth
Introduction, The Welcome Screen, The Configuration Type Screen, The Source Database Screen (Microsoft Access, Microsoft SQL Server, Oracle, MySQL, Saving Connection Information), The Target Database Screen, The Connect to Server Screen, The Source Schema Selection Screen, The Reverse Engineering Screen, The Object Type Selection Screen (Migrating a Sub-Set of Object Types), The Object Mapping Screen (GRT Object, Table Objects), The Meta Migration Screen, The Manual Editing Screen, The Object Creation Options Screen, The Creating Objects Screen, The Data Mapping Options Screen, The Bulk Data Transfer Screen, The Summary Screen, Saving the Current Application State.
Scripted Migration
The Steps for Scripted Migration, Setting the Source and Target Connection, Reverse Engineering, Migration Methods, Map Objects and Migrate, The SQL Create Statements, Bulk Data Transfer.
Extending The MySQL Migration Toolkit
Introduction, Architecture of the MySQL Migration Toolkit, The Modular Migration Process, Tools Required to Extend the MySQL Migration Toolkit.
Preparing a Microsoft Access Database for Migration
The Generic Runtime Environment (GRT) Shell
Introduction, Exploring the GRT Shell (Menu Items, The Shell, The Globals Tree Panel), Using the GRT Shell, Invoking the GRT Shell From the Command Line.
- Appendixes -
Installing From Source
Introduction, Downloading The Source Code, Building from Source under Windows (Prerequisites, Compiling and Building), Building from Source under Linux (Prerequisites), Compiling and Building (Building Static Binaries, Building RPMs).
Troubleshooting Application Errors
Troubleshooting Connection Errors, Troubleshooting Display Problems.
How Connections Are Stored
XML Files Common to the MySQL GUI Applications
XML Files Used by MySQL Query Browser
XML Files Used by MySQL Administrator
The MySQL System Tray Monitor
Third-party Software Used by the MySQL GUI Tools
PCRE Library, PNG Support
Notes for Translators
OpenOffice.org 1.0, ODBC, and MySQL ‘How-to’
File title:
OpenOffice.org 1.0, ODBC, and MySQL ‘How-to’
File type: PDF
File url:
http://www.unixodbc.org/doc/OOoMySQL.pdf
File size: 2.12 mb
File content:
‘Access’ your data - OpenOffice.org 1.0’s best kept secret
‘Access’ for Linux?, Software options, Notes for users of MS-Windows platforms.
Joining OpenOffice.org 1.0 to MySQL using ODBC
Installing MySQL, Testing MySQL, Installing unixODBC and the MySQL libraries, Creating the ODBC .ini files, Testing ODBC, Setting up ODBC within OpenOffice.org 1.0, If you use another installation method.
Using the Data Source Tools in OpenOffice.org 1.0
Finding the Data Source Tools, Working with Table Definitions (Creating a table, Designing Indexes, Changing the definition of a table), Editing data, Using the Database Toolbar to work with your data (Displaying/Hiding the Data Source Explorer, Find Record, Sort Ascending / Sort Descending, AutoFilter, Default Filter, Sort, Remove Filter / Sort, Apply Filter, Refresh, Edit Data, Save Current Record), Creating new Views of your data (Rows in the Query Design table, The Query Toolbar), More Complex Queries (Example 1 - Orders on Hand, Example 2 - Summary Orders on Hand).
Using Data Sources in other OpenOffice.org 1.0 programs
Calc (Creating a link with Drag and Drop, Menu Options, Data Pilot), Writer (Creating a link with Drag and Drop, Using the Database Toolbar).
Using the Form AutoPilot
The Form AutoPilot in action
ARTICLE in PDF ABOUT PHP - Part 1
Securing PHP Applications
http://ilia.ws/files/phptek2007_security.pdf
PHP & Performance
http://ilia.ws/files/frankfurt_perf.pdf
SQL Injection
http://dev.mysql.com/tech-resources/articles/guide-to-php-security-ch3.pdf
PHP Security Audit HOWTO
http://brainbulb.com/talks/php-security-audit-howto.pdf
Profiling PHP Applications
http://www.schlossnagle.org/~george/talks/Profiling-phpworks-2004.pdf
DOWNLOAD AUDIO FROM IMEEM
You can use Free Music Zilla to download audio from IMEEM.
You can download Free Music Zilla from http://www.freemusiczilla.com/download.htm
For more detail about Free Music Zilla, you can go to http://www.freemusiczilla.com/
Where can I find tutorial Moving from Visual Basic 6 to Visual Basic .NET ?
You can find the tutorial Moving from Visual Basic 6 to Visual Basic .NET from this web site:
http://www.aggelos.com/demos/VB_Migration.pdf
From the above website you can find:
VB.NET Migration
Moving from Visual Basic 6 to Visual Basic .NET
The .NET Framework is a development platform, Windows support for the .NET Framework, Distributed applications with .NET, ASP.NET: a platform on a platform, Windows Server 2003 With IIS6, What is managed code?, Assemblies, Just-in-time (JIT) Compilation, Framework Class Libraries (FCL), Reasons to migrate to the .NET Framework, Challenges in migrating to .NET using VB.NET, Using Visual Studio .NET, “Hello World” with VB.NET, Projects and references, Namespaces, Projects and namespaces, Assemblies used by a typical application, The Microsoft.VisualBasic assembly, Creating forms-based applications, WinForms Primer, VB.NET langua
Where can I find Cheat Sheet : VB Language Basics for Visual Basic 2005 Express Edition ?
You can find Cheat Sheet : VB Language Basics for Visual Basic 2005 Express Edition from the link below:
http://www.learnvisualstudio.net/content/cheats/VB_Language_Basics.pdf
From the above link you can find:
Visual Basic 2005 Express Edition
Cheat Sheet : VB Language Basics
Working With Numbers, Making Decisions, Working With Strings, Working With Dates and Times, Making Comparisons, Working With Objects, Loops, Working With Text, Working With XML, Working With a Database, Classes.
WHERE CAN I FIND TUTORIAL PROGRAMMING IN VISUAL BASIC 6.0 ?
You can find TUTORIAL PROGRAMMING IN VISUAL BASIC 6.0 from this web page:
http://www.hsc.csu.edu.au/sdd/core/package/solution_package/tutorials/visualbasic_tutorial.pdf
From the above web page you can find:
Tutorial: Programming in Visual Basic 6.0
Activity 1: Welcome screen and menu editor, Activity 2: Event handlers and scroll bars, Naming conventions, Data types, variables and functions, Activity 3: Messages and input boxes, Activity 4: Create a calculator and avoid division by zero, Sequence, Binary Selection, Activity 5: Measurement converter, Multiway selection, Activity 6: Multiway selection, Activity 7: Control arrays, Iterations, Activity 8: Pre-test loops, Activity 9: Post-test loops, Activity 10: Random number generator, Activity 11: Using a counter in a pre-test loop, Activity 12: Nested FOR loops and arrays.
WHERE CAN I FIND ARTICLE ABOUT INTEGRATING VISUAL BASIC 6.0 and SURROUND SCM ?
You can find article about INTEGRATING VISUAL BASIC 6.0 and SURROUND SCM from the webpage below:
http://downloads.seapine.com/pub/resources/scm/VisualBasic_SCMIntegration.pdf
From the above web page you can find:
Integrating Visual Basic 6.0 and Surround SCM
Installing the Visual Basic plug-in, Adding projects to Surround SCM, Adding files to Surround SCM, Getting the latest file version, Checking out files, Undoing check out, Checking in files, Refreshing file status, Viewing file differences, Viewing file history, Viewing file properties, Setting source code control options, Troubleshooting Visual Basic and Surround SCM integration, Surround SCM is not displayed as an active SCM provider, Surround SCM files are not displayed correctly in Visual Basic, Files cannot be added to Surround SCM from Visual Basic, An error message is returned when you perform a Surround SCM action.
Where can I find the document contains the keyboard shortcuts that are set by default when I use the Visual Basic Development Settings ?
You can find the document contains the keyboard shortcuts that are set by default when you use the Visual Basic Development Settings from the link below:
http://download.microsoft.com/download/d/6/5/d65efda0-cf25-4720-8013-b3080586c5bb/VB_2005_color.pdf
From the link below you can find:
Microsoft® Visual Basic® Default Keybindings
Editing
Toggle All Outlining, Toggle Outlining for Current Region, Comment and Uncomment, Undo, Redo, Cut Line, Insert Blank Line, Select Word, Delete Word, Change Casing, Replace, Extend Selection, Format Code, Display Smart Tag, Help.
Build
Build Solution
Windows
Navigation Bar, Object Browser, Properties Window, Solution Explorer, View Server Explorer, Show Data Sources, Toolbox, Error List, Close Tool Window, Close Document Window.
Debugging
Start Debugging, Start Without Debugging, Step Into, Step Out, Step Over, Stop Debugging, Toggle Breakpoint, Set Next Statement, Break at a Function, Attach to Process, Make Data Tip Transparent, Immediate Window, Call Stack Window, QuickWatch Window.
Refactoring
Refactor!
Navigation
Go to Defi nition, Navigate Backward, Navigate Forward, Previous Method or Type, Next Method or Type, Previous and Next Word, IDE Navigator, View All Open Documents, View Code, View Designer, HTML Designer, View Document Outline, Add or Remove Bookmark, Navigate Bookmarks, Delete All Bookmarks.
Search
Find Symbol, Find All References, Find Text, Next and Previous Search Result, Next and Previous Selected, Incremental Search, Stop Search.
WHERE CAN I FIND ARTICLE ABOUT C# FOR VISUAL BASIC 6 DEVELOPERS ?
You can find article about C# FOR VISUAL BASIC 6 DEVELOPERS from this link:
http://media.wiley.com/assets/264/20/0764557599_bonus_AppB.pdf
From the above link you can find:
C# for Visual Basic 6 Developers
Differences Between C# and Visual Basic, Classes, Compilation, The .NET Base Classes, Conventions, Example: The Square Root Form, SquareRoot Visual Basic Version, SquareRoot C# Version, Basic Syntax, C# requires all variables to be declared, Comments, Statement separation and grouping, Capitalization, Methods, Variables, Declarations, Assigning values to variables, Classes, If Statements, Calculating square roots: Another class method, Extra Code in C#, What Happens When You Run a Program, The C# Code for the Rest of the Program, Namespaces, The using directive, The class definition: Inheritance, Program Entry Point, Instantiating Classes, C# classes, Entering the message loop, The SquareRootForm Class, Summing up.
Example: Employees and Managers, The Visual Basic Employee Class Module, The C# Employee class, The Employee constructor, Properties of Employee, Methods of Employee, Static Members, Inheritance, Inheriting from the Employee Class, The Manager Class, Method Overrides, The Manager Constructors, Method Overloading, Using the Employee and Manager Classes, References to Derived Classes.
Arrays of Objects, The for Loop.
Other C# Features, Data Types, Value and reference types, Operators, The ternary operator.
Where can I find Visual Basic 6 Reference Sheet ?
You can find Visual Basic 6 Reference Sheet from the site below:
http://www.dreamincode.net/downloads/ref_sheets/vb_reference_sheet.pdf
From the above link you can find:
VB6 Reference Sheet
Variable Declaration, Data Types, Type Declaration, Suffixes, COmments, Arithmetic Operators, Logical Operators, Comparision Operators, Bitwise Operators, If/Else, Inline IF, Case Statement, For Loop, Do-While Loop, Do-Loop-While, Do-Until Loop, Do-Loop-Until, While-Wend Loop, For-Each Loop, Arrays, Chane Array Length, Procedures, Functions, Argument List, Calling Procedures/Functions, File Handling, For reading fields from a file into variables, For reading the entire line in the file into a single string, For Writing Data, To Close the Data File, Simple Error Handling.
WHERE CAN I LEARN VISUAL BASIC 6.0
You can download the tutorial about VISUAL BASIC 6.0 from this link:
http://w3.balikesir.edu.tr/~kahveci/kitap/VisualBasic6.pdf
From the above link you can learn about:
Introduction to the Visual Basic Language and Environment
Preview, Course Objectives, What is Visual Basic?, Visual Basic 6.0 versus Other Versions of Visual Basic, 16 Bits versus 32 Bits, Structure of a Visual Basic Application, Steps in Developing Application, Drawing the User Interface and Setting Properties, Example 1-1: Stopwatch Application - Drawing Controls, Setting Properties of Objects at Design Time, Setting Properties at Run Time, How Names Are Used in Object Events , Example 1-2: Stopwatch Application - Setting Properties, Variables, Visual Basic Data Types, Variable Declaration , Example 1-3: Stopwatch Application - Attaching Code, Quick Primer on Saving Visual Basic Applications, Exercise 1: Calendar/Time Display.
The Visual Basic Language
Review and Preview, A Brief History of Basic, Visual Basic Statements and Expressions , Visual Basic Operators, Visual Basic Functions, A Closer Look at the Rnd Function, Example 2-1: Savings Account, Visual Basic Symbolic Constants , Defining Your Own Constants, Visual Basic Branching - If Statements, Key Trapping, Example 2-2: Savings Account - Key Trapping, Select Case - Another Way to Branch, The GoTo Statement, Visual Basic Looping, Visual Basic Counting, Example 2-3: Savings Account - Decisions , Exercise 2-1: Computing a Mean and Standard Deviation, Exercise 2-2: Flash Card Addition Problems.
Exploring the Visual Basic Toolbox
Review and Preview, The Message Box , Object Methods, The Form Object, Command Buttons, Label Boxes, Text Boxes, Example 3-1: Password Validation, Check Boxes, Option Buttons, Arrays, Control Arrays , Frames, Example 3-2: Pizza Order, List Boxes , Combo Boxes, Example 3-3: Flight Planner, Exercise 3: Customer Database Input Screen.
More Exploration of the Visual Basic Toolbox
Review and Preview, Display Layers, Line Tool, Shape Tool, Horizontal and Vertical Scroll Bars, Example 4-1: Temperature Conversion, Picture Boxes, Image Boxes, Quick Example: Picture and Image Boxes, Drive List Box , Directory List Box, File List Box, Synchronizing the Drive, Directory, and File List Boxes, Example 4-2: Image Viewer, Common Dialog Boxes, Open Common Dialog Box, Quick Example: The Open Dialog Box, Save As Common Dialog Box, Quick Example: The Save As Dialog Box, Exercise 4: Student Database Input Screen.
Creating a Stand-Alone Visual Basic Application
Review and Preview , Designing an Application, Using General Sub Procedures in Applications, Creating a Code Module, Using General Function Procedures in Applications, Quick Example: Temperature Conversion, Quick Example: Image Viewer (Optional), Adding Menus to an Application, Example 5-1: Note Editor, Using Pop-Up Menus, Assigning Icons to Forms , Designing Your Own Icon with IconEdit, Creating Visual Basic Executable Files , Example 5-2: Note Editor - Building an Executable and Attaching an Icon, Using the Visual Basic Package & Deployment Wizard, Example 5-3: Note Editor - Creating a Distribution Disk, Exercise 5: US Capitals Quiz.
Error-Handling, Debugging and File Input/Output
Review and Preview, Error Types, Run-Time Error Trapping and Handling, General Error Handling Procedure, Example 6-1: Simple Error Trapping, Debugging Visual Basic Programs, Example 6-2: Debugging Example, Using the Debugging Tools, Debugging Strategies , Sequential Files, Sequential File Output (Variables), Quick Example: Writing Variables to Sequential Files, Sequential File Input (Variables), Quick Example: Reading Variables from Sequential Files, Writing and Reading Text Using Sequential Files, Random Access Files, User-Defined Variables, Writing and Reading Random Access Files , Using the Open and Save Common Dialog Boxes, Example 6-3: Note Editor - Reading and Saving Text Files, Exercise 6-1: Information Tracking, Exercise 6-2: ‘Recent Files’ Menu Option.
Graphics Techniques with Visual Basic
Review and Preview, Graphics Methods, Using Colors , Mouse Events, Example 7-1: Blackboard, Drag and Drop Events, Example 7-2: Letter Disposal, Timer Tool and Delays , Animation Techniques, Quick Example: Simple Animation, Quick Example: Animation with the Timer Tool, Random Numbers (Revisited) and Games, Randomly Sorting N Integers, Example 7-3: One-Buttoned Bandit, User-Defined Coordinates, Simple Function Plotting (Line Charts), Simple Bar Charts, Example 7-4: Line Chart and Bar Chart Application, Exercise 7-1: Blackjack, Exercise 7-2: Information Tracking Plotting.
Database Access and Management
Review and Preview, Database Structure and Terminology, ADO Data Control, Data Links , Assigning Tables, Bound Data Tools, Example 8-1: Accessing the Books Database, Creating a Virtual Table, Quick Example: Forming a Virtual Table , Finding Specific Records, Example 8-2: ‘Rolodex’ Searching of the Books Database, Data Manager, Example 8-3: Phone Directory - Creating the Database, Database Management, Example 8-4: Phone Directory - Managing the Database, Custom Data Aware Controls, Creating a Data Report, Example 8-5: Phone Directory - Building a Data Report, Exercise 8: Home Inventory Database.
Dynamic Link Libraries and the Windows API
Review and Preview, Dynamic Link Libraries (DLL), Accessing the Windows API With DLL, Timing with DLL Calls, Quick Example 1: Using GetTickCount to Build a Stopwatch, Quick Example 2: Using GetTickCount to Implement a Delay , Drawing Ellipses, Quick Example 3: Drawing Ellipses , Drawing Lines, Quick Example 4: Drawing Lines , Drawing Polygons, Quick Example 5: Drawing Polygons, Sounds with DLL Calls - Other Beeps, Quick Example 6: Adding Beeps to Message Box Displays, More Elaborate Sounds, Quick Example 7: Playing WAV Files, Playing Sounds Quickly , Quick Example 8: Playing Sounds Quickly, Fun With Graphics, Quick Example 9: Bouncing Ball With Sound!, Flicker Free Animation, Quick Example 10: Flicker Free Animation, Quick Example 11: Horizontally Scrolling Background, A Bit of Multimedia, Quick Example 12: Multimedia Sound and Video , Exercise 9: The Original Video Game - Pong!
Other Visual Basic Topics
Review and Preview , Custom Controls, Masked Edit Control, Chart Control , Multimedia Control, Rich Textbox Control , Slider Control, Tabbed Dialog Control, UpDown Control , Toolbar Control, Using the Windows Clipboard, Printing with Visual Basic, Multiple Form Visual Basic Applications, Visual Basic Multiple Document Interface (MDI), Creating a Help File , Class Summary, Exercise 10: The Ultimate Application.
Visual Basic Symbolic Constants, Common Dialog Box Constants.