864 Design courses in Pontypool

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

This half day course is designed for those people working or volunteering in groups or working on projects who would like some practical tips on making their marketing and publicity more effective.

This half day course is designed for new treasurers, general trustees and management committee members or staff who work in smaller organisations to understand the basics of how to manage the finances within a voluntary or community organisation. It covers all the essential issues ranging from drawing up a budget to ensuring that the organisation has sound financial procedures.

This course, which can be run as a half day (3.5 hours) or a whole day course, is designed to help those who chair or participate in meetings to understand how to run effective meetings that are constructive, concise and actually achieve something! The course can be adapted to cover meetings in general or focus on specific types of meetings such as trustee, director or committee meetings, staff or project meetings.

This half day course is designed for voluntary and community organisations and those involved in community development who need to write funding applications and want to ensure that their bids are clear, focussed and meet the funders’ criteria.

This half day course is designed to help participants plan and promote events, whether for fundraising, social or educational purposes. It provides practical tips on a wide range of subject areas from choosing events to determining budgets and publicity methods. The course can be adapted to take in any type of events or can concentrate on particular areas such as organising fundraising events, conferences or cultural events.

This half day course is designed to help participants in the voluntary and community sector to monitor and evaluate the work of their organisation effectively and ensure that their working practices are robust and fit for purpose. It can also be relevant to those staff in statutory agencies who work on community projects.

This half day course is designed for new treasurers, general trustees and management committee members or staff who work in smaller organisations to understand the basics of how to manage the finances within a voluntary or community organisation. It covers all the essential issues ranging from drawing up a budget to ensuring that the organisation has sound financial procedures.

Summary This half day course is designed to help managers and supervisors understand the causes of poor behaviour and look at different strategies for dealing with this. The course can be run as a one-off session or can be incorporated into a series of sessions on managing staff. Alternatively it could be increased to a day-long course with participant’s role playing different scenarios in the afternoon. For voluntary and community organisation participants the course could include dealing with difficult volunteers as well as paid staff.

This half day or whole day course is designed to support both novice and experienced trustees in providing effective governance within their organisations. It considers their roles and responsibilities in general before looking at particular areas in more detail. The half day course covers all the essential information; the whole day session includes specific exercises and case studies to develop the participants’ problem-solving skills.