Create 2 networks.
As it is, your modem is effectively a gateway (to the internet). Whereas your WiFi is a gateway
to the gateway
(modem/router). If you create 2 different networks, you will have much greater control over your network(s). Thereby allowing you to choose 1 network as the connection to the Internet, while defining the other as a Local network, that can provide Printer sharing, File sharing, etc...
Then instruct Windows to connect to both of them.
It's as simple as that.
EXAMPLE
NOTE these numbers will not (necessarily) work on your system. As it likely has other numbers assigned.
Imaginary network(s)
Router (gateway to the internet)
Internet side has ip: 4.4.4.10
Router DHCP pool has 254 addresses on the network 192.168.0.1
with a netmask of 255.255.255.0
The Router is a Gateway, and understands how to direct (assigned) IPs from its DHCP pool to the internet IP (4.4.4.10
)
Wifi (connected to Router/gateway)
WiFi has the same number of IPs in its DHCP pool on the network 192.168.1.1
with a netmask of 255.255.255.0
You instruct Windows to connect to both networks. Windows will discover automatically which route makes the internet available. But will still recognize that the other network exists, and is available.
Once you've made these connection(s) in Windows "Network Preferences".
Windows will remember them, and you can simply Right-click, and Connect, or Disconnect as needed / desired. Which "Forces" the connection to whichever you choose.
If you want to enjoy File sharing, Local Printers, and Multimedia files. Ensure that you connect all of those facilities to your WiFi. Which will then comprise your "Local Network".