There are a number of sections that you will need to adjust in the admin panel to achieve what you wish to achieve
The first to consider is if you want Autoapproval for albums, If No, the settings needed to change are found:
> Settings > Advanced Settings > Variables > Autoapproval for albums > Untick this box and Save the settings.
Next, you will need to go through each of the Modules that you wish to moderate manually.
Photos + Videos Modules are provided in this example
> Modules > Photos or Videos > Settings Tab > Enable auto-activation for files > Untick this box and Save the settings.
Same for
> Autoapprove categories of files
Similar for other Modules like Sites, Sounds, etc.
Also for Profile moderation consider unticking the following depending on exactly what you wish to achieve:
> Settings > Moderation Settings > Automatic profile activation after joining > Untick this box and Save the settings.
> Settings > Moderation Settings > Do not change profile status after editing profile information > Untick this box and Save the settings.
> Settings > Moderation Settings > Automatic profile confirmation without Confirmation Email > Untick this box and Save the settings.
I hope that this helps you achieve what you need to. Good Luck!