Aug 04

Windows XP Embedded #85

From: http://sitestree.com/?p=5115
Categories:85
Tags:
Post Data:2011-11-05 05:21:13

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

Traffic Crashes Are Getting Worse. Car Ads Are Part Of the Problem.

More on CityLab:
The Plexes of Montreal Make Room for Change
With their distinctive details and treacherous outdoor staircases, these two- or three-floor apartment buildings dominate the city’s multi-family rental housing market.
Traffic Crashes Are Getting Worse. Car Ads Are Part Of the Problem.
What if car companies were banned from boasting their trucks can “conquer,” “intimidate” and “thrill”?
Turkey Battles Wildfires for 6th Day; 10,000 Are Evacuated
Fed by strong winds and scorching temperatures, the fires that began Wednesday have left eight people dead.

Aug 04

Sitemap Basics #86

What is a sitemap:
A sitemap is a file that contains the web-site structure. It will primarily contain URLs of different pages or sections of the web-site. You can provide additional information for each URL. It can be in text, HTML, and XML formats.

A text file containing all the URLs of a web-site can be treated as a sitemap. However, using HTML or XML, you can specify more information (change frequency, title, description and similar) about each of the URLs.

A sitemap written in XML for http://www.saLearningSchool.com can be seen at http://www.salearningschool.com/sitemap.xml

Sitemap Categories:

  • XML sitemap
  • HTML sitemap
  • Images sitemap
  • Video sitemap
  • News sitemap
  • Text formatted sitemap
  • Mobile sitemap

How can you generate a sitemap?
You can do it manually; or you can use web-based or standalone services to generate sitemaps. I created the above sitemap using the servicehttp://www.xml-sitemaps.com . Just put your url there, provide some information about the site contents, then click on Start. Your sitemap will be generated for free with 500 links in it. You can buy and install the Script from http://www.xml-sitemaps.com, and then create sitemaps with unlimited number of URLs. You can also create sitemaps of different types such as Image Sitemap, Video sitemap using the script.

What are Image and Video Sitemaps?
Image sitemaps will contain URLs for images with information about the images.
Video sitemap will contain URLs for videos in your site and information about the videos.

Sitemaps can be very helpful when your site is a very new one, has significant dynamic contents, your Ajax related pages cannot be easily crawled, you have contents that are not linked much or not linked at all.

Why do you need sitemaps?

It can greatly help in your SEO (Search Engine Optimization). Using google webmaster tools, you will be able to upload your sitemap to google.It’s a way to tell google about all of your pages; it is also a protection against the fact that Google Crawler may not find all of your pages.

URL for Google Webmaster:http://www.google.com/webmasters/

In Google webmaster, you can add your sites. You can upload your sitemaps. You can see the result of crawling your sites and sitemaps. You can see errors in your site crawling. You can see the pages indexed by google. You can see the keywords people used to find your site.Also, it will display the top queries.

From: http://sitestree.com/?p=5295
Categories:86
Tags:
Post Data:2010-03-16 12:09:44

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

Some basic Search Engine Optimization Principles (Lesson 1) #86

  • Provide titles for each page. Provide different titles for different pages. Make the title keyword-rich and meaningful to the visitors. Make the title to describe the page content accurately
  • Use description meta-tag to describe page contents. Provide different descriptions for each page. Accurately describe the content of the page.
  • Make your urls meaningful to your visitors. Use words in URLs
  • Use an organized and meaningful directory structure for your site. Users should be able to guess where they are at your site [can be security risk though]
  • Provide only one path to a webpage. A page should not be able to be reached by domains, subdomains, and multiple domains. Use .htaccess [301 redirect]
  • Provide easier navigation to your site for example allow removal of part of the url and still make the url work
  • Use text primarily for navigation [anchor tag]. Always, use alt for images and image based navigation
  • Put both XML and HTML sitemap on your site.
  • Have meaningful 404 error pages
  • Always offer useful information and services
  • Update your content regularly. Provide unique contents, unique services
  • Provide contents for users, not for search engines
  • Use descriptive and meaningful anchor texts
  • Use descriptive names for images
  • Prove an image sitemap for your site as well
  • Use heading tags. Also, use them to define the content structure and content hierarchy in the webpage
  • Use robots.txt file to provide/revoke access to certain parts of your sites. Restrict private areas for search engines
  • use rel=”nofollow” appropriately to prevent comment spaming, bringing bad reputation of other sites into your site
  • if you redirect your users to your mobile site for a page/url, make sure the target page also contains the same content
  • Verify that Google recognizes your mobile site
  • Promote your site carefully for backlinking. use ethical services
  • Submit your site including mobile site to google
  • Make use of Google webmaster tools and work on the suggestions as you get from there

Reference: Google Search Engine Optimization Guide

From: http://sitestree.com/?p=5283
Categories:86
Tags:
Post Data:2008-09-04 06:36:40

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

Software Testing #88

Software Testing

From: http://sitestree.com/?p=5219
Categories:88
Tags:
Post Data:2008-08-23 20:11:44

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

The Benefits of Web-Based Help Desk Software #88

Web-based help desk software has become the most popular way to manage technical inquiries and issues. The ability to access your help desk from any PC in the world is a very convenient tool. These programs offer flexibility and accessibility that was unavailable in former product versions.

Like other help desk software products, web based products offer the ability for customers to create their own trouble tickets. Effectively managing trouble tickets can save your business both time and money. In some cases, having an informative F.A.Q. menu allows the customer to troubleshoot his or her problem without contacting the technical support department. Customers enjoy finding the answers to their problems quickly, without the traditional wait times.

Companies waste valuable resources when they do not effectively manage their customer issues. Web-based help desk software is much more productive than having multiple email addresses for customer messages. By offering a web based help desk, companies can manage their tickets by directing them to the appropriately trained personnel. Using this type of product can save thousands of dollars every month and prevent employees from becoming overworked and burnt out. Many companies also praise the flexibility of working with a web-based system. Customer and technical support can be managed from anywhere in the world. The web-based option overall is much more flexible than stationary help desk programs.

When researching your options for web based help desk software, please be aware that some companies may have hidden charges. Constant updates can become troublesome and costly ? it is wise to know what updates are expected and how frequently prior to purchasing a software package. Some software providers require additional purchases of database software components, web-servers and/or middleware. Know exactly what you are buying and what the future expectations are to ensure your satisfaction with your software.

About the author:
Help Desk Software Info provides detailed information on help desk software solutions, including IT help desk software, web-based help desk software, free help desk software, help desk tracking, help desk support software, and reviews of help desk software programs. Help Desk Software Info is the sister site of Recruiting Software Web.

Circulated by Article Emporium

From: http://sitestree.com/?p=5134
Categories:88
Tags:
Post Data:2012-07-17 17:59:39

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

Choosing a Cell Phone #89

Considering the innumerable varieties of cell phones in the market, it is quite a challenging task to choose the best one. However, the basic criterion of selecting the best cell phone is to be absolutely clear about what your needs are. The best cellular phone is the one that is absolutely right for you. And, of course, you can only have the best cellular phone when you pay for what you want.

Tons of offers are also available. There are free cellular telephone offers, prepaid cellular, digital, mobile, web enabled and many more. No one can tell you which cell phone is best for you because every one has different needs when it comes to their cellular telephone. Some people want absolutely basic features while others want a lot of totally fantastic features. Some need a cellular telephone for e-mail, faxing and surfing the Internet. Many people want it to be top of the line while others prefer simplicity.

The process of buying a cell phone is so confusing. There are simply so many different handsets, networks, deals and call costs to consider that buying the right phone for your usage and budget can be very difficult.

Here are a few tips to help you choose the best cell phone. First of all, decide how much you want to spend and be clear on the features you need. Remember that the more the features, the higher the cost.

Purchase a battery with a decent battery life and judge the mobile phone by the talk time it gives. The bare minimum should be 2 hours of maximum talk-time plus 90 hours of maximum standby time.

Shop and compare for pricing and service. These days, quality phones are very cheap. There is a proliferation of cell phone makers including Nokia, Motorola, Ericson, Siemens, Samsung, Sony, etc. More importantly, cellular plans have come down enormously in overall price with some caveats.

Some standard features include caller ID, phone book with fast dial, call waiting, voice mail and auto-answering. Some also have other added features like your first incoming minute free. The high-end cell phones will have voice-a ctivated dialing, SMS, 2-way paging, games, scheduling calendars, digital organizer and all the standard features. The main thing is to see what fits into your life style best and also to be sure when and if the features expire.

While making a cell phone and service plan decision, remember that everybody’s needs are different. So what’s good for your friend may not be the best choice for you. Your best bet would be to search online for websites with good cell phone comparisons in order to get a quality cell phone offer.

To make sure that your cell phone comparisons are complete look at Nokia cell phones, Ericsson cell phones, Sprint cell phones, Motorola cell phones and Samsung cell phones. Research the different free cell phone offers, prepaid cell phones and service plans from brand names like AT

From: http://sitestree.com/?p=5129
Categories:89
Tags:
Post Data:2012-03-25 09:59:04

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

Access 2007: How to #90

Access 2007: How to

How to compact and repair database?

File menu (Alt+F) -> Manage -> Compact and Repair Database. Why? To reduce file/database size. Helpful – when you want to upload to a remote server.

Compacting and Repairing databases many times can solve many database issues. Use the feature once in a while – while developing

How to backup an Access Database?

File Menu (Alt+F) -> Manage -> Back Up Database. Follow the wizards/options.
You can backup your databases once in a while. Good practice to save your data and databases.

How to restore an Access Database?
Really you need to do nothing. Just open the backed-up database in Microsoft Access (2007)

How to set database properties in Access?
File Menu (Alt+F) -> Manage -> Database Properties

How to create different objects (database objects and front end objects) in Microsoft Access?
Under ‘create’ toolbar, check toolbar options to create different database and front end objects

Table: To store data

Table Templates: You can use existing tables (table templates) to create new tables

Table Design: You can design tables, assign primary keys, insert and delete rows from here. Also, you can use the ‘Lookup Column’ option for the table (Foreign key concept in Access). Under ‘table design’ option, you can also create indexes. Indexes make your queries run faster (you need to use the index column in your where clauses, group by clauses , order by clauses as appropriate)

Form: You can create Form objects using the ‘form’ option. It uses a table as the back-end and creates the form with table fields on the form. Open/select the table first – that need to be used in the form.

Split Form: A form with two sections. The upper section with Table Field/value pairs. Lower part – grid views of the table

Multiple Items: Will create a form with multiple rows on the form. Similar to Grid View

Blank Form: A plain blank form, you can design it on your own as you want. You can also control which table/query to connect to

More Forms -> Form Wizard : Will guide you step by step to create a form based on tables/queries

More Forms -> Modal Dialog : Will create a dialog box (Modal)

Form Design: Design your own forms as you want. Link to tables/queries as you want.

Report: Use the report menu to create a report based on a table or query. Open/select the table/query based on what – the report will be created. Click on the report toolbar option.
A report will automatically get created. Then you can manipulate what data should be displayed – what not

Report Design: You can design your reports from scratch here. You can use Record Source property to point to the data source (table, query). When the report designer will open, you will see a new toolbar at the top. You will see controls that are useful for reports

Query Wizard: Will guide you step by step to write queries.

Query Design: Will help you to build queries based on a graphical interface. You will also be able to write sql statements and see it in graphical interface

Macro: To write macros, classes, modules

What are the tools access provides to access data in other systems?
Use the External Data toolbar to find out

In the import section, you can see options to import data from other sources such as Access (other access database), Excel, Text File, XML File, ODBC (can be used to collect data from any data source that supports ODBC access such as SQL Server, Oracle).

In the export section, you will see options to export your access database (hence the data) to other data sources such as Excel, Word file, Sharepoint, text file, xml file

How to give custom functionality to access forms?
Use the Visual Basic option under the Database Tools toolbar. When you click – Visual Basic – a code window will appear – where you can write vb code to provide custom functionality.

In the code window, select the form where you want to write code – then write code on different events. At the top of code writing screen – you will see a object selection box and an event selection box.

Select objects and events to write codes for the corresponding events and objects

Alternate way: Open a form -> click an object -> right click -> properties (from toolbar you can also go to properties) -> click event tab -> in the event – select event procedure -> click eclipses (…) -> you will be taken to the place where you need to write code (for the object/event).

How to create relationships in Access?
When you design ER diagram, you usually define relationships among tables. To implement relationships – you usually need to place one table’s fields (foreign key concept) into another table (or create new table based on the related fields) – anyway – check the DBMS theory section of this web-site.

In access, under database tools options, you will see ‘Relationships’ option

Click Relationships option -> you will see all existing relationships. Click any relation as shown by lines and arrows – you will be able to modify the relation (also you will see an option to create a new relationship)

Here you can add tables by right clicking and selecting show table. Then from the toolbar select ‘Edit Relationships’ -> then click ‘Create new’ to create new relationships. Don’t forget to use the ‘Join Type’ option to define relationship type.

Whether you use this access relationship feature or not -> using relationship in database design is highly recommended. Also, relationship simplication is highly recommended. Table design must reflect the relationships. If your databases/applications grow very big – the importance will be realized.

How to password protect access database?
Under Database tools option, use the Encrypt with password option

How to Migrate Access data to Microsoft SQL Server?
Use the SQL Server option under the ‘Database Tools’ toolbar.

You may also use the Export feature under External Data toolbar. USe ODBC

How to deploy your Access Database/Application so that your clients can not access the code (also can not modify the design)?
Use the Make ACCDE option under the ‘Database Tools’ toolbar

How to create database documentation in Access?Use the Database Documenter option under the ‘Database Tools’ toolbar. Just need to select the tables/queries/reports…..and select some other options as appropriate – childish stuff

How to separate backend (i.e. tables) from front-end (i.e. Forms)?Use the ‘Access Database’ option under the ‘Database Tools’ toolbar. It will ask you confirmation on splitting database

How to link the front end of a split database to it’s back-end?Use the Linked Table Manager under the Database Tables toolbar.
First, bring the back-end tables using the ‘Access’ option under the ‘External Data’ toolbar.

From: http://sitestree.com/?p=5223
Categories:90
Tags:
Post Data:2008-10-06 00:15:08

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

How to Convert Microsoft Access Database to MySQL Database #90

  • Approaches:
    • Access exports its own tables: write access table data in a text file then use load data command from mysql to load those data in a table. Example: select access table->right click->export. From MySQL: run the queryLOAD DATA LOCAL INFILE ‘c:student.txt’ INTO TABLE student FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘rn’;
      Syntax: 
      LOAD DATA INFILE SyntaxLOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'    [REPLACE | IGNORE]    INTO TABLE tbl_name    [CHARACTER SET charset_name]    [FIELDS        [TERMINATED BY 'string']        [[OPTIONALLY] ENCLOSED BY 'char']        [ESCAPED BY 'char']    ]    [LINES        [STARTING BY 'string']        [TERMINATED BY 'string']    ]    [IGNORE number LINES]    [(col_name_or_user_var,...)]    [SET col_name = expr,...]
    • You can also use mysqlimporti command. Such as: Check the syntax here
    • For converting you can also use: Converters That Generate Intermediate Files : Some converters can create sql files based on your access database. Then use MySQL tools to convert: mysql -h some_host -p -u some_user mydb < file.sql
    • Converters That Perform Direct Data Transfer:Use Access to MySQL Tool
  • A Great Resource

From: http://sitestree.com/?p=5130
Categories:90
Tags:
Post Data:2011-01-29 22:20:26

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Aug 04

What VBA can do for Microsft Access? Topics to learn in VBA #90

What VBA can do?

  • VBA can be used to automate Access
  • VBA provides a true automation tool, replacing and extending anything that you can do with Access macros
  • Can manipulate/utilize Access event model
  • Can populate and manipulate access controls
  • Provides complete control over the data and layout of reports from code

What to learn in VBA?

  • Familiarize yourself with the editor to write VBA codes
  • Understand Variables, Constants, and Data Types in VBA
  • Learn procedures in VBA
  • Common VBA Functions: Financial and date calculations, text manipulation, and mathematical functions
  • Flow-of-Control Statements in VBA
  • Arrays
  • Objects: Built in VBA Objects
  • Scope and Lifetime of variables
  • VBA to automate Access forms
  • Access event handling with VBA
  • Populate and manipulate controls such as List and Combo boxes with VBA
  • VBA to control the data and layout of reports from code
  • Get information about Access objects such as forms, reports, tables, and queries with VBA
  • Control and manipulate data access with ADO
  • ADOX to create an entirely new Access table without ever touching the Access user interface
  • Working with Text files using VBA
  • VBA code in Access to manipulate applications such as Microsoft Word or Microsoft Excel
  • Working with XML Files using VBA
  • Using Windows API from VBA
  • VBA Alternatives: Access macros or Structured Query Language (SQL)

From: http://sitestree.com/?p=5123
Categories:90
Tags:
Post Data:2006-10-24 21:07:29

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada