This applies to SharePoint 2007.
Learn how to route a document through the Approval Workflow process. Configure the workflow so that once it is completed successfully, the Content Approval column is automatically marked as Approved.
Watch the video on Content Approval and Publishing with Approval Workflow that explains this functionality.
This video is available for free until Aug 6, 2010.