> ## Content Index > Fetch the complete content index at: https://nolongerset.com/llms.txt > Use this file to discover other available public pages before exploring further. # Week in Review: May 21, 2022 - URL: https://nolongerset.com/week-in-review-2022-05-21/ - Published: 2022-05-22T02:06:04.000Z - Updated: 2026-05-08T12:57:28.000Z - Description: Highlights include a Microsoft Access Roadmap update, sample code for trig functions, and a discussion about preserving Access tips of yore. - Author: Mike Wolfe - Tags: Week in Review, #Import 2026-05-20 02:59 The *Week in Review* is the best way to keep up with the latest and greatest from the world of Microsoft Access. Every Saturday, I publish links from around the web. If you find or publish content that you think should be included, email me at mike at nolongerset dot com, tag me on Twitter [@nolongerset](https://twitter.com/NoLongerSet), or tag me on LinkedIn [Mike Wolfe](https://www.linkedin.com/in/mwolfe02/). I retain full editorial control of what appears here. There are no paid or affiliate links, only high quality Microsoft Access content. Click the "[Subscribe](https://nolongerset.com/#/portal/signup)" button above to receive this weekly update–along with links to my other daily articles–in your inbox every Sunday morning. --- ## Just Published This section includes videos, articles, and interesting discussions from the past 7 days. #### Articles - [*Connecting Power BI Desktop To An Unencrypted Access Database*](https://www.devhut.net/connecting-power-bi-desktop-to-an-unencrypted-access-database/), by Daniel Pineault - [*Microsoft Access Roadmap Update*](https://www.devhut.net/microsoft-access-roadmap-update/), by Daniel Pineault - *[Should you Create Accounting Software Using MS Access?](https://accessexperts.com/blog/2022/05/20/should-you-create-accounting-software-using-ms-access/)*, by IT Impact - *[Missing Trigonometric Functions](https://isladogs.co.uk/trig-functions/index.html)*, by Colin Riddington (aka Isladogs) #### Discussions - [Status of DatabaseAnswers.org????](https://www.access-programmers.co.uk/forums/threads/status-of-databaseanswers-org.322983/) *A conversation about preserving Access content on the web as former Access MVPs and other contributors retire* - [Hi, Can anyone guide me how to make an accounting database?](https://www.access-programmers.co.uk/forums/threads/hi-can-anyone-guide-me-how-to-make-an-accounting-database.323223/) *tl;dr: Better to purchase off the shelf accounting software (e.g., Quickbooks) and add customizations as needed* - [Remove whitespace from string and start next word with upper case](https://stackoverflow.com/q/72198091/154439) #### Videos - **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg)) \- [Filter as You Type in Access](https://www.youtube.com/watch?v=ad%5FrxbHRNsA) (49:40) - *Plus Custom Navigation Pane*, *presented by Kim Young* - **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ)) \- [AppLauncher for Access](https://www.youtube.com/watch?v=SHH6NlEKg9s) (1:08:15) - *A New Access Front-End Deployment Service, presented by Kevin Bell* - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) \- [Gift Certificates](https://www.youtube.com/watch?v=5o6uQz1S2R4) (36:26): *Build a Database for Creating, Printing, and Tracking Gift Certificates in Microsoft Access* \- [Rounding](https://www.youtube.com/watch?v=5%5F8XXioD5Ks) (17:44): *Rounding Numbers in Microsoft Access. Understanding Int, Fix, Round, and Banker's Rounding* \- [Order Discount](https://www.youtube.com/watch?v=Fu6DwbU8smw) (18:00): *Add a Discount Percentage Rate to your Order Form and Invoice in Microsoft Access* \- [Referential Integrity](https://www.youtube.com/watch?v=cuni2mmLPl8) (11:53): *How to Set Up Referential Integrity in Microsoft Access. Prevent Deletion of Parent Records.* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - *[Overview of XEvent Profiler in SQL Server Management Studio](https://www.mssqltips.com/sqlservertip/5176/overview-of-xevent-profiler-in-sql-server-management-studio/)*, by Rajendra Gupta at mssqltips.com - [A great breakdown of the differences between OLEDB and ODBC in the context of Access, plus a nice tip for how to use File DSNs to create DSN-less linked table connections](https://social.msdn.microsoft.com/Forums/sharepoint/en-US/b278b04b-7898-4eaf-8ace-8315f4921de6/dsnless-connection-to-sql-server-for-linked-tables-in-access-20162019-using-microsoft-ole-db#2e094334-d764-4e1c-8b92-c4f9014d1ed3), by former Access MVP Albert Kallal --- ## Upcoming Access User Group Events NOTE: Only English-language user group meetings with scheduled guest speakers or topics are listed. For a complete list of upcoming events, visit the [Access User Group event calendar](https://accessusergroups.org/calendar/). - [June 1, 2022](https://accessusergroups.org/europe/event/access-europe-2022-06-01/): **Alan Cossey** \- Standard Module Object Generation - [June 2, 2022](https://accessusergroups.org/pacific/event/257-2022-06-02/): **Crystal Long** \- Drawing the Periodic Table of Chemical Elements with an Access Report - [June 16, 2022](https://www.daaug.org/Presentations/Details/238): **Karl Donaubauer** \- Design Patterns with Access - [July 6, 2022](https://accessusergroups.org/europe/event/access-europe-2022-07-06/): **Mike Wolfe** \- Building Ribbon Interfaces in Code - [August 3, 2022](https://accessusergroups.org/europe/event/access-europe-2022-08-03/): **Peter Cole** \- Automating 32-bit to 64-bit VBA Conversion - [September 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-09-07/): **Colin Riddington** \- Optimizing Queries and the Use of JETSHOWPLAN - [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Graphical Interfaces in Access - [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers - [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Alexsander Wojtasz** \- Interactive Gantt Chart Scheduler in Access --- ## Access Roadmap Listed below is a snapshot of the [official Access Roadmap](https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access). - `MAR 2022`: New Microsoft Graph Data Connector - `MAY 2022`: Access Dataverse Connector - `SEP 2022`:New (Modern) Web Browser Control (to support Chromium Edge) - `SEP 2022`: Enabling Large Address Aware (LAA) for 32-Bit Access - `OCT 2022`: Inconsistent Database Error Fix - `DEC 2022`: SQL Monaco Editor There were a couple of changes from last week: - "Monster Bug" fix changed from `MAY 2022` to `OCT 2022` - Dataverse connector changed from `MAR 2022` to `MAY 2022`