He believes in lifelong learning and has obtained a Specialist Diploma in Business Intelligence and Data Analytic in 2017. He has also created various MS Excel tools that linked with ERP to create What-If scenario to solve problem and provide optimum solution. Stephen is an ardent and enthusiastic user of MS Excel not only to simplify reporting for KPI but also as a tool for problem solving, decision making and cost optimization. He trains (ACTA certified), lecture and does adhoc consultancy project and had worked a philanthropic organization and currently Unilever Indonesia working on Supply Chain and Operations optimization after his stint with a Norwegian regional AP office working on ERP project. He is awarded Life Time Certification in Supply Management from ISM, USA and the IE study award with Singapore Management University for Global Supply Chain Management. Stephen also has an MBA from Macquarie University as well as a Certified Diploma in Accounting & Finance (ACCA, UK). He graduated with a Bachelor of Business Administration with Distinction from RMIT University. His experience hails from his career at senior management level at MNC, SME and Non-Profit organisation with industries ranging from Electronic, Chemical, Healthcare, and Offshore & Marine including Oil & Gas industries.
Microsoft access database training professional#
Stephen Tan is a Supply Chain professional and practitioner with extensive experiences in End to End Supply Chain, Operations and Supply Management.
Microsoft access database training password#
Protecting the database with a password.Splitting a database into front and back ends.Printing the blueprint of your database with the Database Documenter.Organizing the Navigation pane with custom groups.Setting up labels and mail merge documents in Word.Getting a different look with crosstab queries.Creating flexible queries with parameter requests.Filtering with mathematical comparisons.Leveraging multiple criteria with AND and OR statements.Creating queries with the Simple Query Wizard.Establishing relationships and maintaining referential integrity.Creating a table and setting data types.Understanding table structure and relationships.Launching Access and the backstage screen.Note the minimal class size to start a class is 3 Pax. Note the venue of the training is subject to changes due to class size and availability of the classroom. If the course is cancelled, we will refund 100% to participants. We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. This branch is only for robotics courses and some selected courses. Bukit Timah Sub Branch: 170 Upper Bukit Timah Road #05-23 Bukit Timah Shopping Centre Singapore 588179. This is our main training center for most courses. Venue: Woodlands Main Branch:12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715.If you don't have laptop, we can provide spare laptop for training use. Additional Note: Please bring your own laptop for hands-on training.