| |
| Aim of Course | This course is designed for participants who wish to use Microsoft Access as a database and utilise all the facilities within the database. |
| Target Audience | Designed for participants who have basic knowledge of computing and wish to use Microsoft Access to aid quick retrieval of information |
| Structure of Course | The participant is given exercises that offer hands-on practical experience to enable successful and efficient use of the program. |
| Training Facilities | Training will take place in one of 4 fully equipped training suites delivered by professional lecturers. Up to date multimedia and interactive software/smartboards. Free on-line back-up support after training. |
| Course Content | Introduction to Databases Structure of Records/Fields Designing a Database Structure Creating a Database Switching Between Different Layouts Inserting/Deleting Fields/Records Modifying an Existing Database Expanding an Existing Database Copy, Moving Records Creating and Designing Data Entry Forms Validating Data Using Filter by Form/Selection Find Functions Find and Replace Functions Completing Criteria Searches Saving Search Results Relational Databases Using the Report Wizard Customising a Report Printing Reports Working with External Data Creating Hyperlinks Export Tables/Queries/Reports to HTML Format |
