Microsoft Access is one of the leading relational database systems for the home and business sector. Currently there is high demand for highly skilled Access developers.
Our training is delivered through our On-line 24/7 Mentored training platform.
Training Modules and Objectives
Introduction to Access
- Use the Ribbon to access command buttons and groups
- Use the Office menu to access commands dealing with the whole application or database
- Use the Navigation Pane to view and open database objects
- Start a new database by using templates provided by Microsoft Office Online
Creating Tables
- Recognize data types and basic database terminology
- Add and delete fields from a table
- Set the primary key for a table
- Identify flat files and relational databases
- Create simple tables
- Add, modify, and delete records from a table
Working with Tables
- Apply basic formatting to a database table
- Create input masks for table fields
- Create validation rules for table fields
- View and modify the relationships between tables
Creating Forms
- Create simple forms using the Form button
- Create split and multiple items forms
- Use the Form Wizard to create customized forms
- Edit and customize a form using Form Design view
Creating Reports
- Create a basic report
- Create a report using the Report Wizard
- Create a customized report
Creating Queries and Filters
- Explain the difference between a query and a filter
- Apply sorts and filters to your tables
- Build a query using the Query Wizard
- Add query criteria to narrow the focus of your queries
SkillFusion Training Benefits
- Cost effective - You don't have to break your budget to get started
- Flexibility - You don't have to take time off work or disrupt your schedule
- Specialised Teacher Support - You will have support for all your questions
- Hands on skills - Software simulations in real world scenarios
Take the next step now!
Register for more information and receive FREE of charge our e-book
"11 Breakthrough strategies for Interview Success"