New Access tutorials from Microsoft

[BittenApple]

Hello Hans,
Please look into this paragraph:

Microsoft Access Primary Key Preferred Method: In Access table design current techniques we don't get rid of the primary key we just create a more efficient alternate (or pseudo) key with the autonumber field. This field is independent of the actual data in the table and therefore never requires a cascading update - when the primary key field data changes it only changes in one place since it only exists in a single table.

Is this correct to say:" when the primary key field data changes it only changes in one place since it only exists in a single table."?

When the primary key field data changes, it doesn't change in one single table, but also, it changes in the table where it is used as a FK despite to what the top paragraph says.
Regards,
BittenApple

[HansV]

If you use a field that can be edited by the end user as primary key, you must tick the check box 'Cascade Update Related Fields' for each relationship that involves that field. For if the primary key of a record on the 'one' side of a relationship changes, the corresponding foreign key on the 'many' side must be updated too, otherwise they don't match anymore.

If you use an AutoNumber field as primary key, the user won't be able to change its value: the value of an AutoNumber field is assigned once by Access and it cannot be edited. So there is no need for 'Cascade Update Related Fields'.

[grovelli]

And now there's also an Access Roadmap for those just starting out

[HansV]

Thanks!

[BittenApple]

grovelli,
So many thanks for Access Roadmap.
Hans,
Thanks for all,
Regards,
BittenApple

[grovelli]

In addition to the blog on the Office site, the Access team has started a technical blog here

[BittenApple]

Thanks for this link,
BittenApple

[BittenApple]

Hi grovelli,
I went to you the link you sent me and it took me to Microsoft account. Does Microsoft charge members for their questions? Because I saw some billing information on the site.

Regards,
BittenApple

[HansV]

It should be possible to read the Access blog without using a Microsoft account. Have you tried again?

[BittenApple]

Hans,
Thank you for thinking about me. No, I have not tried it, but I will.
Regards,
BittenApple

[grovelli]

And if you're interested in lots of free, pretty recent, ebooks from Microsoft then here they are. Only one about Access but a good range for SQL Server and Power BI for example.
Does anyone know how to open the MOBI and EPUB formats?

[HansV]

The free PDF reader Sumatra can open both MOBI and EPUB files.

[BittenApple]

Thanks from both.
BittenApple