What's Happened To Access?

[New Judge]

I used MS-Access quite a lot up to a few years ago. Wrote quite complex databases with extensive use of macros. Just trying to use the new version for the first time and I am again trying to write a fairly straightforward macro.

I can run queries OK from within the macro but cannot find (among other things) how to copy or delete tables. Any ideas anyone?

[Buenchico]

I don't know if it will help but, while trying to find an answer to your problem, I've found that there's an 848 page(!) book about Access 2013 that costs £30.99 in paperback or £20.52 in Kindle format. However it's completely FREE if you download the pdf file from here:
http://gegeek.com/documents/eBooks/MS%20Access%202013%20Inside%20Out.pdf

[Gromit]

We ditched Access for FileMaker Pro about 5 years ago when Microsoft completely missed Mobile. There have been no complaints.

http://www.filemaker.com/uk/

[Buenchico]

The choice of an alternative to Access, Gromit, might depend upon what it's to be used for.

Many (most?) businesses seem to use Excel for many purposes that would logically seem to require database software, rather than a spreadsheet program, but still remarkably successfully.

If an alternative desktop-based relational database is needed though, OpenOffice Base is well up to the job.

However the majority of people who use Access these days seem to be developing web apps and FileMaker Pro might well be the way to go.

[Gromit]

We deployed iPads for data collection, surveys and validation purposes in 2010 when we went paperless. MS Office only arrived on iOS a few months ago - 4 years too late for our business.

[New Judge]

Thanks chaps.

My old Access would have been pre-2007 (2003 springs to mind). The latest is 2013. It is completely different and as far as macro construction goes seems very user unfriendly. In the old version all the database functions were contained in a single list and when selecting a function the options (such as nominating a query, or table or whatever) simply appeared in a pop-up type window.

All I want to do is run a few queries (which I've managed) and copy, rename and delete some tables. All simple stuff (I thought) but I cannot establish how to copy and delete tables.

[Buenchico]

This video is part of a free 3-hour course in Access. Perhaps it might help?

Full course here: https://simonsezit.leadpages.net/free-access-2013-course/
(I know nothing about it but it looks interesting).

https://www.youtube.com/watch?v=fh8gyIkdAKI

[New Judge]

Thanks, chico.

I'll see if I can get .pdf version of the book. It's amazing actually in that I used to be quite wizard with Access. I've built some really comple databases and routines, front ended them for remote access, all sorts of things. Now I thought I'd just play about with some personal data that I have where Excel is a bit cumbersome to do what I want. With the earlier version of Access I would have done what I wanted in about ten minutes. With the new version I spent most of yesterday fannying around. That's progress, I suppose !