Jim Brown

Background

About Jim Brown

I am a Computer Software Engineer with over 40 years’ experience. Specializing in the design of custom Databases and Applications. I also supply IT Services including General computer consulting, MS Windows management and support, and Database Administration. Here are some of the tools I work with: MS Access The MS Office database application. Let’s you store data and create Forms and Reports to use it. • I’ve been using Access since version 1.0. Over the years I’ve created many database systems for multiple clients. Access can be used with its own database engine or access data in MS SQL Server tables. MS SQL Server – database storage system • Design tables, views. • Stored Procedures to process data • SSIS or SQL Server Integrations Services • Created DTSX and its predecessor DTS packages • SQL Job’s to automate the use of Stored Procedures, DTSX, and TSQL routines. • MS Access databases to access and work with SQL data. Office 365 Apps SharePoint – I have worked with the following SharePoint features: • InfoPath forms – lets you create forms to maintain SharePoint lists. I have created a of number of these forms that included use of its programing language. However, InfoPath is on Microsoft depreciated list and should not be used for new development. • Document library’s – collections of MS Office documents (Word, Excel, etc.) • Lists – you can design a flat data table and maintain it with the web-based form. • SharePoint workflows – allows you to program various tasks. Kicked off by events in Lists, Library’s, and InfoPath forms. Flow – Microsoft Flow is an online workflow service that lets you create workflows that access various online and in-house data sources and programs tasks to be performed. • Created a Flow to extract data from an in-house SQL server and update a SharePoint List. PowerApps – creates phone, tablet, and PC app’s • Went thru the online training and created some sample apps