Plan obuke:
Module 1: Quick Overview of the Access User Interface
- Access Ribbon
- FILE
- HOME
- CREATE
- EXTERNAL DATA
- DATABASE TOOLS
- Contextual Tabs
- Quick Access Toolbar
- Object Navigation Pane
- Access Work Surface
- Access Options Dialog Box
- Object Overview
- Tables
- Queries
- Forms
- Reports
- Macros and Modules
- Process Overview
- Create a Database Using a Wizard
Module 2: Fundamentals
- Questions to Ask Before You Start
- What Is the Purpose of the Database?
- Who Will Use the Database?
- What Kind of Output Is Needed from the Database?
- What Process Is the Database Replacing or Improving?
- Approaches to Database Design
- Top-Down Database Design
- Bottom-Up Database Design
- Reality
- Gather Information
- Data Mapping
- A Few Words about Naming Conventions
- Normalization
- Table Relationships
- Relationship Types
Mobile 3: Tables and Their Views
- Definition and Purpose
- Datasheet View
- Selection Tools
- Table Layout Tools
- Sorting and Filtering Tools
- Print Records
- Record Navigation
- Working in Datasheet View
- Design View
- Open a Table in Design View
- Design View Layout
Module 4: Tables
- Creating an Access Database
- Data Types
- Create a Table in Design View
- Delete a Field
- Rename a Table
Mobile 5: Queries
- Definition and Purpose
- Types
- Views
- Select Queries
- Logical Operators
- Group and Total with Queries
Module 6: Forms
- Definition and Purpose
- Views
- Form Record Navigation
- Layout View and Design View
- One-Click Forms
- Basic Data Entry Form
- Basic Multi-Record Form
- Datasheet Form
- Split Form
- Form Wizard
Module 7: Reports
- Definition and Purpose
- Views
- One-Click Report
- Report Wizard
- Create a Report Using the Report Wizard