The ability to input and manage database systems is key to many jobs. Microsoft Access is the most common database system and knowledge of this program is required in a wide range of industry.
This course is a discounted package that includes the Beginner and Intermediate Access Course. This course will enable students to gain CPD Accreditation at Intermediate Level upon successful completion.
Microsoft Access Beginner to Intermediate Course
The course aims to give students Intermediate Access Skills.
Course Content
Beginner module
Database Basics and Database Management
- Getting started with the Database Management System
- Opening a database
- Database objects
- Overview of Access ribbon
Maintaining Database records
- Entering, Replacing, Editing, Finding, Delete and Sorting records
- Moving around in a datasheet/form
How to use of the data
- Print Preview data
- Margins and orientation for printing any object
- Running a query in your database
Intermediate Level
Objects and their datasheets
- Managing objects
- Formatting/reorganising a datasheet
- Filtering records by the value in a field
- Filtering by a range of field values
- Inserting a Total row into a datasheet
Database creation and protection
- Creating a database
- Converting a database
- Protecting a database
More Advanced Database Management
- Creating a table
- Primary key
- Importing data from another application
- Exporting data
- Creating a form
- Object dependencies
- Selecting the records to print in a report
Building Queries and increase efficiency of data extraction for End Users
- Creating a Select query
- Using the query design grid
- Setting a selection criterion in a query
- Setting criteria on multiple fields
- Setting multiple criteria on the same field
- Sorting the records in a query
- Delete query
- Make Table query
- Update query
Course Format
The course is delivered using a virtual tutor on a live server. This is a state of the art learning system. The virtual tutor will instruct you and correct your exercises. This standard of interactive learning will enable you to gain from interactive learning. This is available to you on a flexible basis that you can access at any time.
Entry Requirements
Course starts from beginner level, so no entry requirements.
Dates and Duration
Training can commence on any date. The course has up to a maximum of 12 months to complete. The majority complete the course far before 12 months. You can complete the course on flexi-time online. The assessment at the end can be done online.
Benefits of the Course
- Training from a Microsoft Certified Academy, to ensure quality
- Virtual tutor on a live server enables interactive learning and guidance throughout the training program
- Possibility to continue to study Advanced Access and VBA
- CPD Certification in Microsoft Access to build your CV
- Qualification is certified and can build your career
- Flexibility to train as intensely or otherwise as you prefer
- Available at our Certified Training Centre with trainers to support you or at home
Outcome
CPD Certificate in Microsoft Access on successful completion at Intermediate Level.