Microsoft Access Expert Training & Programming

What you will learn

What you can gain from Fast Track Microsoft Access Training:

• How to make the best use of MS Access features without programming knowledge
• How to build Access databases
• How to enhance and upgrade your existing Access databases
• How to maintain Access databases, establish data security and maximise data availability
• How to evaulate when you need more sophisticated data management platforms like SQL, MS Visual Studio, .NET or other systems
• Personalised, hands-on training to suit your own pace and level
• Learn in two or three hour sessions to maximise effective learning (learn more in less training time)
• Chooose to train one-on-one or in small groups (up to five persons)
• Choose a training level that suits you (Basic/Advanced/Build Your Own Database)
• Choose a time and place that suits you (your office/ our training centre)

 

MS Access is a powerful data management software built for tracking, reporting, and sharing information to fulfill business goals and accelerate business expansion.

When your Excel lists and spreadsheets get too much to handle and you want to get even more done in even less time, Fast Track Computer Solutions recommends stepping up to the next level and using Access to help you manage your data better. Fast Track can hold your hand and help you develop that competence at your own pace.

We have helped countless organisations do this since 1985.

You do not need to be a software programmer to use Access. At Fast Track you can learn how to gain competence in this user-friendly software and utilise step-by-step wizards, macros, and more to help you complete previously complex tasks more quickly and easily.

To know more, please refer to our course outline below.

Want to build or enhance your own Access database?

Fast Track MS Access Training for Advanced Users:
Build or upgrade your own database guided by Access programmers and consultants with more than 60 years combined experience.

Are you familiar with the use of Access, and now want to create your own database? Or do you have existing MS Access databases that need to be fine-tuned for better performance, updated to serve changing business goals, or revamped to cater to new markets and business strategies? Advanced Fast Track MS Access Training will teach you the skills to get it all done.

To save you even more time and effort, you can gain privileged access to the Fast Track Databases Library and benefit from our in-depth experience to find out how other government departments, NGOs, and private businesses have benefitted from managing their data with MS Access.

Through Fast Track, you can gain valuable insights and ideas on how to leverage on something others are already using that is close to what you want to develop for your own workplace. Don’t build it from scratch if you don’t have to do so.

To know more, please refer to our course outline below.

Want us to build or support your Access database?

Outsource MS Access Programming and Support Services to Fast Track Computer Solutions.

If you want to save time, minimise effort, and boost operational efficiency, engage our experienced programmes and consultants to build customised applications to manage your database just the way you want it.

Our MS Access programmers can develop stand-alone applications in VBA, SQL and XML, or help you integrate your database with other programmes in the MS Office suite (e.g. Excel, Word, Project, Outlook, PowerPoint) or external databases and ASCII files.

And if it makes better business sense to outsource your Access support, you will be pleased to know that we provide Access database support in two or three hour blocks – yes, you don’t have to commit to a recurring support agreement if your business does not require it at this stage.

Let Fast Track Computer Solutions accelerate your business growth and work productivity. Please contact us to discuss your needs and we’ll be happy to suggest a solution that meets with your needs and budget.

Course Outline

Listed below is our course outline. The 12 hours indicated may be extended depending on the needs and computer skills of the trainees.

We are also now offering a Basic Introduction to Access course which is 6 hours.

Also if we are requested to help you build a system as part of the training, this probably will take longer.

The course cost is charged by the hour (not per person). The cost per hour will increase depending on the number of trainees, at the same time.

Unit 1 = 3 Hours

• What is a Database?
• Can I use Excel as a Database?
• What are the limitations?
• Set up a Contact Database?
• Set up a Table
• What is a field?
• What is a record?
• What is a Key (Index)?
• Primary Key
• Key with and without Duplicates
• Enter Data into table
• Data Entry Form
• Use Wizard – Different Form Type
• Enter Data into Form
• Reports
• Use Wizard to get Data into report – Various Types
• What is a Query?
• Simple Query to filter data
• Use Query in Report
• Compact and Repair the Database
• Autoexec to Open Data Entry Form
• Backup file Daily

Unit 2 = 3 Hours

• Explain Normalisation
• Data Integrity
• How to relate 2 Tables
• How to relate 3 Tables
• Show Table Defaults
• Sort Data
• Query Wizard
• How to Setup a Query using multiple tables
• Queries with complex criteria, calculations, totals
• Setup a form using a query
• Use form tools
• Section5

Unit 3 = 3 Hours

• Setup Menus
• Use Switchboard
• Show how to use form data on reports
• Develop Report from complex query.
• Show Report Tools.
• Form data verification
• Close button
• Import/Export Data

Unit 4 = 3 Hours

• Split DB
• Export to Web
• Macros
• Passwords