You'll probably find that Avast has installed a firewall that has blocked your Wi-Fi adapter. I'm not familiar with the Avast product, but open the control centre, whatever it's called, and disable the firewall. If you get you access back then this will have proven that it's the problem. You then need to decide how you want it to work.

Also, connecting to the same Access point via cable AND wi-fi is not a great idea. You will get conflicts and you may even break connections so try without the cable connected.

Of course, something else may have disabled things, but this is where I'd start.

--=-- My credo: If it's worth doing, it's worth overdoing - just ask my missus, she'll tell ya laugh --=--
You're only paranoid if you're wrong!