Скачать или смотреть AEA: Data Types with Crystal and Kent

Crystal and Kent give an overview of Data Types in Access and SQL Server.

0:01 Kent Gorrell, Good Day to Data Types in Access and SQL Server, Access Express Australia
0:36 Crystal, Basic Data Types in Access
1:02 Yes/No
Boolean, True or False, stored as number
1:47 Help for Data Type
1:54 2 bytes?
2:00 changed to 1 byte, maybe string of bits?
2:20 maybe better to use a more specific field than Yes/No such as a date/time
2:50 gray font color means you maybe don't want to use
3:05 Byte is unsigned whole number
3:28 Integer
3:46 Long Integer , common
4:22 Currency
usually money but not necessarily
banker's rounding, scientific rounding
5:31 Single and Double
Floating, scientific notation
stored as scientific notation, not precise
significant figures
not precise for exact comparison
good for extremally small and large numbers
6:24 Date/Time , problematic.
Internally stored as number (double precision)
Jan 1, 100 is lowest date.
Displayed depending on your Windows settings
Whole part of number is date, fractional part is time.
7:42 Short Text
set to reasonable length
indexes take all the space
8:37 Long Text
can also store Rich Text formatting
9:22 Decimal
up to 29 significant figures
problem is that no specific data type in VBA
9:55 DateTime2 and BigInteger
once enable, can't be shared with old versions
10:24 GUID
Global Unique IDentifier
10:58 Calculated
Access 2010 and forward
11:39 Access Data Type Summary
11:55 Kent, data types for SQL Server
12.10 Bit
12:42 SmallInt
13:00 TinyInt
12:25 Int - PKs, FKs
14:38 BigInt
14:46 RowVersion
15:20 *Decimals*, Precision and Scale
16:05 Money
16:16 Text Data Types: VarChar, NVarChar, Max
17:00 Char

Access Express Australia
https://accessusergroups.org/access-e...