Home » Posts tagged "access 2010"

Tag Archives: access 2010

Understanding Microsoft Access Database Relationships (RDBMS)

Microsoft Access Database

Onе оf thе fundamental principles оf аnу relational database, lіkе MS Access, іѕ thе relationship and links bеtwееn tables that maintains and better manages data inputting, time and storage. Yоu саn building Microsoft access database that іѕ based оn јuѕt оnе table, but thаt table соuld grow аt аn alarming rate аnd уоu wоuld hаvе problems accessing thе correct records аt speed, аѕ wеll аѕ hаvіng tо input thе ѕаmе data оvеr аnd оvеr again. Fоr instance, imagine уоu run а […]

Tags: , , , , , , , ,

What is the function of primary key when creating a database in access ?

access database 

When building an access database, the primary key is important and an important thing to note when creating a database in access. Before continuing you should know what primary keys mean. What is a primary key Primary keys are fields or fields with values that are unique throughout a table when building an access database. Primary keys can be used to refer to entire records, each record has a different value for the key. A table can only contain just […]

Tags: , , , , , ,

Problems With Memo Fields When Running A Query In Access 2010

Microsoft Access Database

I recently wrote an EzineArticle about the Memo fields when running a query in Access and what has changed with the latest version (2010). It can affect criteria and causes sorting challenges and should be avoided if at all possible. But if you really need it, then read on and know your options… Creating Microsoft Access Queries – Why You Should Avoid The Memo Data Type In Access Queries I recently worked on a migration Access database project converting from […]

Tags: , , , , ,

Using Access 2010 – 5 Quick Tips

MS Access Macro

Whether you are a newbie or seasoned Access database user, it’s always useful to know some quick tips to help navigate and control the application’s environment. Here are 5 quick tips to using Microsoft Access 2010 (some are exclusive to this version!): 1. The Ribbon Bar This is great for the new user but for those who have migrated like myself became a little disorientated. Two little tips here; Get to know the Ribbon Bar it is reasonably well organised […]

Tags: , , , ,

Sharepoint 2010 and Access 2010 Tutorial

Access Database

A very quick overview of how to share an Access databases (2010) over the internet using SharePoint 2010 services, the new way to publish Access database files on the web. It really is that simple as the steps shown in this video tutorial and you will soon learn the do’s and don’ts when the system always analyses the objects from your Access databases file. Make sure you do some more research first and know what your options are before you […]

Tags: , , , , , ,

Microsoft Access database 2007 Database Tutorial – Trust Center Locations

Microsoft Access Database

This quick two and half minute video tutorial won’t win any Emmy awards for best production and script but it puts the point across clearly when users see the unwanted ‘security’ banner warning in Access 2007 (and Access 2010) and how to avoid this banner for future use. The author doesn’t like this feature of access database and I can understand why but Microsoft felt it was needed to add extra protection as a warning for unknown access database files […]

Tags: , , , , , , , ,

← Older posts