INVESTONI NE NJOHURITE TUAJA DUKE U TRAJNUAR NE SOFTWARE KONTABEL

Tel: + 355 68 48 68 595 ; Email: kurseinfo@gmail.com

MICROSOFT ACCESS

HomeMICROSOFT ACCESS

KURSE

-NIVEL BAZE

Moduli 1: The Fundamentals
Describe the seven main Access 2003 objects Start Access and open a database Understand the Access Program Screen Add, Edit and Delete Records in Table View Add, Edit and Delete records in Forms Open and run a query Open and run a report Close down and exit Access

Moduli 2: Creating and Working With A Database
Understand Primary Keys Understand data types Create a database Create a table Create a query Create a form Use the form wizard Create a report using the report wizard

-NIVEL MESTAR

Moduli 3: Finding, filtering and formatting data
Find and replace information Sort records Filter records Adjust and re-arrange rows and columns Freeze fields Hide columns

Moduli 4: Working with tables and fields
Understand field properties Index a field Change a field’s data type Apply formats to number and text fields Set default values and apply field validation Create input masks Create and modify lookup fields Create value lists

Moduli 5: Creating Relational Databases – Objectives
Understand table relationships Create relationships between tables Understand referential integrity Implement and test referential integrity Understand relationship types

Moduli 6: Advanced tables
Using the Lookup Wizard Setup Lookups Without the Wizard Advanced Sorting and Filtering Working with Related TABLES Review of Advanced Tables

Moduli 7 : Advanced tables
Using TOP queries Using TOTAL Queries ACTION queries – UPDATE ACTION queries – APPEND Multi Table and MAKE TABLE ACTION Queries ACTION queries – DELETE Calculations in Queries and Formatting Results

-NIVEL I AVANCUAR

Moduli 8 :
Creating a Database and Adding Tables Creating Forms Controls and Formatting Forms Queries

Moduli 9 :
Using Criteria, Operators, and Wildcards Parameter Queries Relationships and Joins Creating Calculated Expressions Summarizing Data

Moduli 10 :
PivotTables PivotCharts Reports Designing Your Report Advanced Formatting for Reports

Moduli 11 :
Macros Printing and Exporting Reports Importing and Exporting Data