Shuffle - 3 - Table Design

Posted on 2019-06-06

6,102 Points

0 Comments

2 Views

1 Endorsement

Last Modified: 2019-06-06

Experience Level: Beginner

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

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.

Author:crystal (strive4peace) - Microsoft MVP, Access

0 Comments

Featured Post

Suggested Videos

Title	Views	Activity
Office 365 basics. Module 3 - Outlook 2016	35	2019-11-28
Repair corrupt PST File when ScanPST.exe fails	77	2019-11-04
Shuffle - 2 - Totals Query	1	2019-06-06
Shuffle - 4 - Append Query	6	2019-11-09

How to download number of Views, Endorsements, Points for Experts Exchange Articles and Videos

Article by: Joe

This is my 100th publication at EE — 56 articles and 44 videos. To mark the occasion, I wrote a program to download the Title, Views, Endorsements, and Points for the specified URLs of articles and videos. Based on feedback, I enhanced the program t…

Programming
Experts Exchange
Windows OS
Programming Languages-Other
Web Browsers
Microsoft Excel, Scripting Languages, *Scripting, *text file, *AutoHotkey

Join (concat) values from one field from a table or query

Article by: Gustav

As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.