Course Outline

Microsoft Access Level 2
Expand your database design skills as you learn more in-depth principles of table design. Learn data validation and defaulting techniques. Enhance the complexity of your queries and calculations. 6 hours
Table and Query Properties 
  • Creating charts 
  • Field size 
  • Format and decimal places 
  • Input mask 
  • Caption 
  • Default value 
  • Validation rule and text 
  • Required 
  • Description 
  • Top values 

Indexing and Lookups 

  • Multiple table design 
  • Primary key 
  • Indexed property 
  • Multiple field index 
  • Looking up key descriptions 

Expressions in Queries 

  • Expression builder 
  • Numerical expressions 
  • Formatting expressions 
  • Date and time expressions 
  • Text expressions 
  • Sorting and criteria in expressions 
Functions in Queries 
  • Getting help with functions 
  • If function 
  • Date and time functions 
  • Text functions 

Parameters in a Query 

  • What is a parameter? 
  • Multiple parameters 
  • Data typing parameters 
  • Criteria expressions with parameters 
  • Recording parameters 
  • Parameter as a field 
  • Parameters in expressions field 

Exporting and Importing Data 

  • Access databases 
  • Excel spreadsheets 
  • Word documents 
  • Delimited ASCII 
  • Fixed ASCII 
Prerequisites:  Access Level 1 or equivalent experience.
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600