Plan obuke:
Module 1: Quick Overview of the Access User Interface
- Access Ribbon
- Quick Access Toolbar
- Object Navigation Pane
- Access Work Surface
- Object Overview
- Process Overview
- Create a Database Using a Wizard
Module 2: Fundamentals
- Questions to Ask Before You Start
- Approaches to Database Design
- Gathering Information
- A Few Words about Naming Conventions
- Normalization
- Table Relationships
Mobile 3: Tables and Their Views
- Definition and Purpose
- Datasheet View
- Design View
Module 4: Tables
- Creating an Access Database
- Data Types
- Create a Table in Design View
Mobile 5: Queries
- Queries
- Select Queries
- Select Queries with Criteria
- Logical Operators
- Group and Total with Queries
Module 6: Forms
- Forms
- Alter a Form
- Form Record Navigation
- Layout View and Design View
- One-click Forms
- Form Wizard
Module 7: Reports
- Reports
- Report Wizard
Poželjno predznanje:
- Familiarity with using a personal computer, mouse, and keyboard.
- Comfortable in the Windows environment.
- Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
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
Dalje usavršavanje:
Advanced Microsoft Access 2019 (MS55280)