My Development Computer 2017

Here are the essential tools I put in my seven years old personal laptop for my application development during evening and weekend as of July 2017. Most of them are open source and free. My other development machine at work is much better and powerful than this (Intel i7 CPU and 16GB RAM).

1. Mozilla Firefox
2. Google Chrome
3. Notepad++ is a free  source code text editor.
4. WinMerge for compare and merge files.
5. 7-Zip (Compress and decompress files)
6. KeePass the free, open source, light-weight and easy-to-use password manager. I don't need to remember password for each web sites or applications.
7. Python 3.6  This programming language is powerful and fast. According to TIOBE Index for July 2017, Python is one of top five popular programming languages. 
8. LibreOffice is a powerful free, open source and cross platform office suite. I used it on other PC Windows, my MacBook Pro, and Ubuntu Linux.
9. SQL Server 2016 SP1 Developer Edition SQL Server Developer Edition is a free download for Visual Studio Dev Essentials members and for development and testing only, and not for production environments or for use with production data per Microsoft SQL Server blog
10. Microsoft Visual Studio Community 2017 (Free version for an individual developer or small business, not for corporate)
11. Microsoft Visual Studio Code. This is free, open source, and runs everywhere. It loaded faster than Visual Studio.
12. Git for Windows. It's a free and open source distributed version control system.
13. Node.js® is a JavaScript runtime built on Chrome's V8 JavaScript engine.
14. VLC is a free and open source cross-platform multimedia player and framework that plays most multimedia files as well as DVDs, Audio CDs, VCDs, and various streaming protocols.
15. Greenshot is the most awesome tool for making screenshots you can get on your Windows PC. It's is better than built-in application Snipping Tools. I can blackout or obscure portion of screen easily.
16. FileZilla® Open source FTP software.

In addition to C# and Microsoft SQL Server, I will spend my spare time to work on Python and Node.js.

My Notes on Microsoft Access

How to open Microsoft Access file in design mode?
Double-clicking the .mdb file while holding the shift key

How to show Navigation Pane?
Press F11
or
File -> Options -> Current Database -> Check the check box "Display Navigation Pane"

How to show these tabs: Create, External data, and Database Tools?
File -> Options -> Current Database -> Check the check box 'Allow Full Menus' in 'Ribbon and Toolbar Options' area

How to show the item menu when right click on it on Navigation Pane?
File -> Option -> Current Database ->  Check both "Allow Default Shortcut Menus" and "Allow Built-in Toolbars"

How to change the View?
On Ribbon select the Home tab and View
or
click View on Quick Access toolbar

How to switch between codes and form?
Press ALT F11

Link table manager:
Use file DSN file
http://office.microsoft.com/en-us/access-help/use-the-upsizing-wizard-HP005273009.aspx

How do I view the SQL for EXISTING queries and edit it in Access?
http://www.gcflearnfree.org/access2013
http://office.microsoft.com/en-us/access-help/introduction-to-queries-HA102749599.aspx
http://office.microsoft.com/en-us/access-help/view-modify-or-copy-a-query-s-sql-statement-mdb-HP005188056.aspx

How to create new file DSN?
Control Panel -> System and Security -> Administrative Tools -> Data Sources (ODBC)
Select "File DSN" and click on "Add" button
Select "SQL Server" on "Create New Data Source" and click "Finish" button
Continue to specify SQL Server and database to connect

Office 2013 developer training (Module 21)
http://dev.office.com/training

Unable to view hidden objects in Microsoft Access 2007
http://answers.microsoft.com/en-us/office/forum/office_2007-access/unable-to-view-hidden-objects-in-microsoft-access/

How to toggle between tabs in Access
http://answers.microsoft.com/en-us/office/forum/office_2007-access/how-to-toggle-between-tabs-in-access/c955f3e0-4ad0-46ca-bbfd-0a0713537c42
Ctrl+F6 will switch between all open tabs (or windows) in the database, regardless of type.

How to view documents in tab
Change Document Windows Option to "Tab Documents" using File -> Privacy Options

Sub-Forms and Sub-Reports
http://www.functionx.com/access/topics/sfsr.htm