Hello all - Experienced Excel user moving over to Access and struggling!

[BeachBoy]

Hi all

I'm a middle aged man living on the South Coast of the UK. I've used Excel for most of my adult life and dabbled with access on and off but am keen to learn more.

As I'm coming from years of Excel, its proving to be a challenge to think differently about data and how to structure it!

I will be posting some basic and probably stupid questions soon so please bear with me!

Thanks

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[The_Doc_Man]

First, hello and welcome to the forums.

Second, you might wish to search for articles by Uncle Gizmo, one of our experienced members who posted some videos on the subject of transitioning from Excel to Access. You will certainly need to understand the difference between Excel (oriented towards "flat files") and Access (oriented towards relational databases). You should read up on the subject of "Database Normalization" because if you don't, you will quickly get caught in the quicksand of bloated databases that can't easily answer questions that SHOULD be trivial to answer.

 

[theDBguy]

Hi. Welcome to AWF!

 

[xavier.batlle]

BeachBoy! Welcome to AWF!