Data engineer/data analyst/SQL Server 2005/Integration Services 2005/MS Access And Excel report writer.
Read More »
7+ years experience in the use of above technologies for the development of bespoke reporting for the public and private sectors.
MS Access Database Report Designing, Creation And Generation, powered by SQL Server or MS Access tables as database backend.
MS Access Database Designing And Implementation, powered by SQL server database backend. MS Access VBA coding.
MS Excel Competent/Data Analysis/Pivot Tables/Charts.
Will design and create MS Access databases according to your specified criteria.
The database will be set up for single or multi user environments as specified by you the user. This setup can have in-built user logins if you so require.
Database will be split into a front end and a back end system. This front end will contain the objects that receive and manipulate data while the back end stores the information. This separation methodology protects the business critical data and makes disaster recovery easier.
The front end will make use of forms to capture data from the user and to navigate the project space. The data captured will reside in back end tables and will be displayed using forms or reporting tools such as Access, pdf or word reports as the user determines. The reporting can also be expanded to utilise MS Excel powered by data exports from MS Access.
Extensive use of VBA / DAO coding will be employed in the front end system to manage the tables residing in the back end system and to ensure ease of use and robustness.
If your job is data analysis or engineering MS Access and MS Excel will be used to produce your final dataset.
MS Access will be employed for automations and extract, transform and load operations while MS Excel will be used for summaries, charts and pivots if you so require.
I aim to complete most jobs within a week, more complex scenarios will take longer.
Read More »