Posts belonging to Category Database Design

Developer Download: The Best of Both Worlds: Access-SQL Server Optimization

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 […]

Happy New Year!

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!

Access Developers Conference – Vienna, Austria

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 […]

Free Developer Download: User Interface Guidelines

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.

Developer Download: Data Dictionary Report Utility

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.  

FREE Developer Download: Converting Flat Files into a Relational Access Database

  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, […]