The Best of Both Worlds: Access-SQL Server Optimization: http://www.jstreettech.com/files/Best-of-Both-Worlds.zip Access can be used to build great front-end applications for SQL Server databases, as long as you know how to optimize for performance. This slide deck shows you the basics of using Access as a client-server application so that you can leverage the full power of […]
Posts belonging to Category Database Design
A new year means new beginnings! Need help making your business as efficient and effective as it can be with a new database for your data? Need help updating your existing system? Contact us – we can help!
Attend an exciting and informative Access Developers Conference in Vienna! That’s right, in Vienna, Austria! And it gets better – the conference will be in English! Developer and Access MVP Karl Donaubauer is currently taking names to gauge the interest in this event. Conference dates: April 1 – 2, 2017 Conference will be held at […]
User Interface Guidelines Also known as “Beauty Is Only Skin Deep, But It Gets You Asked To Dance!” It’s our approach to designing consistent, professional-looking forms. Word, 64K.
Data Dictionary Report Utility Can’t get the built-in Access database documentation tools to give you the simple report you want? Here’s the answer. This utility documents all the tables and fields in your database, linked or local, including field descriptions! Access MDB, 44k.
This is the PowerPoint slideshow that Armen Stein, President of J Street, presented to the KEGS Access SIG. It shows how to tackle the problem of converting old “flat” data (from Excel, text or wherever) to your relational Access tables. Includes a sample database showing the techniques mentioned in the slides. PowerPoint, Access MDB, […]