First time Mikrotik user, absolutely lost

[DuctView]

@Enginebuilder

I know damn near nothing about networking. I've been enlisted to help my friends install/setup a home network system, as indicated in the network diagram attached. I don't even know where to begin, when it comes to configuring the equipment that they've got, and neither do they.

You have a really tough one here

@erlinden

Your requirements are not far from default config.

Let’s be honest here. For OP’s starting point, this is an incredible leap from a default config and a huge learning curve

@Enginebuilder

Some features that they'd like to have, which I believe that this setup is capable of: The three PC's should be able to share files. The three PC's should be able to access the video recorder. The video recorder should not be able to access the internet. The two wireless access points, the living room TV & game system should be able to access the internet, but nothing else.

I would make the following comments on the spec:

1. For the computers to share files, use a NAS network file server. If you are clever, then you can put the user profiles on the NAS and any user will be able to log on and have their own profile consistently at any computer
2. re “Wireless Access Points should only have access to the internet for a Guest network.” But what about a House network for tablets to have access to files and printers? Or for laptops to have access to files, printers and to the user profiles for the desktops?
3. Printers. Local USB printers are such a waste. A heap of paper and a set of consumables near each computer. Better to get network capable printers - a laser and a photoquality printer?

@erlinden

There is this great topic that describes VLAN's very thoroughly, I can recommend you readin it:
Using RouterOS to VLAN your network - MikroTik

That document should come with a big health warning. Undoubtedly it is correct and looks really good to people who are familiar with vLANs. It is beginning to look better to me now after 2 vLANs. But it confused the hell out of me when I started there, so much so, that what I have learned about vLANs I mostly have had to go elsewhere to learn. The 2 major deficiencies of the document are from my perspective:

1. There is not enough emphasis laid on the fact that a vLAN is a Single Broadcast Domain and that in the preliminary analysis you have to make decisions of what will work together as a Single Broadcast Domain. Thus on Guest Wireless networks, every example out there configures the House network as a vLAN when this is usually completely unnecessary for a beginner or small home network [ - although it may be required here]
2. There is a good description of the various types of port, ie Trunk, Hybrid and Access, plus the document is quite strong on showing their use. The configuration examples even include the settings they need. But given the Mikrotik way of doing things, the setup for a port is distributed across several different groups of settings, each group containing various port combinations. What is required is definitive examples of all the required settings for each of the port types.

So now back to the OP. It will not be a lot of work to set all of this up for a capable network tech. But for a beginner, the learning curve is more than huge. You need to break this up into smaller manageable chunks to even have a hope of implementing this and the expectation that you will come to a hiatus of understanding several times over. Where do you want to start?