Posts Tagged ‘learn’
Saturday, October 10th, 2009
Planning a database takes time. A good design is everything when it comes to Access; structuring data is the most important thing to do well. This foundation tutorial is the first of 3 parts on Planning — what to do BEFORE you create Access objects …
- Prepare
- Visualize
- Organize
- Design for Flexibility
- Naming Guidelines
*** TRANSLATIONS ***
French: John Viescas (Microsoft MVP, Access) http://www.viescas.com — be sure to check out John’s books!
Portugese: Luiz Cláudio (Microsoft MVP, Office)
*** CAPTIONS ***
turn Captions on or off:
mouse-over the triangle button in the lower right corner of the viewing window — then CC or the icon for captions. To translate, mouse-over the left triangle from CC and click the language you desire.
~~~
original music:
“I Don’t Know What I Want” by Jubal Lee Young from the “Jubal Lee Young” CD released in 2007
http://www.JubalLeeYoung.com
http://www.MySpace.com/JubalLee
~~~
Look up reserved words on Allen Browne’s site:
Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/AppIssueBadWord.html
~~~
Calendar screenshot from Time Pieces, by Mark Davis
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=1622741
~~~
more Access Tutorials
http://www.EverythingAccess.com/tutorials.asp
~~~
Enjoy while you learn Access ! Make a nice pot of hot tea or coffee, get comfy in your favorite chair and just absorb … Email me for custom programming and private training:
LearnAccessFromCrystal AT gmail.com
~~~
Post comments!
I read everything and love hearing from you.
*****
FREE book on ‘Access Basics’
(even if you are not a beginner, chances are you will discover something new)
Bill Mosca’s site:
http://ThatllDoIT.com
Allen Browne’s site:
http://www.allenbrowne.com/casu-22.html
Utter Access:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=68&Number=1595005
Access MVP:
http://www.accessmvp.com/strive4peace
~*~*~*~*~*~
Have an awesome day ~
~*~*~*~*~*~
Presentation — Microsoft Office PowerPoint
Drawings — CorelDRAW
Screen-shots — Snag-It
Audio clips — GoldWave
Video tutorial produced with Camtasia
~
Duration : 0:9:28
(more…)
Tags: Access, Crystal, Database, learn, Planning, strive4peace
Posted in access database | 15 Comments »
Sunday, October 4th, 2009
Learn how to sort and group data in a report in Microsoft Access at www.teachUcomp.com. A clip from Mastering Access Made Easy v. 2003. http://www.teachucomp.com/tutoracmain.htm – the most comprehensive Access tutorial available. Visit us today!
Duration : 0:7:33
(more…)
Tags: 2000, 2003, 97, Access, aligning, allowing, append, autoexec, basic, behavior, book, box, button, calculated, cd, character, characters, chart, charting, charts, class, classes, closing, code, combo, command, comparison, conditional, conditions, control, controlling, controls, course, courses, Data, Database, download, DVD, group, grouping, guide, how, how-to, learn, manual, micro, Microsoft, ms, Office, online, report, reports, soft, software, sort, sorting, training, Tutorial, validation, value, values, Video, view, viewing, Wildcard, writing, xp, zero
Posted in microsoft access 2003 | 1 Comment »
Sunday, October 4th, 2009
Learn how to sort and group data in a report in Microsoft Access at www.teachUcomp.com. A clip from Mastering Access Made Easy v. 2003. http://www.teachucomp.com/tutoracmain.htm – the most comprehensive Access tutorial available. Visit us today!
Duration : 0:7:33
(more…)
Tags: 2000, 2003, 97, Access, aligning, allowing, append, autoexec, basic, behavior, book, box, button, calculated, cd, character, characters, chart, charting, charts, class, classes, closing, code, combo, command, comparison, conditional, conditions, control, controlling, controls, course, courses, Data, Database, download, DVD, group, grouping, guide, how, how-to, learn, manual, micro, Microsoft, ms, Office, online, report, reports, soft, software, sort, sorting, training, Tutorial, validation, value, values, Video, view, viewing, Wildcard, writing, xp, zero
Posted in microsoft access 2003 | 1 Comment »
Sunday, October 4th, 2009
Planning a Database, part B: what to know before you create Access objects …
* Naming Conventions
– Leszynski/Reddick
* Questions
– Why Addresses and Phones are stored in separate tables
* Field Names
* Key Fields
– Primary Keys and Foreign Keys
– Natural Keys and Artificial Keys
* Relationships
click ‘watch in high quality’ below viewing window on right
* CAPTIONS*
turn Captions on or off:
click the triangle button in the lower right corner of the viewing window — CC
~~~
original music:
“Pool” by Ken Gaines (Houston, Tex) from the “Catfish Moon” CD released in 2006
http://www.KenGaines.com
~~~
Problem names and reserved words in Access, by Allen Browne
http://AllenBrowne.com/Tips.html
~~~
Leszynski/Reddick Guidelines for Microsoft Access
http://www.MVPs.org/access/general/gen0012.htm
~~~
Books by John Viescas
http://www.Viescas.com
~~~
more Access Tutorials
http://www.EverythingAccess.com/tutorials.asp
~~~
Learn Access. Enjoy! Grab a cup of your favorite beverage, relax and open your mind … send me email for private training or custom programming
LearnAccessFromCrystal AT gmail.com
~~~
Post comments!
I read everything and love hearing from you.
*****
FREE book on ‘Access Basics’
(even if you are not a beginner, chances are you will discover something new)
Bill Mosca’s site:
http://ThatllDoIT.com
Allen Browne’s site:
http://www.AllenBrowne.com/casu-22.html
Utter Access:
http://www.UtterAccess.com/forums/showflat.php?Cat=&Board=68&Number=1595005
Access MVP:
http://www.AccessMVP.com/strive4peace
~*~*~*~*~*~
Have an awesome day ~
~*~*~*~*~*~
Presentation — Microsoft Office PowerPoint
Screen-shots — Snagit
Drawings — CorelDRAW
Audio — GoldWave
Video production — Camtasia
~
Duration : 0:9:59
(more…)
Tags: Access, Caption, Close-Caption, Crystal, Database, Gaines, Ken, Key, learn, MVP, Planning, Primary, strive4peace
Posted in access database | 8 Comments »
Sunday, October 4th, 2009
Planning a Database, part B: what to know before you create Access objects …
* Naming Conventions
– Leszynski/Reddick
* Questions
– Why Addresses and Phones are stored in separate tables
* Field Names
* Key Fields
– Primary Keys and Foreign Keys
– Natural Keys and Artificial Keys
* Relationships
click ‘watch in high quality’ below viewing window on right
* CAPTIONS*
turn Captions on or off:
click the triangle button in the lower right corner of the viewing window — CC
~~~
original music:
“Pool” by Ken Gaines (Houston, Tex) from the “Catfish Moon” CD released in 2006
http://www.KenGaines.com
~~~
Problem names and reserved words in Access, by Allen Browne
http://AllenBrowne.com/Tips.html
~~~
Leszynski/Reddick Guidelines for Microsoft Access
http://www.MVPs.org/access/general/gen0012.htm
~~~
Books by John Viescas
http://www.Viescas.com
~~~
more Access Tutorials
http://www.EverythingAccess.com/tutorials.asp
~~~
Learn Access. Enjoy! Grab a cup of your favorite beverage, relax and open your mind … send me email for private training or custom programming
LearnAccessFromCrystal AT gmail.com
~~~
Post comments!
I read everything and love hearing from you.
*****
FREE book on ‘Access Basics’
(even if you are not a beginner, chances are you will discover something new)
Bill Mosca’s site:
http://ThatllDoIT.com
Allen Browne’s site:
http://www.AllenBrowne.com/casu-22.html
Utter Access:
http://www.UtterAccess.com/forums/showflat.php?Cat=&Board=68&Number=1595005
Access MVP:
http://www.AccessMVP.com/strive4peace
~*~*~*~*~*~
Have an awesome day ~
~*~*~*~*~*~
Presentation — Microsoft Office PowerPoint
Screen-shots — Snagit
Drawings — CorelDRAW
Audio — GoldWave
Video production — Camtasia
~
Duration : 0:9:59
(more…)
Tags: Access, Caption, Close-Caption, Crystal, Database, Gaines, Ken, Key, learn, MVP, Planning, Primary, strive4peace
Posted in access database | 8 Comments »
Thursday, October 1st, 2009
Learn how to use form and report design view in Microsoft Access at www.teachUcomp.com. A clip from Mastering Access Made Easy v. 2003. http://www.teachucomp.com/tutoracmain.htm – the most comprehensive Access tutorial available. Visit us today!
Duration : 0:2:18
(more…)
Tags: 2000, 2003, 97, Access, book, cd, class, classes, course, courses, Database, design, download, DVD, Form, Forms, guide, how, how-to, learn, manual, micro, Microsoft, ms, Office, online, rectangle, referential, relational, relationships, renaming, report, reports, requiring, resizing, response, responses, result, rule, ruler, rules, run, running, selecting, set, setting, size, sizing, snap, soft, software, sort, sorting, spacing, SQL, startup, storage, subreport, subreports, switchboard, tab, Table, tables, time, top, training, Tutorial, unmatched, view, xp
Posted in microsoft access 2003 | 1 Comment »
Tuesday, September 22nd, 2009
Learn how to create a relational database table in Microsoft Access at www.teachUcomp.com. A clip from Mastering Access Made Easy v. 2003. http://www.teachucomp.com/tutoracmain.htm – the most comprehensive Access tutorial available. Visit us today!
Duration : 0:7:53
(more…)
Tags: 2000, 2003, 97, Access, aligning, allowing, append, autoexec, basic, behavior, book, box, button, calculated, cd, character, characters, chart, charting, charts, class, classes, closing, code, combo, command, comparison, conditional, conditions, control, controlling, controls, course, courses, create, creating, criteria, crosstab, Database, datasheet, date, default, delete, deleting, download, duplicates, DVD, guide, how, how-to, learn, manual, micro, Microsoft, ms, Office, online, relational, soft, software, Table, tables, training, Tutorial, xp
Posted in microsoft access 2003 | 4 Comments »