Plan obuke:
Module 1: Relationships
- Review
- Referential Integrity
- Relationships
- A Few Words about Naming Conventions
Module 2: Queries
- Query Design View
- Review of Select Queries
- Review of Select Queries with Criteria
- Logical Operators
- Parameter Queries
- Action Queries
Mobile 3: Table Functions
- Importing Data
- Linking Tables from External Sources
- Import Tables from Other Databases
- Tables from Templates and Application Parts
Module 4: Forms
- Design View
- Formatting
- Tab Order
- Create Forms with Application Parts
- Creating a Subform
- Alter a Form
Mobile 5: Reports
- Design View
- Report Sections
- Arranging Fields on a Report
- Resizing the Detail Section
- Grouping and Sorting
- Setting Properties on a Report
- Special Report Fields
- Controls
- Subreports
- Application Parts
- Deleting a Report
- Formatting a Report
Module 6: Macros
- Macro Basics
- Running a Macro
Module 7: Completing the Desktop Application
- The Navigation Form
- Running Macros from a Navigation Form
- Setting the Navigation Form as the Default Form
- Splitting the Database
- Distributing the Front-end Database
- Database Maintenance
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama u toku trajanja kursa
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
Poželjno predznanje:
Introductory-level knowledge and skills working with Microsoft Access.
Dalje usavršavanje:
Analyzing Data with Excel (MS20779)