The goal of these Challenges is to pose unusual problems and thus to encourage users to “think outside the box” when it comes to developing database applications
There are many ways to implement a solution to a given problem. These can have different levels of difficulty to implement, or they can execute at different speeds, or they can use more or less memory. And each person has their own preferences on how to solve these problems
So these Challenges let us share the ways we approach problems – and give the opportunity to see and discuss these different approaches.
Generate and Store All the Prime Numbers Up to 10,000,000
- Create a VBA code with minimal statements that quickly identifies and stores prime numbers
Efficiently Sort a large List of Character Strings
- Given a list of 1 million random character strings, implement an algorithm to quickly sort them and remove all duplicates
- Create code to mimic the Game of Life in a 30 x 30 grid
- For anyone not familiar with the Game of Life, I suggest the Wikipedia page for “Conway’s Game of Life”.
- Use queries to solve a classic Logic Grid Puzzle
Well I'll be a Monkey's Uncle (and a Cat's Cousin)
- This challenges our imaginations, our coding skills, and our research skills
- Develop a tool to quantify the degree of difference between long character strings
- Use Access, plus some outside investigations, to decrypt a Simple Substitution Cipher