AVSIG: Help with Excel wwswsigarch.jpg (7236 bytes)

✈ . . . . . . ✈ . . . . . ✈ . . . . ✈ . . . ✈ . . ✈ . ✈ . . ✈ . . . ✈ . . . . ✈ . . . . . ✈ . . . . . . Touch-and-Go to our Live Forum (This is a Read-only Archive of the 2004-2017 AVSIG Forum)


AVSIG Discussion Sections >> Hardware/Software

Terry Carraway
Top Gun


Reged: 06/02/04
Posts: 7098
Loc: Maryland
Re: Help with Excel
      12/15/15 02:56 PM

The older versions of Access were also very easy to slap something together.

And Access has always been good about starting something, and making changes on the fly to make it work better for you. I worked in dBase and rBase back in the day, and those required some design time before you started building your database. And if you screwed up the design, many times you really were better off starting over.

It may not have looked like it, but as always been easier to whip up a small database with reports and queries, than doing the same thing in Excel.

I used to teach a 1 day Intro to Access course at our professional conference. And had people up and running a small relational database in that time frame. And the morning was more about database design concepts, as many people needed to know enough to talk to the programmers.

I stopped, one reason was that each version of Access was different enough, that it was difficult to do exercises in class and deal will all the different versions.

I taught doing tables in Design View. Forms and Reports using the Wizards, and Queries in Design view.

I was amazed though, some people made managed to make databases in Excel with 15,000+ records. But at the end of the day, they were convinced that it would have been easier to start in Access.

The one thing I do not like about Access for other than personal use is, if you change something in a record, it is changed in the database. No saving, no asking if you want to save changes. If you accidentally type something a field, that is what is now in the database, and what used to be there is GONE.

You can program the form to ask about Saving and then saving or not, but IMO, that should be built in.

--------------------
Terry
Mostly 0W3

Post Extras Print Post   Remind Me!     Notify Moderator


Entire topic
Subject Posted by Posted on
* Help with Excel Ward Miller POU-NY 12/09/15 05:29 PM
. * * Re: Help with Excel Bruce Gorrell [EQY]   12/12/15 09:17 PM
. * * Re: Help with Excel Kcid LlirreM   12/11/15 09:07 AM
. * * Re: Help with Excel sreyoB yrraL   12/11/15 09:19 AM
. * * Re: Help with Excel Kcid LlirreM   12/15/15 08:53 AM
. * * Re: Help with Excel sreyoB yrraL   12/15/15 11:18 AM
. * * Re: Help with Excel Terry Carraway   12/15/15 02:56 PM
. * * Re: Help with Excel John O'Shaughnessy [FCM]   12/16/15 12:26 PM
. * * Re: Help with Excel Terry Carraway   12/17/15 02:17 AM
. * * Re: Help with Excel Russell Holton   12/16/15 12:31 PM
. * * Re: Help with Excel Terry Carraway   12/12/15 02:19 AM
. * * Re: Help with Excel sreyoB yrraL   12/12/15 09:37 AM
. * * Re: Help with Excel Terry Carraway   12/13/15 12:41 AM
. * * Re: Help with Excel sreyoB yrraL   12/09/15 06:32 PM
. * * Help with Excel Ward Miller POU-NY   12/09/15 09:15 PM
. * * Re: Help with Excel sreyoB yrraL   12/10/15 09:00 AM
. * * Help with Excel Ward Miller POU-NY   12/10/15 10:31 AM
. * * Re: Help with Excel Terry Carraway   12/10/15 11:18 AM
. * * Help with Excel Ward Miller POU-NY   12/10/15 05:34 PM
. * * Re: Help with Excel Terry Carraway   12/11/15 03:32 AM
. * * Re: Help with Excel sreyoB yrraL   12/10/15 12:35 PM
. * * Help with Excel Ward Miller POU-NY   12/10/15 05:34 PM
. * * Re: Help with Excel Bill Bridges - 9S1   12/12/15 11:00 PM
. * * Help with Excel Ward Miller POU-NY   12/13/15 06:04 AM
. * * Re: Help with Excel Mase Taylor   12/10/15 11:10 AM
. * * Re: Help with Excel Mase Taylor   12/09/15 09:25 PM

Extra information
0 registered and 13 anonymous users are browsing this forum.

Moderator:  Mike Overly 



Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 5235

Rate this thread

Jump to

Contact Us AVSIG

Powered by UBB.threads™ 6.5.5

Logout   Main Index    AVSIG Aviation Forum