Windows 10: Microsoft Domain Offline - query.prod.cms.rt.microsoft.com

Hi, We are having issues accessing one of Microsoft's Domains. It's been down for a while now. For example, we are trying to download the "Microsoft Remote Desktop WebRTC Redirector Service" version: 1.54.2407.260001 without using the latest link as we want a specific version. All the individual version links do not work on: https://learn.microsoft.com/en-us/azure/virtual-desktop/whats-new-webrtcInspecting the link, it goes here but when you visit the site you get a DNS failed issue. https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RW1o9wmLooks like the link needs updating or domain n

:)

 

MS ACCESS: A7 Building Queries in Microsoft Access

Hello, I'm having problems with creating a database from this questions. I was able to do get to a point but won't show or missing something. Can anyone help on these questions:

2. Display the CustomerNum, CustomerName, OwnerName, Phone, RestaurantType, and FirstContact of customers who were first contacted in 1992 and 1993. The list should be sorted by the FirstContact date (with the most recent at the top) within RestaurantType in ascending order.

3. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

4. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

5. Show the CustomerNum, OwnerName, Kitchen Area, InvoiceAmt, and ZipCode for customers who are located in ZipCodes starting with 43 and have InvoiceAmt between $1,200 and $2,000. The list should be sorted by CustomerNum.


Attached is the File on a zip as access file is not accepted.
The queries I'm working from that I made for some of these are Customer Query, Restaurant Type, Order Query 1.
Thanks this will be a lot of help as I've been trying to do this for the last 3 days.

 

Watch Microsoft Surface hardware event on October 12, 2022

Watch live to see what’s next 10am ET on October 12, 2022 Read more: https://www.microsoft.com/en-us/event

 

Microsoft enables offline play for Windows 10 games

Most Windows 10 games will support offline play, but you'll have to work at it.





"Larry Hryb, the man known to the world as Major Nelson, announced on Twittertoday that Microsoft has "made some backend updates to improve your experience playing @Windows 10 games offline." Basically, if you're going to be somewhere that lacks online coverage—on a submarine, for instance—it will still be possible to play your games. But there are some restrictions.

"Most games available in the Store on your Windows 10 device support offline play, but check the details of the game to make sure yours is supported by searching for your game at http://www.xbox.com," the Xbox support site says. "Most games with a campaign mode will be playable offline, but games with network co-op or multiplayer features will not work while you’re offline. While playing offline, some features, such as the ability to purchase additional items from the Windows Store, will not be available. Additionally, any leaderboards will be unavailable while you're offline."

Obviously, online features like buying stuff from in-game stores won't be available when you're offline, but the bit about "games with network co-op or multplayer features" not working while offline really isn't clear. We tested with Gears of War 4 and confirmed that the offline features like campaign and LAN multiplayer worked just fine when disconnected.

There are more caveats, though. You're limited to just one "designated offline device" at a time, and you can only change your designated offline device three times per year. Switching into offline mode isn't all that easy, either. First, you'll need to set your designated offline device:

• Make sure that you’re online.
• Check that your device has the latest Windows updates: Go to Start,Settings, Update and security, and then Windows Update and see if any relevant updates are available.
• Open the Store. You’ll be prompted to sign in if you haven’t already.
• Select the Me icon (this is your profile picture).
• Select Settings, and then under Offline Permissions, make sure that the toggle is set to On.

After that, you'll have to "prepare" your games by launching each one that you want to play offline while you're still online, and logging into your Xbox Live account. This is a bit like launching Steam into Offline mode while you still have an internet connection... but you'll have to prepare each individual Xbox game this way before going offline.

Once you've logged into the game while you're online, you can exit at any time and you'll be set. Of course, if you change your mind and want to play something you haven't properly prepared, you're out of luck.

The upside is that this only affects Windows 10 games, but it still seems wildly complicated and restrictive to me. Worse, while improved functionality is always welcome, I can't see how this does anything but beg for unflattering comparisons with Steam: When I want to play my Steam games offline, I set Steam offline, restart it, and I'm on my way—and I can do it as often as I want. Microsoft's implementation of offline play is an improvement, but only because it wasn't available at all previously. As a step toward becoming more competitive with Steam, though, it falls woefully short."

Microsoft enables offline play for Windows 10 games