Course Details
Topic 1. Getting Started
- Key database concepts
- Launching Access and the backstage screen
- Creating the database file
- Understanding the Trust Center
- Digging into Ribbon tabs
- Using the Navigation pane
- Using the Tell Me feature
- Using the Quick Access Toolbar
- Signing in to a Microsoft account
- Making backups
- Accessing Access help
Topic 2. Creating Tables
- Understanding table structure and relationships
- Creating a table and setting data types
- Entering data
- Understanding primary and foreign keys
- Importing tables
Topic 3. Setting Field Properties
- Establishing relationships and maintaining referential integrity
- Editing table structure in Design view
- Controlling input with masks
- Setting the default value
- Establishing validation rules
- Creating lookup fields
- Setting additional field properties
Topic 4. Organizing Records
- Formatting columns
- Sorting table data
- Filtering table data
- Searching and replacing values
Topic 5. Using Queries
- Understanding queries
- Creating queries with the Simple Query Wizard
- Building queries in Design view
- Establishing constraints with criteria
- Specifying criteria with wildcards
- Leveraging multiple criteria with AND and OR statements
- Filtering with mathematical comparisons
- Creating flexible queries with parameter requests
- Building expressions
- Obtaining summary statistics
Topic 6. Working with Specialty Queries
- Using update queries
- Using make table queries
- Finding unmatched records
- Using delete queries
- Using append queries
- Creating a union query in SQL view
- Getting a different look with crosstab queries
Topic 7. Creating Forms
- Understanding the role of forms
- Generating forms from tables
- Adjusting form elements in Layout view
- Using the Form Wizard
Topic 8. Designing Forms
- Creating forms in Design view
- Exploring the form property sheet
- Setting data sources
- Adding components with form controls
- Understanding input boxes
- Record navigation
- Adding buttons
- Assigning a tab order
- Checking out the More Forms options
- Creating a navigation form
Topic 9. Creating Reports
- Introducing reports
- Using the Report Wizard
- Creating a report in Design view
- Editing a report in Layout view
- Grouping and sorting records
- Creating calculated totals
- Applying conditional formatting rules
- Creating labels
- Adjusting print settings
Topic 10. Working with Macros (Optional)
- Creating macros
- Embedding macros into buttons
- Attaching data macros to tables
- Launching macros at startup
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 21-65 years old
Minimum Software/Hardware Requirement
Software:
Sign up for free Microsoft Account
Hardware: Windows and Mac Laptops
SSG Training Grant
SSG TG is $15 per pax. Net fee after SSG TG is $309.82. Absentee Payroll is not eligible.
Steps to Apply Skills Future Claim
- The staff will send you an invoice with the fee breakdown.
- Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
- Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
- Upload your invoice and click ‘Submit’
Get Additional Course Fee Support Up to $500 under UTAP
The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).
For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)
Steps to Apply UTAP
- Log in to your U Portal account to submit your UTAP application upon completion of the course.
Note
- SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
- All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
- An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount will be paid to training provider first and claimed after end of class by learner.
Job Roles
- Database Administrators
- Data Analysts/li>
- Project Managers
Trainers
Chia Wei Kang is a MOE registered instructor. He has over 6 years of development experience in both Android and Web applications. He is a passionate Software Engineer with a vast array of knowledge in many different frontend and backend languages, and databases. His specialization is in the field of Software Engineering and Database. Wei Kang is currently working on his startup, Geboto, which provides chatbot solutions for Hotel and F&B.
Stephen Tan is a Supply Chain professional and practitioner with extensive experiences in End to End Supply Chain, Operations and Supply Management. 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. He graduated with a Bachelor of Business Administration with Distinction from RMIT University. Stephen also has an MBA from Macquarie University as well as a Certified Diploma in Accounting & Finance (ACCA, UK). 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.
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.
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 has also created various MS Excel tools that linked with ERP to create What-If scenario to solve problem and provide optimum solution. He believes in lifelong learning and has obtained a Specialist Diploma in Business Intelligence and Data Analytic in 2017. He desires to extend the Data Visualization capability of MS Excel, deepening his knowledge, simplifying it and sharing and teaching his knowledge to professional as well as layman.
He had worked previously with HP, CMB as Regional Procurement and handles End to End Supply Chain, Operations, Logistics with top European Flavor and Fragrance companies: Dragoco, Symrise. He also does IT projects, ERP implementations with various systems ranging from RenCS, SAP, IFS and as well as smaller SAGE-ACCPAC supply module systems which automates as well as optimize resources.
He has also developed business analytic system for Supply Chain, Order management, On-Time Delivery and Inventory Control system using combination of Excel, MS Access and other IT tools to leverage data from IT and ERP systems.
Tint is currently a PhD student studying at Wee Kim Wee School of Communication and Information (WKWSCI) in Nanyang Technological University (NTU). She has a mixed academic background with undergraduate and postgraduate degrees in information science and computer science from Nanyang Technological University (NTU) and University of Computer Studies Yangon (UCSY). She also has Specialist Diploma in Data Mining and Statistical Analysis from Singapore Polytechnic.
As an ACTA certified trainer, Tint has been conducting WSQ courses offered by Library Association of Singapore (LAS) since 2010. As an academic librarian, she has also more than ten years of experience in conducting workshops for undergraduate and postgraduate students in NTU and SMU in the areas of information literacy and research skills.
Peter Goh is the Technology Evangelist at Disruptive Digital, a full-service digital agency based in Singapore, offering innovative & effective web and native mobile application development. He specializes in bleeding edge software development and have more than 10 years' experience in developing customized applications for desktop, web and mobile platforms. He has extensive domain knowledge in .Net and Java programming, iOS development and has helped many to create e-commerce web sites on Amazon AWS and Microsoft Azure
Sundari has more than 10 years of experience in Software Training and Development. She initiated her career as a Trainer and worked in various companies, developing and nurturing client relationships. She is passionate about training and to impart her knowledge to others and always eager to learn more.
Area of expertise:
- Data Warehousing - SAP BI 7.0
- Reporting Tools - BEx Query Designer, BEx Analyzer, Web Analyzer, Web Application Designer, BEx Report Designer and Dash Boards
- Language - Visual C++ (6.0), C#(.Net), C, C++, Java and also in SAP ABAP/4, SD, FI
- Operating Systems - Windows10, 7, 2000.NT, 98, XP, MS-DOS, Unix
- Databases - Oracle 9i/8i, SQL Server and MS-Access
- GUI - Visual Basic 6.0, Power Builder 5.0, Developer 2000
- Java-script, HTML5, CS6, Dreamweaver, MS-Office.
She is currently pursuing Masters in Business (ERP Systems) in Victoria University, Australia. She has completed her Bachelors in Computer Science in Bharathiar University, India and Professional Diploma in SAP Business Intelligence in Victoria University, Australia - Lithan Hall Academy, Singapore. She is certified in SAP BI 7.0 (TBW45_70) and Oracle 9i PL/SQL Developer from Oracle Corp U.S. Also certified in ACTA (Advanced Certificate in training and assessment) from WDA Singapore.
Raaj has 14 years of experience in Designing , delivering and supporting, products, projects and programs in the area of enterprise SAP and Data Science . He is certified in SAP ABAP,HANA and ACTA certified as well .
He has also trained many consultants and developers on Data Science, R programming, Python, SAP HANA, BI and related products and worked extensively in Asia ( Singapore, Bhutan, Vietnam, India, Myanmar ). His core specialization skills are R programming, Python, Azure Machine Learning, SAP HANA.
Customer Reviews (12)
- will recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Mr Ken is very approachable and provided clear deliver Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Mr Ken is very approachable and provided clear delivery of the course material. I was able to design my own Access Database! (Posted on 2/26/2022) - will recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - might recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Also, the time management should be more concise and shouldn't overrun the stipulated duration. (Posted on 8/12/2020) - might consider Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Do the examples together in class instea Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Will Recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Will Recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Might Recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Might Recommend Review by Course Participant/Trainee
-
1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment