Shuffle - 3 - Table Design
Posted on
6,115 Points
5:59
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
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.
0 Comments
Suggested Videos
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…
This article covers how to resolve Outlook password issues and serves as a guide when you keep entering credentials Outlook fails to remember. A "Needs Password" message is typically seen at the bottom of Outlook, or a Windows Security prompt keeps …
- Email Clients
- Microsoft Office
- Microsoft 365
- Outlook
- Windows OS
- Mac OS X, Security, Email Software
