Length: 30 Hours
Prerequisite: Basic Database technology understanding
Cost: $175

1. Definition of a Database
2. Definition of a DBMS
3. Starting Access, short Access tour
4. Creating a new database
5. Overview of Access screen
6. Wizards , the Office Assistant ,and help
 

Tables

1. Database design issue
2. Tables wizard
3. Table Field properties
4. Relations
5. Primary key
6. Entering data into tables
7. Modifying table properties
8. Data types and validation

Forms

1. Objective  of  using  forms
2. Overview  of  form  sections  and  properties
3. Creating  forms  using  the  form  wizard
4. Entering,  editing  and  deleting  data  via  forms
5. Overview  of  form   properties
6. Formatting  controls
7. Creating  labels,  text  boxes
8. Overview  of  controls   properties
9. Creating  embedded  forms  :  form / subform
10.   Calling  a  form  from  within  another  form

Queries

1. A simple query
2. Criteria in Queries
3. Multitable Queries
4. Sorting data in a query

Reports

1. Report concept
2. Creating  reports  with  the  report  wizard
3. Previewing  and  printing  a  report
4. Customizing  reports
5. Numbering  the  pages  of  a  report
6. Calculation in reports

Intermediate forms

1. Using list or combo boxes in forms
2. Manual combo boxes programming
3. Tabs, Image control
4. Option groups
5. Images as a part of data in databases
6. More about forms and sub forms
7. Using calculated controls in forms
8. Enabled and locked
9. Filtering records by selection
10. Graphic elements in forms
11. Sinking and rising and auto formatting
12. Changing  the  form  caption
13. Deciding  whether  the  form  is  to  be  displayed  as  single  form  or  datasheet
14. Adding  and  removing  the  Scroll  Bars,  Record  Selector  and  Navigation  Buttons  to  a  form
15. Resizing  the  form  size  automatically
16. Choosing  the  border  style  for  the  form
17. Showing  and  hiding  the  form's  control  box,  maximizing  and  minimizing  buttons
18. Choosing  the  table  or  query  where the  form  will  take  data  from
19. Allow  and  disallow  records  adding  and  editing
20. Objective  of  each  control  type :  label, text  box,  combo  box,  list  box,  option  button,  check  box,  and  command  button
21. Creating  controls  in  a  form
22. Customizing  control  properties  in  a  form

Intermediate reports

23. calculation in reports
24. Dynamic controls on reports
25. Adding sub reports to reports
26. Producing multi-column printing

Intermediate queries

1. Parameter queries
2. Delete and append queries
3. Update query
4. Expressions in queries

Exploring Macros

1. Working with Macros
2. Access three programming languages
3. Using SQL
4. Looking at macros
5. Conditional Branching
6. Macros that Alter properties
7. Placing the macro on the form
8. Setting the startup options
9. Creating switchboard
10. Starting the switchboard automatically when database opened
11. Creating and editing the autoexec Macro
 

Advanced Relationships
1. One to one relationship
2. One to many relationship
3. Many to Many relation solution
4. Referential integrity

Introduction to Visual basic For Applications

1. Learning the basics of programming
2. Passing variables and parameters
3. Database Example done by the Student

Introduction to ActiveX and controls OLE
1. Using OLE controls
2. Registering ActiveX Controls
3. Using ActiveX controls
 

Repairing and compacting a database
1. when to repair
2. repairing a damaged database
3. When to compact a database
4. Compacting a database
5. Setting a database Password
 
 

NetCom Systems
For Address - Location Map and Telephone Numbers: Click Here

http://www.NetLiban.com