- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Is there a Database Creator that self generates from data?
Posted on 12/11/20 at 3:10 pm
Posted on 12/11/20 at 3:10 pm
I was recently transferred to a new small department that has no real infrastructure.
So far it runs mainly off 3 excel spreadsheets, that could be combined into 1 table with 40 column headers.
What I'm wondering is of there's a tableau style database/dashboard Creator that essentially understands that each row is an entry, and creates a data entry page with those column headers.
I don't feel like jumping back into beginner Access and manually doing everything. I figure there has to be a new way where intelligent programs can predict "based on the table submitted", choose default layout options, and then press new to enter new records.
basically to create a simple record entry tool
LINK
I can do it, just wondering if anyone has a better way.
So far it runs mainly off 3 excel spreadsheets, that could be combined into 1 table with 40 column headers.
What I'm wondering is of there's a tableau style database/dashboard Creator that essentially understands that each row is an entry, and creates a data entry page with those column headers.
I don't feel like jumping back into beginner Access and manually doing everything. I figure there has to be a new way where intelligent programs can predict "based on the table submitted", choose default layout options, and then press new to enter new records.
basically to create a simple record entry tool
LINK
I can do it, just wondering if anyone has a better way.
Posted on 12/11/20 at 3:19 pm to Kujo
Create a google form. Connect to a google sheet. Profit
Posted on 12/11/20 at 6:58 pm to Kujo
Access used to have wizards to create entry forms. If it’s just a single table, just use the table interface.
You can use powerbi for the dashboards.
You can use powerbi for the dashboards.
Posted on 12/11/20 at 10:04 pm to scottfruget
(no message)
This post was edited on 1/13/21 at 6:11 pm
Posted on 12/11/20 at 10:26 pm to scottfruget
Thanks I'll play around during the break
Posted on 12/14/20 at 6:02 pm to Kujo
I have successfully used the Google forms to google sheets option but unfortunately a little more leg work to get it back into excel as you are limited to google sheets using Google forms. I have also used monday.com platform to create a poor man's data entry form that could export to excel. Can also set up all kinds of triggers that occur upon data entry.
Posted on 12/14/20 at 6:09 pm to deNYEd
Also, there is a data entry screen you can open within excel. Your best option is probably making small relational database and not a giant flat table if you are going to go as far as form for data entry. Then use something like power bi for other users to interact with the data.
Posted on 12/14/20 at 7:01 pm to deNYEd
Why not leave it in Google sheets? Works great.
Posted on 12/14/20 at 8:17 pm to scottfruget
I'm google everything and I could never adapt to sheets. I use a lot of power query as well
Popular
Back to top
