Bu eğitimde katılımcıların Access’yi kullanarak veritabanı oluşturabilmeleri, veritabanı yönetiminde dikkat etmeleri gereken temel kuralları, tablolar arasındaki ilişki türlerini öğrenebilmeleri ve tablo, sorgu, form ve rapor kavramlarını etkin bir şekilde kullanabilmeleri hedeflenmektedir.
Temel Access Eğitimi 12 Saat (2 Gün) sürmektedir.
Module 1: Getting Started
- About Relational Databases and Access
- Launching Access
- Using the Office Menu
- Database Components
- Using the Navigation Pane
- Getting Help
- Opening and Closing Access Databases
Module 2: Creating a Database
- About Data Types
- Creating a Table in Datasheet View
- Creating a Table in Design View
- Using Field Templates
- Setting Primary Keys
- Exploring Datasheet View
- Editing and Selecting Table Data
- Adding and Deleting Records
- Find and Replace
- Undo and Redo
- Types of Relationships
- Referential Integrity
- Sorting a Table
Module 3: Sharing Your Data
- Import Your Excel Spreadsheet into Access
- Copying the Table Structure and Data
Module 4: Filters and Queries
- About Filters
- Common Filters
- Filter by Selection
- Advanced Filter
- Using Filter For
- Using the Filter by Selection Button
- Using the Filter by Form Button
- Differences between Queries and Filters
- Adding Calculated Fields
- Grouping Records
- Creating a Parameter Query
- Creating an Inner /a Self Join Query
Module 5: Forms
- Creating AutoForms
- Creating Forms Using Form Wizard
- Using Design View
- Adding Controls to Forms
- Applying Conditional Formatting
- Using the Toolbox
- Adding a Textbox
- Adding a Label
- Adding Option Buttons
- Adding Check Boxes
- Using Combo Boxes and List Boxes
- Adding Calculated Fields
- Adding Graphic Elements
- Creating Subforms
Module 6: Reports
- Creating Auto Reports
- Creating a Report Using Report Wizard
- Creating Repots in Design View
- Resizing Sections on a Report
- Formatting Controls
- Inseting Date and Time
- Inserting Page Numbers
- Adding Graphic Elements
- Sorting and Grouping Reports
- Using the Page Breaks
- Creating a Calculated Control
- Printing a Report
İçerik Dosyalarına Aşağıdaki Linklerden Ulaşabilirsiniz.