<

Shuffle - 3 - Table Design

Posted on
6,122 Points
0 Comments
22 Views
1 Endorsement
Last Modified:
Published
Experience Level: Beginner
6:01
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
We are going on a deep dive to the foundation of data structure -- what is in the  design view of a table? What else you can do? Use a Unique Index to prevent duplicate values from being added. We discuss Ignore Nulls, the Primary Key, AutoNumber and its properties, create a Calculated field with an Expression to combine data from other fields, tracking fields for when records were added and edited, Field Names, reserved words, and tips for naming fields, and field properties like Data Type, and Size.

Here are the other videos in this series:

Shuffle - 1 - Examine Data (imported from Excel)
https://www.experts-exchange.com/videos/61034/Shuffle-1-Examine-Data-imported-from-Excel.html

Shuffle - 2 - Totals Query
https://www.experts-exchange.com/videos/61035/Shuffle-2-Totals-Query.html

Shuffle - 4 - Append Query
https://www.experts-exchange.com/videos/61037/Shuffle-4-Append-Query.html

Look up Problem names and reserved words in Access, by Allen Browne:
http://allenbrowne.com/AppIssueBadWord.html

Video Steps

1. In table design, you can use an AutoNumber for the primary key


in the Query Setup group of the Design ribbon tab

2. Don't use reserved words in field names


      or spaces or special characters
      except underscore (_) is okay.

3. Start field names with a letter

4. Ensure Data Type and Size are good.

5. Put key fields at the top


      and tracking fields at the bottom.

6. Define an Expression for calculated fields.


      Make text bigger in the Zoom Box (Shift-F2) by clicking the Font button.

7. Use Now() for the Default Value of tracking fields


      for when a record was added and edited.

8. Set a Unique Index to prevent duplicate values.

1
Author:crystal (strive4peace) - Microsoft MVP, Access
0 Comments
Swap Microsoft Office 365 from 64-bit to 32-bit or Vice Versa
Article by: Andrew
The version of  Microsoft 365 you have installed may not be ideal. This article explains how to change from a 32-bit install to a 64-bit install or vice versa. Snapshots are included for every step so very easy to follow. Works regardless if you use…
Storing passwords in VBA using the Microsoft NG Cryptography (CNG) API
Article by: Gustav
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Handling passwords.