How do we work with MS Access to access SQL Server Database?

 I will show you in four simple steps.

1. Create a new MS Access database file

2.    You need to provide a name instead of accepting the default.

3.    Click the Menu item 'External Data' 

4.    Go to New Data Source as shown and choose SQL Server.

Follow the red line and choose From SQL Server

Which of Microsoft's SQL Tools provide a Graphical User Interface?

Some people like GUIs more than scripting languages. They can still manage to work with SQL Servers.

Databases reside in the database servers. These servers may reside on your laptops, computers running with various operating systems such as Windows, Linux, and macOS. These servers may run in the cloud such as Azure. The tools, however, may not reside on the same platforms but allows you to connect to the various above-mentioned servers.

In brief, the tools are the following:

1. Azure Data Studio uses the operating systems, Windows, macOS, and Linux

This tool can run on-demand queries and save data as text, JSON, or Exel. It has a lightweight editor

2. SQL Server Management Studio (SSMS)

It is a full-featured GUI as well as it can run TSQL statements. It has tons of features.

It is a one-stop database management tool.

It can connect to the cloud, Azure SQL Database, Azure Synapse Analytics, etc.

Developers and DBMs of all skill levels can use this tool.

3. SQL Server Data Tools(SSDT) 

Using this you can build relational databases, Azure SQL databases, Analytical services, integration services, reporting services, etc

4. Visual Studio Code

Using the "mssql extension" for Visual Studio Code you can connect to SQL Servers

You can do scripting with a lightweight editor after connecting to SQL Server in Visual Studio.

You can find extensive references to complete articles on the following sister blogs:

http://hodentek.blogspot.com

http://hodentekMSSS.blogspot.com

More on GUI tools here:

https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15

How do you open backdoor in Venza 2021 Limited?

 You can open the Venza 2021 Limited's backdoor in a number of ways including from inside the car. The power switch should be on.

The backdoor can be opened and closed in a number of ways. In all cases make sure your fingers are not holding on to the opening door you may get your fingers damaged while closing).

1. Using the door opening switch in the Remote Key.  You need not unlock the car but should have the  Remote key on your person.

 

2. Even if the car is locked (but you should be having the key on your person) you can open the backdoor by

   Sweeping your feet standing in the center of the car about a foot from the door. You will see the side mirrors opening and you get an audible signal that the door will open. stand away from the door.

3. Once the door is open, you can see controls that can be used to close the door or lock it in position to adjust to the height of the user.

4. Directly under the logo behind the car there are two controls, to open and close. You may need to feel them as they are not seen looking directly. This was photographed with the door open.

5. When the Power is on you can open the door from inside the car using control shown. You need to make sure that there are no obstructions or people standing nearby as the backdoor would swing-out. Probably, it is better to use this method only in an emergency and make sure you use the 360 -degree view system.

How do you adjust the Head Up Display (HUD) in your Toyota Venza?

 The HUD display is only available in Toyota Venza Limited edition.

If the HUD has been set up, the display is on whenever the Power is ON.


The height of the display and its brightness can be controlled. The height may need adjustment depending on the seat position.

The following screen shots show how this may be adjusted:


Step 1: You need to get to the "Settings" on the large display as shown. When you press "i" (left bottom shown) the "Settings" control will be available. 

The "Settings" gives access to the "Meter Control Switches" These are available on the left side of the steering wheel.

The Left-Right < > control switches the various functions such as 'HUD". The "UP" and "DOWN" allows other selections. The return symbol above the 'Phone" icon returns to previous.

When "Settings" is chosen this is what you will see on the "Instrument Cluster" as shown.

Step 2: Using the left (<) and right (>) controls you can move on the 4 functionalities shown. There are more than four functionalities. Pressing the right control after the rightmost marked PCTA gets you to the next set of functionalities.

Step 3: When you come to 'HUD" as shown above you can turn on or off the HUD control. If you HOLD down on "OK" in the "Meter-control" on the steering wheel, you get the sub-menu under "HUD" as shown.

Step 4: Now you can work on left (<) and right (>) controls to adjust brightness of the display and using the top and down arrows you can raise or lower the HUD. While making these adjustments you should be seeing the HUD on the wind screen.

After the adjustment you can get back to "Settings" and back to Info.

The HUD display is shown here. The outside light is strong when this photo is taken but you can see the HUD.

This next one is cropped from the above.

You can see the 'lanes' and it is in 'Parked (P)" position

Can you create a query in MS Access using a SQL Statement?

Microsoft Access is designed such that even if you do not know SQL or SQL syntax you could still use the application. As a consequence, there is no obvious starting point to write a SQL Statement and execute it. However, it does allow you to write a SQL Statement, save the query and execute it.

Open access application. I have just one simple table 'BOOK1'.

In the 'Queries' tab of Create click on Query Design to open a tabbed page 'Query 1" as shown.

Query 1 has two panes. The top one is empty and it is here you can write a SQL Statement and the bottom pane is where you can compose a query using visual elements.

Right-click in the empty top pane to show this drop-down.

Click on 'SQL View'. This view is not the same as 'View' in SQL Server. This opens a text editor where you can write a query. Note that it has just the 'SELECT'. It expects you to write a "SELECT" statement.

Note that there is a Table 1 called 'Book1' shown here.

Now I write a SQL query against this table.

SELECT ID, Field2 

From Book1

Here is the statement in the SQL View's editor pane.

Now save the query, Query1. You need to click on the tab to save as shown.

You can save it with a different name which is usually recommended. I saved it as BookQry as shown.

Now double click on BookQry on the left to open the query to show the result.

How well does the Stock data type work in MS Excel?

 Microsoft introduced the Stock datatype previously. It does work with a few minor points of irritation. Still, I recommend this program for retail, individual investors with the usual warning that you do so at your own risk.

The problems I have noticed are the following:

1. New IPOs take considerable time to appear, sometimes weeks

2. Suddenly you start seeing the message that some of the items could not be updated, etc.

3. Recently, the Excel program is getting sluggish (not all the time but enough to cause discomfort) and the controls for FILE, Data, View, etc. get slowed down to the extent, you rapidly lose heart and interest.

4. Sometimes the stock data type does not get updated even after using the 'Refresh' control. Only one submenu item gets enabled in the 'Refresh, button.

5. Interestingly if you create a new instance of the stock in a different cell, it gets updated.

The program should work without these hitches if it has to be taken seriously.

This is the version of Office365/Excel I am using on Windows 10 (x64) with the most current update:




Here are some pictures of misbehaving Excel sheets:

Obviously, the feedback has been sent a couple of times.


Here are some links if you are not familiar with the STOCK data type in Excel.

How do you use the stock data type in MS Excel?

https://hodentekhelp.blogspot.com/2020/05/how-do-you-use-stock-data-type-in-ms.html


Does Stock Analysis with Microsoft Excel Work?

https://hodentekhelp.blogspot.com/2016/03/does-stock-analysis-with-microsoft.html


How do you extract financial data from the web using MS Excel?

https://hodentekhelp.blogspot.com/2020/06/how-do-you-extract-financial-data-from.html


How do you create a moving average using MS Excel?

https://hodentekhelp.blogspot.com/2017/10/how-do-you-create-moving-average-using.html




Good luck!

How many COVID-19 Virus variants have been identified?

 A number of COVID-19 variants have appeared, first time in many parts of the world but seems to be spreading to other countries. Increased travel and relaxing will only promote spreading virus variants and controlling the virus spread will be difficult. 

Here is an image of collated information from various sources (obviously incomplete) across the Internet.

 

Here is a list of variants identified by MAKO laboratories.

Here are some links that you may be interested in (the titles are in bold):

 

Covid-19: The E484K mutation and the risks it poses

https://www.bmj.com/content/372/bmj.n359

Covid-19: Novavax vaccine efficacy is 86% against UK variant and 60% against South African variant

https://www.bmj.com/content/372/bmj.n296

Scientists In US' Oregon Find B.1.1.7 Variant With 'E484K', Mutation Also Found In India

https://www.republicworld.com/world-news/rest-of-the-world-news/scientists-in-us-oregon-find-b-dot-11-dot-7-variant-with-e484k-mutation-also-found-in-india.html

Another New Coronavirus Variant Now Detected In 13 Countries (B.1.125)

https://www.republicworld.com/world-news/global-event-news/another-new-coronavirus-variant-now-detected-in-13-countries.html