Database Systems Analyst - Microsoft Access
Great Work Envrionment & Project
Competitve Pay Rates
Our Client, NSW Government is seeking to appoint a Database Systems Analyst with experience in Microsoft Access on an initial three month contract basis, with opportunities for extensions possible based on performance and business requirements.
This Microsoft Access Database Systems Analyst role will assess and analyse business and system Database needs, involving exploring alternative options and provide consulting services to management.
The successful applicant will prepare high level and detailed technical specification, ERD and work flow diagrams and work collaboratively with the management team to determine the best mix of development, interfacing applications and solutions to meet business and project requirements.
Typical project scope is small to large database development or maintenance database projects.
- Technical skills and expertise to assess, research and analyze business and system needs
- Organized with good time management skills
- Business acumen
- Strategic influencing
- Can deal with ambiguity and manage change effectively
- Comfortable in high pressure, deadline-oriented environment
- Ability to adapt quickly; function independently
- Creative thinker, breakthrough, innovative, out of the box thinker
- Team player, cooperative with good interpersonal skills
- Microsoft (MS) Access 2007 or higher developer experience
- Experienced in MS Excel and spreadsheet development and analysis.
- Relational database design (unique identifiers, relational table creation)
- Understand and use data types
- VBA knowledge and application
- Advanced Form creation for adds, edits, deletions
- Advanced reporting knowledge
- Ability to create complicated IF statements and calculated fields
- Knowledge of using multiple functions within fields such as datepart, min, max, avg,
- Ability to create macros
- Knowledge of importing and linking various sources of data such as Excel and Access.
- SQL knowledge to create Select, Update, Delete, Union, Append queries. Outer joins, Equal joins
- Ability to create emails and attach reports to them
- Ability to create ERD diagrams & Work Flow diagrams
- Experience writing procedures
- Experience manipulating data within Excel or other files to the correct format for Access to read. Such as comma delimited files.
How to Apply?
Click on the link below
Most Popular Reviews
- 1 Ring Video Doorbell review
- 2 Sony Bravia 2017 TVs: Full, in-depth review
- 3 Garmin Fenix 5 fitness tracker smartwatch review
- 4 LG 2017 OLED TV range full review: W7 Signature Wallpaper, G7, E7 and C7 UHD TVs
- 5 Tag Heuer Connected Smartwatch and Android Wear 2 review
Join the newsletter!
- The best educational software for students
- EVE Valkyrie's Warzone update brings CCP's VR dogfighter to normal monitors
- PCWorld's August Digital Magazine: Intel's Core-i9 Tested
- Google Home hands-free calling is here, but doesn't yet have caller ID
- Aukey's dual-port car charger with Quick Charge 3.0 is $9 right now
PCW Evaluation Team
I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.
It’s perfect for mobile workers. Just take it out — it’s small enough to sit anywhere — turn it on, load a sheet of paper, and start printing.
The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.
Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.
A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.
I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.
- Sony's latest Ultra HD OLED debuts in Australia
- Panasonic Ultra HD OLED TV Review
- GAMOSPHERE: Your August Roundup of Gaming News
- Which flagship TV is best? Sony 4K HDR Bravia 2016 versus LG 4K HDR OLED 2016
- 10 Blu-ray movies / Best looking Blu-ray movies
- FTDesktop Support AnalystNSW
- FTMid Level .NET Developer (Full Stack, Back End focus) - C#Other
- FTBusiness Analyst - SCRUM MasterOther
- TPInfrastructure ArchitectNSW
- FTSenior Solution DesignerOther
- CCNetIQ Development OR Netiq Access ManagerNSW
- CCNetIQ DevelopmentNSW
- FTProject CoordinatorOther
- FTJava Developers wanted (Banking/ Finance experience ideal)VIC
- CCGaming DevelopersSA
- FTJava Services DeveloperOther
- FTVCE EngineerOther
- FTResource Planner / SchedulerOther
- CCRelease and Deployment ManagerNSW
- FTTeam Assistant / Executive AssistantOther
- FTSharePoint AdministratorOther
- TPPrincipal Software EngineerQLD
- FTSenior Research AnalystOther
- FTBusiness AnalystQLD
- CCSenior SQL Database AdministratorQLD
- FTC++ Analyst ProgrammerOther
- FTSenior Applications Specialist - Cerner MillenniumOther
- CCSenior DevOps Engineer - AtlassianVIC
- FTDevOps Engineers/Consultants - CloudOther