Professional training course · AS-035
Database and Information Management for Administrators
Contact lists, supplier records, membership data, asset registers, training records and request logs are central to administrative work. When information is scattered…
- 5 daysClassroom
- 49Upcoming dates
- 12Cities
- £2,250Fees from
Course overview
Introduction
Contact lists, supplier records, membership data, asset registers, training records and request logs are central to administrative work. When information is scattered across spreadsheets, inboxes and paper files, it becomes hard to find, easy to duplicate and difficult to keep accurate.
This Database and Information Management for Administrators training course introduces practical ways to organise, maintain and use information effectively. Participants learn the basics of database design, data entry standards, data quality, searching and reporting, and how to choose between spreadsheets, simple database tools and organisational systems.
The course also covers data protection, access control, retention and the procedures needed to keep shared information reliable, so administrators can provide accurate information quickly and confidently.
Course Objectives
By the end of this training course, participants will be able to:
- Explain the principles of organising information as structured data
- Design simple tables and fields for common administrative records
- Set data entry standards that improve consistency and accuracy
- Use queries, filters and reports to retrieve and summarise information
- Identify and correct duplicates, gaps and errors in records
- Apply data protection, confidentiality and access principles
- Manage information retention, archiving and secure disposal
- Choose appropriate tools for different information management needs
Target Audience
This training course is suitable for a wide range of professionals, including:
- Administrative officers and assistants
- Records and information officers
- Office managers and coordinators
- HR, membership and customer administration staff
- Data entry and registry staff
- Project support officers
- Staff responsible for maintaining shared registers
Training Methodology
Participants work hands-on with sample administrative data, designing simple databases, cleaning records, writing queries and building reports. Short explanations are followed by guided practice and a final project in which participants design an information management solution for a task from their own workplace.
Target Competencies
- Data organisation
- Database design basics
- Data quality management
- Information retrieval and reporting
- Data protection awareness
- Records lifecycle management
Course outline
-
1Day One: Information as an Asset
- Why Information Management Matters: Efficiency, accuracy and compliance
- Structured and Unstructured Information: Records, documents and messages
- Common Problems: Duplicates, inconsistent entries and lost files
- Spreadsheets, Databases and Business Systems: When to use each
- Roles and Ownership: Who maintains which information
- Mapping Information Flows in the Office
- Exercise: Auditing a shared contact list
-
2Day Two: Designing Simple Databases
- Tables, Records and Fields: Core database concepts
- Choosing Field Types and Formats
- Unique Identifiers and Avoiding Duplicate Records
- Relationships Between Tables: Contacts, organisations and activities
- Lookup Lists and Validation Rules
- Forms for Accurate Data Entry
- Practical Exercise: Designing a supplier and contract register
-
3Day Three: Data Quality and Maintenance
- Data Entry Standards: Names, addresses, dates and codes
- Finding and Merging Duplicate Records
- Correcting Inconsistent and Missing Data
- Regular Data Quality Checks and Audits
- Change Control: Who can edit and how changes are recorded
- Importing and Exporting Data Between Systems
- Workshop: Cleaning a sample membership database
-
4Day Four: Retrieving and Reporting Information
- Searching, Sorting and Filtering Records
- Building Queries to Answer Common Questions
- Creating Summary Reports and Simple Dashboards
- Mail Merge for Letters, Labels and Emails
- Scheduling Regular Reports for Managers
- Presenting Information Clearly to Managers and Colleagues
- Practical Exercise: Producing a monthly activity report
-
5Day Five: Protection, Retention and Improvement
- Data Protection Principles for Administrative Records
- Access Rights, Passwords and Sharing Controls
- Retention Schedules, Archiving and Secure Disposal
- Backups and Recovery of Important Information
- Improving Information Processes in the Office
- Personal Action Plan: Information management improvements
- Final Project: Designing an information solution for a workplace task
Schedule
Dates and fees
49 upcoming dates in 12 cities. Fees are per delegate; bring colleagues and every seat is discounted.
No dates in this city right now. Request a quotation and we will suggest the nearest date.
Questions
Frequently asked questions
How long is the Database and Information Management for Administrators course?
The course runs over 5 days of classroom training, usually Monday to Friday.
When is the next Database and Information Management for Administrators course?
The next public date is 7 - 11 Dec 2026 in Barcelona. There are 49 upcoming dates in total.
Where is this course held?
Upcoming sessions run in Barcelona, Frankfurt, London, Madrid, Munich, Paris, Rome, Vienna, Cape Town, Dubai, Istanbul, Kuala Lumpur.
How much does the course cost?
Fees start from £2,250 per delegate, depending on the city. Fees include tuition and course materials.
Do participants receive a certificate?
Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.
Can this course be delivered in-house for our team?
Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.
Course information last updated 14 November 2026.
Related
More Administration and Secretarial courses
Administrative Performance Review and Office Audit
Next: 7 - 11 Dec 2026 · London
London, Barcelona, Frankfurt +9 more
Advanced Excel for Administrative Professionals
Next: 7 - 11 Dec 2026 · Barcelona
Barcelona, Frankfurt, London +9 more