To sell your products and services on line, you need an on-line database.
If you want your sales people to have access to current data, you need an
on-line database. If you want your people to be able to work from home,
to be able to update something where ever they are, away from the office,
you need an on-line database. You are not talking about hireing a web
designer, you are talking about custom programming to meet your needs.
That is what I do. It has been my profession for years. I am the
professional programmer who can design the site you need, making it
look good and making the data access be logical - easy to find.
Give me a
call. Ask for Greg.
Search Engine Optimization
Part 1
A. good ranking excludes keyword spamming of the search engine
B. ranking results change week-to-week due to competition,
so maintaining a top ranking site requires constant keywords
monitoring and information rework. Search Engine Optimization
never rests, much like your competition.
C. Google's emphasis is on content and link popularity:
the popularity of the sites that link to your site,
the text in and around the links that point to your site, and
the popularity of the sites that you link to.
D. other links are of minimal importance - or in the case of spam
they can even be a penalty
I am Greg Smith, a Sr. Systems Analyst, a Sr. Software Engineer.
I have designed, amended, and programed large in-house data bases
on corporate and government mainframes for over 10 years. Since
2003, I have accessesd and updated SQL data bases through the
internet.
gregs@pwsdb.com is my email address and www.pwsdb.com is
my web site. On my web site, below, is a sample accounting
database of a finance department; (called Northwind).
At the bottom of this page are links to other sites I have built.
www.fuel-efficient-vehicles.org is one with a blog
which I have customized. www.9inningbaseball.org provides
on-line registration forms for the American Legion Wood Bat
Baseball League. The director of all the local American Legion
posts in this area of south Florida was the one who commissioned
me to build their site. He is also an American Airline pilot
and has commissioned me to build one for him personally as well:
www.aapilots.us
One of my first web sites was The Philippine
Consulate to South Florida for the Honorary Consul General.
Last year I took a job with Photowalk Productions and designed
and developed a custom on-line project (asset) management system
using the Smarty template system and AJAX (XML & JavaScript) for
faster data loading (Virtual AMS).
|
NorthWind Corp. Accounting Database
July 1996 to Wed.eve. 5-6-1998
demo
the 7 days before today in 1997
The 11 Orders Shipped from 1997-11-15 up to 1997-11-22
| Order ID |
in order by
Ship Date |
Ship Co. Name |
# of Prod's sold |
# of Items sold |
$Sale |
# of Prod's < $20 |
# of Prod's $20-40 |
# of Prod's >= $40 |
|
10739
|
1997-11-17
|
Vins et alcools Chevalier
|
2
|
24
|
$ 251.08
|
2
|
0
|
0
|
|
10737
|
1997-11-18
|
Vins et alcools Chevalier
|
2
|
16
|
$ 147.59
|
2
|
0
|
0
|
|
10742
|
1997-11-18
|
Bottom-Dollar Markets
|
3
|
105
|
$ 3,361.73
|
1
|
2
|
0
|
|
10738
|
1997-11-18
|
Spécialités du monde
|
1
|
3
|
$ 55.26
|
1
|
0
|
0
|
|
10741
|
1997-11-18
|
Around the Horn
|
1
|
15
|
$ 238.96
|
1
|
0
|
0
|
|
10705
|
1997-11-18
|
HILARION-Abastos
|
2
|
24
|
$ 381.52
|
1
|
1
|
0
|
|
10709
|
1997-11-20
|
Gourmet Lanchonetes
|
3
|
78
|
$ 3,634.80
|
0
|
1
|
2
|
|
10735
|
1997-11-21
|
Let's Stop N Shop
|
2
|
22
|
$ 582.37
|
1
|
1
|
0
|
|
10746
|
1997-11-21
|
Chop-suey Chinese
|
4
|
83
|
$ 2,343.13
|
2
|
1
|
1
|
|
10736
|
1997-11-21
|
Hungry Owl All-Night Grocers
|
2
|
60
|
$ 1,041.10
|
1
|
1
|
0
|
|
10743
|
1997-11-21
|
Around the Horn
|
1
|
28
|
$ 342.92
|
1
|
0
|
0
|
|
Click on an Order ID to see it's details
|
Total:
|
$ 12,380.46
|
|
Each line of data above comes from 3 files (tables):
the orders file, the order-details file,
and the customer file. There are also files of
employees, products, suppliers, shippers, and more.
|
|
Welcome to
Fort Lauderdale
|
|
A few more of my web sites
|
|
My first web site
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The safest web sites are viewed
best with trusted browsers
(not Internet Explorer)
|
Web surfing is not safe with Internet Explorer
PWSDB, C/O
Greg Smith, Pompano Beach, FLorida 33062
|
the Philippine Consulate 
Project Management
The American Legion
On Line Evaluations
Word Doctor X
Philippine Market
Programming
www.AAPilots.US
Love One Another