A useful introduction video showing the ‘back-end’ tools namely Tables and Queries being designed and used. It’s only the start though and you will need to do some more research. I like this video because it’s not been scripted or rehearsed showing how we all think when creating a table and a query with the author making decisions on the go applying changes during his presentation – great! If you want help, please contact me for advice and how you […]
Tags: building access queries, building access tables, hot to build an access database, hot to create a table, how to create a query, primary key, sql queries, tables and queries in access, Using Microsoft Access
Access Database Normalisation levels 1, 2, 3; getting normal about it! The process of Database Normalisation was developed by E.F.Codd who is widely considered the father of relational database theory. There are several rules which provide theoretical structures and disciplines which are not always practical to follow but help provide the main goals which are: Eliminate redundant information Increase data integrity Make systems more efficient Modern databases should be in BCNF Boyce-Codd Normal Form which is deemed to be at […]
Tags: Access Database, access database normalisation, access normalisation, database normalisation, how to understand database normalisation, normal form, primary key
This video from YouTube shows the basic way to set and join two tables together in the relationship window viewer tool. This gives you a clear and simple step by step instructions on how to join two tables creating a global/permanent relationship. Access database then recongnises this setting and releases more functionality including the ability to expand and collapse related records in a table.
Tags: Access database 2007, Access Relational Databases, How to set Access 2007 relationships, indexing, joining tables, primary key, RDBMS