prabha_friend
Prabhakaran Karuppaih
- Local time
- Today, 06:19
- Joined
- Mar 22, 2009
- Messages
- 927
and Completely dwell into Object Oriented Programming Only here onwards? How difficult would that be to grab the concepts and Develop on the same?
Don't choose course of action based on difficulty. Choose course of action based on desire. My observation based on various posts I have seen you make is that you are curious as hell about OOP. So feed your curiosity.How difficult would that be
Philosophically, are you moving away from something in hopes of finding something better? Or, are you moving towards something that appeals to you more than what you are doing now?and Completely dwell into Object Oriented Programming Only here onwards? How difficult would that be to grab the concepts and Develop on the same?
Don't forget that Access makes lots of things very easy. Data binding, data updates, continuous forms. It will be enormously difficult to programme that all in. I keep trying it out, and the data binding/continuous forms stuff just seems so difficult to achieve. If I could get that working, I think I could make some progress.
To replace Microsoft Access, you would need a combination of tools that handle database management, user interface creation, and reporting, depending on what features of Access you rely on. Here are the key components of Access and their potential replacements:
### 1. **Database (Backend)**
- **MySQL/MariaDB/PostgreSQL**: These are open-source relational database management systems (RDBMS) that can serve as the backend for your data storage. They support complex queries, triggers, and transactions similar to Access.
- **SQLite**: For smaller projects, SQLite can be a lightweight alternative. It’s serverless and stores the entire database as a single file, similar to Access.
### 2. **Front-End (Forms/User Interface)**
- **Microsoft Power Apps**: A low-code development platform for building custom business apps. It integrates well with Microsoft 365, including SharePoint and OneDrive, making it a good replacement if you are in the Microsoft ecosystem.
- **OutSystems** or **Mendix**: Both are low-code platforms that allow you to design web and mobile apps with a drag-and-drop interface.
- **Visual Studio or Visual Studio Code**: If you are comfortable with coding, you can use these to develop custom front-end applications in .NET, React, or Angular.
### 3. **Reports (Generating Data Reports)**
- **Power BI**: Microsoft’s advanced reporting tool allows for interactive reports and dashboards. It integrates with a wide range of data sources.
- **Tableau**: Another leading data visualization tool for creating detailed and interactive reports.
- **Crystal Reports**: A traditional reporting tool often used in business applications.
### 4. **Automation (Macros and Scripting)**
- **Microsoft Power Automate**: Automates workflows and processes and can be integrated with data sources like SharePoint or SQL databases.
- **Zapier** or **Integromat**: These no-code tools are used to connect different apps and automate tasks between them.
- **Python**: For more flexibility, you can use Python with libraries like Pandas (for data manipulation) and Flask/Django (for web apps).
### 5. **Cloud-based Databases (if looking for a cloud solution)**
- **Airtable**: Combines the simplicity of a spreadsheet with database functionality and has customizable forms and collaboration features.
- **Google Cloud SQL / AWS RDS / Azure SQL**: Cloud-hosted versions of relational databases that can be used as a backend for more robust applications.
### Migration Considerations
- **Data Migration**: Moving from Access to a new platform will require exporting your data (to CSV, for example) and importing it into the new system (e.g., MySQL or PostgreSQL).
- **Query Conversion**: Access queries may need to be restructured if moving to another SQL-based system.
- **Form and Report Redesign**: User interfaces and reports will likely need to be redesigned from scratch in the new system.
The specific combination of tools will depend on the size and complexity of your application, your team's technical skill level, and whether you prefer on-premise or cloud-based solutions.
OOP is a style of programming. Certain languages are optimized to help you with this particular style.Thanks for your elaborated replies. The No.1 reason I want to shift to OOPs is that I don't want to heavily depend on any software to preexist to run my solutions.
The cortex of your brain will overheat and explode. Please do not do this.and Completely dwell into Object Oriented Programming Only here onwards? How difficult would that be to grab the concepts and Develop on the same?
The cortex of your brain will overheat and explode. Please do not do this.
Clinical studies show attempting to understand OOP produces extreme heat and pressure resulting in cortex explosion no matter where you are, but these studies were first reported by CNN so there you go.Naw, he doesn't live in the USA so the overheated political situation won't interfere with what he does. Lower ambient cortex temperature for starting point so less likely to explode.
I assumed it was me just not understanding, but maybe not.I had a similar experience trying to learn C#, recommended by our IT guy. I could pass data from/to the SQL Server, but a form/subform situation? It was difficult enough to make me give up. But then I'm an old guy and that's a new trick.![]()
I doubt many potential customers see that as a good thing. You become the single-point-of-failure. If you get hit by a bus, or (hopefully) by the winning lottery ticket, POOF, you and their investment are gone."I make my own"
Well, it depends on the customer, right? some of them are very impressionable while others are knowledgeable. Some of them might want to create proprietary stuff and others don't give a damn. There are all kinds of situations but I do agree it's not wise to do everything yourself.I doubt many potential customers see that as a good thing. You become the single-point-of-failure. If you get hit by a bus, or (hopefully) by the winning lottery ticket, POOF, you and their investment are gone.
Compare that to someone who answers: "I use mainstream coding style and tools from the major manufacturers". Everyone wants to hire this person.