Saturday, May 05, 2012 This website is about learning how to build an Access database using the most effective techniques and tools available with very little or no knowledge and get you up and running without the need to learn all the ‘geek’ speak keeping it Jargon free that most trainers and consultants like to impress you with!
If you are new to Microsoft Access or wish to know what it is, please take a look at An Introduction To Microsoft Access.
This website contains blog posts, products and general tips to help users find out all about Microsoft Access latest news and articles I feel worth mentioning and recommendations of videos and books on the subject.
Using the Access DLookup function may be called upon where users need to output a value from other data sources (i.e. tables or queries) where there is no direct relationship.
Yes it is an RDBMS but depending on how the database was designed and built or if you had inherited an Access database this could well mean having to handle workarounds and the collection of ‘D’ based Access functions are at your disposal.
To create an Access database from an Excel spreadsheet is simple enough to setup and apply. However, there are some preparations involved as data is being migrated from a ‘flat-file’ environment (which is what data in a spreadsheet provides) to a relational database (RDBMS – which is one of Microsoft Access’s strengths).
Take a look at this video tutorial to see some of the final steps in migrating and populating data to create an Access database from an Excel spreadsheet…
In this video which by the way is very well explained you need to have an existing database in place which means having relationships created and other objects. In fact, you do not have to have any objects in place as part of the import routines will generate new tables.
Have a plan, sketch out the data sets that will become separate tables in your Access database. Know you primary key fields (fields that will be responsible when joining tables together). Also know the data types as in the video it mentioned the contact number being stored as a number with an input mask. In some cases, it could be a text data type instead.
Creating an Access database will take some time and good planning and getting to know other important objects like queries too. In the video tutorial, it did mention the APPEND query!
Training MS Access has been my privilege and vocation for nearly twenty years and whichever method you use to learn Microsoft Access, there are pros and cons in the way you master the application and the time it can take.
There was a time when spreadsheets were sufficient for managing the massive waves of data that information Continue reading →
This utility has some nice and simple features to further enhance how you manage your Access objects and in particular, filter and search objects when sharing an Access database.
From the standard object type including tables, queries, forms and reports, users can add as many groups and collect related objects in one view which makes it a very handy tool for collaborating workgroups and roles.
Objects are not copied (duplicated) when being assigned to a group but instead have a shortcut link pointing to the natural storage of the object type.
Simple Access queries show detail, line by line records but summarising your data requires the Groups and Totals query. However, how you apply criteria may have an effect if you do… Read more…