Home
VBA / Excel / Access / Word
Access
Application
Data Type
Data Type Functions
Date Functions
Excel
File Path
Forms
Language Basics
Math Functions
Outlook
PowerPoint
String Functions
Windows API
Word
XML
Table Create « Access « VBA / Excel / Access / Word
VBA / Excel / Access / Word
Access
Table Create
1.
Create a table with validation rule
2.
Creating a Table (ADOX data types vs. Microsoft Access data types)
3.
Creating a Table in the Current Database with SQL statement
4.
Creating a Table in a New Database with AUTOINCREMENT column
5.
Creating a Table with a Single-Field Index with SQL command
6.
Adding a Single-Field Index to an Existing Table with SQL command
7.
Creating an Index Based on Two Fields with SQL command
8.
Default Column value
9.
Creating Check Constraints:add business rules for a table