Thursday, December 16, 2021

Google Docs needs a single user DBMS like Microsoft Access. Single user, like a spreadsheet program.

I use a Chromebook (Pixelbook from Google) and free Google Docs, mostly its spreadsheet program. I create my spreadsheets on a Google server so I do not need to be concerned about backing up.

Occasionally, I use my Windows 10 Microsoft Surface laptop to run single user database management system (DBMS) Microsoft Access, which came out about 30 years ago. Its basics haven't changed much. In some ways it has regressed. It's ridiculous "ribbon" at the top, which replaces drop down menus, keeps getting more convoluted. What happened to "open tables" I think it was called? Simpler is almost always better.

Also, the Access programming team has not adapted the product for more varied screen resolutions. There are numerous anomalies, including the "ribbon" and "Navigation Pane" (Who knew it was called that?) present with font size that's really small at default resolutions in Windows 10. A solution: Settings "Ease of Access" "Make text bigger" at 170%. Hit the Apply button and Access is now more readable with table and query names in the Navigation Pane larger. The "ribbon" is also larger. Unfortunately, Access error messages are impervious to anything and still have tiny font size. Argh. And the record number info at the bottom gets squeezed vertically to become unreadable. Doesn't Microsoft check this stuff?

Criticism of Access tends to default to it not being multi-user and online. Duh. Would you expect that of a spreadsheet program like Google Sheets or Microsoft Excel?

So why do I use Microsoft Access? Because it supports a relational database structure and query by example. Say what?

Query by example let's you create an ad hoc query based on multiple tables that connect to each other through common keys. A table contains data and is a bit like a spreadsheet in which rows are called records and columns are fields. It can also have a key field, which can contain a unique value, like Social Security number. More on this below.

I use Access for baseball research, which I then present in my blog:

radicalbaseball.blogspot.com

The database I use provides a good example. It contains tables:

People: about 20,000 major league players going back into the 1800s.

Batting: annual data for each player connected to the player via an alphanumeric key field. 110,000 records.

Pitching: same as batting except for pitching data.

Teams: more specific data about the teams.

Franchises: example, the Brooklyn Dodgers moved to Los Angeles in 1958 but all time franchise records apply going back into the 1800s. Another example: the original Washington Senators moved to Minneapolis in 1961 and renamed the team the Minnesota Twins. Similarly, the St. Louis Browns moved in 1954 and became the Baltimore Orioles.

Back to query by example. You open a blank query and drag in an "image" of tables with their fields. Let's say from my example the People and Batting tables. You drag your cursor from the PlayerID field in People to the same in Batting. Now you've got a one to many relationship. You cannot do this fundamental DBMS "join" in a spreadsheet. Now you do all sorts of wonderful things with all that data. You can also take small chunks of it and copy/paste it into a spreadsheet and do stuff that's more manageable there.

I do not know of any other end user program that does anything this powerful so easily. Microsoft Access generates SQL.

SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them. ... SQL became the de facto standard programming language for relational databases after they emerged in the late 1970s and early 1980s.

The user of Access can view and even edit the SQL that his query generates but that user has no need to do that.

I tell people that they should learn to use a spreadsheet, that it's the closest thing to programming for non techie people without learning to program. It can be used at work. But if not at work, it can be used in their own lives, sort of like learning to be an electrician, plumber, carpenter but not doing that as a profession. Such skills always come in handy. Same with knowing spreadsheets.

Access databases go beyond spreadsheets. They are not for everyone. But for single user work that exceeds the capability of a spreadsheet program, you cannot beat Access.

But I'd like to get away from my Windows 10 Microsoft Surface laptop and the stagnation that Microsoft has let impact Access. I'd like to stick with Google Docs on my Chromebook. So, we need Google to build its better version of Microsoft Access. Please.

Sunday, October 17, 2021

Optimum support email: NOT.

Error Icon

Address not found

Your message wasn't delivered to OptimumSupport@optimum.net because the address couldn't be found, or is unable to receive mail.


Error Icon

Message blocked

Your message to OptimumSupport@optimum.com has been blocked. See technical details below for more information.

Nice, huh? About all you can do is guess as to what might be a working email. There's no online form, either. Only the incredibly artificial intelligence of the little Optimum online box that cannot understand anything.

Customers are stuck calling for support on the phone and being jerked around interminably by a call prompting system that doesn't seem to know when a support person might be available. Finally, there's the announcement that "all of our support people are busy". Yeah, all one of THEM.

Sunday, September 26, 2021

Altice Optimum new 2021 box self installation: "BPE not provisioned". And pairing the remote control may be impossible.

Feedback to Altice Optimum on self installation of a box because the previous box crapped out:

I wasted a couple of hours talking to your support person who missed obvious clues. Apparently, the box needed to be provisioned. I told her repeatedly that the error message that flashed on the screen mentioned that "BPE not provisioned". Finally, I took a photo so that I could read the entire error message but still it never occurred to her. Later, I called back but this time I selected the other call prompting option for provisioning and I spoke to Mohammed, who fixed everything, although even that took another hour.

All because you failed to inform me about the need to get your box entered into your system as one that should be connected to my account. Ridiculous.


Altice One box: more problems. THURSDAY, FEBRUARY 1, 2018

Saturday, February 27, 2021

OKCupid scam: text message asking for driver's license and Social Security number.

Actual message, cleaned up a bit, including hiding the last four digits of her phone number:

Update after posting: her phone number is no longer in service, so there is no need to hide it: (646) 564-8210.

She sent the photo, which was not one of those she had posted in her now deleted OKCupid profile.

Hi Joe. THIS IS aGNES
Message by ‪(646) 564-nnnn:

AGNES, Friday, February 26 2021, 9:05 PM











Hi, Agnes.
Fri 9:06 PM
May I call now?

Message by ‪(646) 564-nnnn:

I want to be sure you real. So many fake profiles on OKC.

I would like to see your ID before further communication between us 9:16 PM

Message by Joe: I have an ID? 9:17 PM

Message by ‪(646) 564-nnnn: Your driver's license and I will do the same 9:18 PM

Message by Joe: Video call? 9:18 PM

Message by ‪(646) 564-nnnn: I will do that after confirming you are real 9:18 PM

Message by Joe: We could have a conversation. It will convince you I'm not a Romanian guy in his underwear trying to pull a scam. 9:19 PM

Message by Joe: I'm getting the license. 9:20 PM

Photo of driver's license

Message by ‪(646) 564-nnnn: When was the picture taken?

Message by Joe: How the heck do I know?
Do a video call or forget it. 9:26 PM

Message by ‪(646) 564-nnnn: I'm sorry for asking too many questions. I was a victim of online scam

Message by ‪(646) 564-nnnn: I'm asking when the pic in the license taken because it is a bit different 9:27 PM

Message by Joe: DMV takes terrible photos. 9:28 PM

Message by ‪(646) 564-nnnn: What is your SSN? Mine is 050 134 9920 9:29 PM

Message by Joe: Forget it. 9:30 PM

Message by ‪(646) 564-nnnn: Hmmmm 9:31 PM

Message by Joe: You scammed me into sending my license. That's a first. 9:31 PM

Message by ‪(646) 564-nnnn: I'm not scamming you here. You do not understand the trauman I went through when A man I met online took over $240.000 dollars from me 9:32 PM

Note: Her money uses a period instead of a comma, suggesting European use. And she uses both $ and "dollars".

Message by Joe: Send your driver's license 9:32 PM

Message by ‪(646) 564-nnnn: He deceived me of marriage and loan the money from me for business, 9:32 PM

Message by ‪(646) 564-nnn: I will send to you but the driver's license with the pic of you don't look the same 9:33 PM

Message by ‪(646) 564-nnnn: If you can't let me confirm your SSN to be sure you real then I'm not for you 9:34 PM

Message by Joe: Your (OKCupid) profile disappeared. Just when I was about to report you. Enjoy the weather in Romania. 9:34 PM

Message by ‪(646) 564-nnnn: I keep my profile hidden because of too many fake profiles sending me messages 9:35 PM

Message by ‪(646) 564-nnnn‬: Do you still want to video chat or not?, Friday, February 26 2021, 10:00 PM
______________________________