COURSE SYLLABUS

SUBJECT:MS. ACCESS 2007 LEVEL II

CREDIT:3 CREDITS

TOTAL HOURS:48 HOURS

PERIOD:16 WEEKS (3 HOURS/WEEK)

COURS OUTLINE:

Part I

1- Table, Query, Form, Report, Primary key, Foreign key, Index, Relationship review

2- Macro

PartII

3- VBA Programming fundamentals

4-VBA Data types and Procedures

5- Understanding the Access Event

6-Using expression in Query and VBA code

7. OOP with VBA

Part III

8- Accessing Data with DAO

9- Accessing Data with DAO

10-Working with External Data

11-Integrating Access with Other Applications

I-Course Description:

This course has been designed to equip IT students with enough kills to develop and distribute Ms Access applications. It covers the most advanced features of Ms. Access 2007 including Macro, VBA code, Data Access with ADO and DAO, Working with external data, and integrating Access with Other Applications.

II-Course Objectives:

The Student undertaking this course will be able:

  • To use Macro to work with objects
  • To Understanding VBA code and use VBA code to access data
  • To Use SQL statements to access data
  • To Use ADO tool to manipulate data
  • To Use DAO tool to manipulate data
  • To distribute Access Applications
  • To work with external data
  • To integrate Access with Other Applications

III-Course Assessment:

Discipline & Attendance10%

Homework / Assignments20%

Midterm exam20%

Final examination 50%

Total 100%

VI-Course Detail:

Weeks / Description / Hours
1 / Chapter 1:Review
1.1.Table and properties
1.2.Tables relationship
1.3.Query
1.4.Form
1.5.Report / 3
2 / Chapter 2: Access 2007 Macro
2.1.Understanding Access Macro
2.2.Creating macros
2.3.Assigning macros to objects on Form
2.4.Generating macro actions
2.5.Setting macro conditions
2.6.Creating AutoExec macro
Exercises / 3
3 / Chapter 3: VBA Programming Fundamentals
3.1.Understanding the limitations of Macro
3.2. Introducing to VBA
3.2. When to use macro and when to use VBA
3.3.Understanding modules & create modules
3.4.Creating VBA Programs
3.5.If/else statement
3.6.Loops
Exercises / 3
4 / Chapter4:VBA Variables, Data types and Procedures
4.1.Uderstanding variable
4.2.Declaring, naming,and using variables
4.3.Working with data types
4.5.Understanding variable scope
Exercises / 3
5 / 4.6.Understanding sub and function
4.7.Creating and calling a sub procedure
4.8.Creating and calling a function
4.9.Passing parameters to a function
Exercises / 3
6 / Chapter5:Understanding Ms. Access Events
5.1.What is event?
5.2.Form events
5.3.Mouse and keyboard events
5.4.Data events
5.5.Control event procedure
Exercises / 3
7 / Chapter 6:Using expression in Query and VBA code
6.1.Understanding expression
6.2.Creating an expression
6.3.Special identifier operators and expressions
6.4.Special keywords and properties
6.5.Using functions in Access
6.6.Using DLookUp() for lookup tables
Exercises / 3
9 / Chapter 7:Object-Oriented Programming(OOP) with VBA
7.1.Benefits of OOP
7.2.Class module
7.3.Understanding class and object
7.4.Class properties and methods
7.5.Accessing object properties and methods
7.6.Class events
Exercises / 3
10 / Chapter 8:Accesing Data with DAO(Data Access Object)
8.1.What is DAO?
8.2.Opening database file without and with password
8.3.Using SQL statements to retrieve, insert, update, an delete data from a database
Exercises / 3
11 / 8.4.Using Recoredset object of DAO
8.5.Creating Ms.Jet Database file, retrieving tables and fields names
8.6.Deleting, and adding tables, and fields,
Exercises / 3
12 / Chapter 9:Accessing Data with ADO(ActiveX Data Object)
9.1.What is ADO?
9.2.Opening database file
9.3.Using ODBC driver
9.4.Connecting to SQL Server
Exercises / 3
14 / 9.5.Retrieving data from Ms.Access
9.6. Retrieving data from SQL Server
9.7.Inserting, deleting, and updating data using SQL statements
9.8.Inserting, deleting, and updating data using ADO recordset object
Exercises / 3
15 / Chapter 10:Working with External Data
10.1.Linking external data: Access and ODBC data source
10.2.Working with linked tables: setting view properties, setting relationship, optimizing linked tables
10.3.Using code to link tables in Access
Exercises / 3
16 / Chapter 11:Integrating Access with Other Applications
11.1.Using Automation to integrate with Office: getting Automation Reference, creating automation objects, working with automation objects
11.2.An Automation Example Using Ms. Word: creating instance of Ms. Word object, creating a new document, inserting data by using bookmarks, activating instance of Ms. Word, moving cursor in Ms. Word
Exercises
11.3.Collecting data from Ms. Outlook 2007: creating e-mails, and managing replies / 3
Total Hours / 48

VII- References