Microsoft makes a ‘one stop’ page for the latest Office update details. Figuring out what are the latest updates for Microsoft Office isn’t easy which is why we’re delighted to see Update center for Office, Office servers, and related products from Microsoft. It’s been a long time coming but as Sam Seaborn once said ” Let’s […]
Plenty of free ebooks about Office 2013, Office 2010, Office 365 and more. Microsoft has released another 130 free ebooks for anyone to download. It includes titles about Windows 8, Office 2013, Office 2010 and Office 365. A list of the Office related titles with links is below. Free ebooks should be enough to boast […]
Some great tips on table formatting. Joey Cherdarchuk has a nice posting on a very different table styling to the type that Microsoft prefers. Under the banner ‘Clear Off the Table’ he suggests getting rid of gridlines and colors to simplify the look of tables. In his example, Joey takes a standard Microsoft auto formatted table […]
Access Archon Column #230 – Making Concatenated Strings from Linked Tables and Multi-valued Fields Access versions: 2007-2013 Level: Intermediate Introduction Back in 2001, I wrote an Access Archon article (#89, Flattening Linked Data) which showed how to create a string of concatenated data from values in a one-to-many linked table. That technique is still useful, […]
Access Archon Column #229 – Fixing Normalization Errors Access versions: 2002-2013 Level: Intermediate Introduction Sometimes when you take over an Access database created by an amateur (or at least, someone with a minimal understanding of normalization), you will find data such as employee names stored in a Text field in the Orders table. If the […]