Assessment: Database Administrators
IT Skills assessment for Database Administrators, Information Managers, File managers
Proper management of information is a challenge nowadays. Database, information and file managers are responsible for this. Depending on the size of the organization, these executives may form an entire department on their own, or may work as part of a team of qualified executives.
The day-to-day responsibilities of the people holding these positions involve.
- Using, Supporting and Creating Databases
- Maintaining and securing information and files
- Writing reports
- Training of new recruits
- Dealing with requests for information
- Archiving
In order to perform their duties properly, these executives must know very well how to operate various applications so as to produce the desired result.
Job positions with similar typical skills
Jobs with similar formal qualifications include: Database managers, information managers, file managers, regulatory affairs manager, archivists, Records managers, Information scientists, etc.
What does TEST4U recommend?
These jobs require a solid knowledge of operating a variety of applications. For a clearer result and a better picture, we suggest the assessing the candidates’ skills in the applications:
- Tables and Relationships
- Queries
- Forms
- Reports and Macros
- Advanced Functions
(AND, IF, OR, VALUE, IFERROR, WORKDAY.INTL, DAYS, DATEDIF, INDEX, MATCH, DAY MONTH, DATE, NETWORKDAYS) - Statistical and Financial Functions
(COUNTIFS, AVERAGEIF, IRR, IPMT) - Data and Chart Management
(Duplicate values, modify charts, scenarios, goal seek) - Advanced Charts and Pivot Tables
(Pivot tables and charts, advanced charts) - Business Modelling and Statistical Analysis
(TRIMMEAN, GEOMEAN, AVERAGE, MEDIAN, TREND, solver add-in, Analysis ToolPak)
- View, layout, and print documents
(Page size, hyphenation, document views, page break, printing) - Format Text and Paragraphs
(Font, character, line and paragraph spacing, paragraph alignment) - Header, Footers and Graphic Elements
(Page numbering, insert and modify graphic elements) - Tables and Lists
(Single or multi-level list formatting, table formatting)
The assessment uses Microsoft Office 2019
The assessment syllabus covers formulas and functionality common in the following versions of Microsoft Office:
Microsoft Office 2016, Microsoft Office 2019, Microsoft Office 2021, Microsoft 365
Also, the interface of Microsoft Office remains mostly similar for all the above versions of Microsoft Office.