Course Content

In this course, the concept of data base, relational data base, table creation, query creation, kinds of queries will be taught in detail. Detailed information about form and report creation, design of the widely used databases and working with data pages while making changes, broadcasting data on the web, working with macros and visual basic applications.

Evaluation

At least 3 assignments of 4 assignments must be submitted in order to take the final exam. The final grade is the total of 30% of the mid-term exam grades, 20% of the total of the assignment grades, and 50% of the final exam grade.

Coursebook

Adım Adım Access, Helen FEDDEMA, Arkadaş Yayınları, 2003

Instructional Designer

Inst. Özlem ÖZÖĞÜT ERORTA

Academic Facilitator Service

Academic facilitator service is available everyday between 09:00 and 13:00 except Saturday and Sunday.

Units

1. Beginning to work with Access 2003
2. Creating Database
3. Table Creation
4. Creating Simple Queries in Access
5. Access Forms Creation
6. Reporting Access Data
7. Database Application Design
8. Changing the Database Application Design
9. Creation of the Data Access Pages
10. Privatization of the Forms
11. Developing the Form Design
12. Developing the Report Design
13. Receiving, Connecting and Transferring Data in Access
14. Working with the selection queries
15. Working with the action queries
16. Working with SQL Queries - 1
17. Working with SQL Queries - 2
18. Using Summary Table and Summary Graphics
19. Working with Data Access Pages, XML and SharePoint.
20. Working with the Access Project
21. Automatization of the Macros and Access Application
22. Use of Access and VBA
23. Automatization of the Applications using VBA
24. After Completing Your Application- 1
25. After Completing Your Application- 2

CD-ROM

Database Management Systems Application CD-Rom will be used in this course.

Software

Microsoft Access 2003 software in Microsoft Office 2003 which was given to students in the 1st year will be used in this course.