Learn Access! The most important part of an Access database is the structure ... Tables, Fields, and Relationships. In this lesson, we start with 3 tables from the previous lesson and we create 7 more. As we go, we build relationships using the Primary Keys and Foreign Keys in our design, and layout the Relationships diagram. Learn Access by focusing on the structure first ... the rest is downhill if this is done right.
Key fields (Primary Keys and Foreign Keys) have the same name in the main table and in the related table so that it is easy to see them! Key fields are listed at the top of the field list.
Add Tracking Fields to your tables ... very easy to automatically store the date and time a record was added by using the Now() function as the Default Value for a field.
Create AutoNumber values using an Append Query.
Use an InputMask to display Phone numbers with symbols.
Switch between Tabbed Documents and Overlapping Windows by changing the Access Defaults.
Disable AutoCorrect, which is a multi-step process.
Use icons on a customized Quick Access Toolbar.
Learn how to layout the Relationships Diagram so that it is very easy to see what the database is tracking and how tables are related.
~~~~~
Captions: coming! If you are interested in translating, please contact me.
~~~~~
featured music:
"Colors of the Lonely"
- JD Live (Jerome Dixon from Houston)
full song: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Looking for a song to commemorate a special occassion, or great entertainment for your next party? Contact JD at jdlivepro@yahoo.com
~~~~~
related video:
Customize the Quick Access Toolbar
Tip: Add Save As Icon to QAT (cc) - Français, Dutch, Deutsch, English
[ Ссылка ]
links:
Problem names and reserved words in Access, by Allen Browne
[ Ссылка ]
Database Issue Checker Utility, by Allen Browne
[ Ссылка ]
Failures caused by Name AutoCorrect
[ Ссылка ]
~~~
more Access Tutorials
[ Ссылка ]
*****
FREE book on 'Access Basics'
(even if you are not a beginner, chances are you will discover something new)
[ Ссылка ]
*****
contact me for free remote Presentations to User Groups and Organizations
happy learning!
______________________
Intro and End: Microsoft Office PowerPoint.
Screen-shots: Techsmith SnagIt.
Screen capture and production: Techsmith Camtasia
Audio edited with GoldWave
~~~~~~~~
Capture and Production Settings:
Video: H.264, 24-bit color, 30 fps, 1280x720
Audio: PCM, 44,100 kHz, 16-bit, 172 kb/sec
~~~~~~~~
Render Format: QuickTime MOV
~~~~~~~~
* let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!
visit MsAccessGurus and contact me today!
[ Ссылка ]
I look forward to hearing from you ~
warm regards,
crystal
Remote Programming & Training -- connect to me, let's built it together
~ have an awesome day ~
Learn Access -4- Tables and Relationships
Теги
Build Access DatabaseTables and FieldsRelationsipsPrimary KeyForeign KeyTracking FieldsCreate autonumber valueAppend QueryInputMaskRelationships diagramAccess 2013Access 2010Access 2007AccessCrystalstrive4peaceMicrosoft MVPMVP\Access Database\Microsoft AccessTables and RelationshipsAutoCorrectQATJerome DixonJD LiveTabbed DocumentsOverlapping WindowsAutoNumberDefault ValueKey fieldsstructuredata structure