Access User Interface

• MS Access SQL VBA Ribbon, File, Save a Database as Templates, Home, Create, External Data, Database Tools, Contextual Tabs, Quick Access Toolbar, Object Navigation Pane, Access Work Surface, Access Option Dialog Box, Object Overview, Tables  Queries,  Forms,  Reports, Macros & Modules, Process Overview, Exercise: Getting Around the Access Environment, Create Database using a wizard

Fundamentals

• Approach to Database Design, Top down Database Design, Bottom up Database design, Reality, Gather Information, Data Mapping, Sample Data Map, Normalization, First Normal Form, Second Normal Form, Third Normal Form, Table Relationship

Table & their View

• Datasheet View, Selection Tools, Table Layout Tools, Sorting & Filtering Tools, Print Records, Record Navigation, Working in Datasheet View, Working with Table in Datasheet View, Design View, Open a table in Design View, Design View layout

Tables

• Creating an Access Database, Creating a New Database, Data Types, Determine Data Type, Create a Table in Design View, Delete a Fields, Rename a Table, Linking Table from External Source, Import table from other database, Tables and Templates and Application Parts

Queries

• Definition & Purpose, Types, Views, Select Queries with criteria, Logical Operators, Group & Total with Queries, Total Row with group By, Action Queries, Make Table Queries    Append , Queries,     Update Queries, Delete Queries Creating Crosstab Queries, Delete Queries, Rename Queries

Form

• Definition & Purpose, Layout Design & Views, Adding a Header & Footer, Adding Logo to the Header, Adding a Title to the header, Arranging Filed on a form, Spacing Objects o a form, Alter a Form, Remove form Control, Format Forms, Adding Data Record in Form View, Form Record Navigation, One Click Forms, Basic Data Entry Form, Datasheet Form, Split Form, Create a Form with Form Wizard

Reports

• Definition & Purpose, Views, Report Header, Page Header, Group Header, Details Group Footer,   Page Footer, Report Footer, Adding a Report Header/Footer, Adding a logo to the Header, Adding a Title to the Header, Adding fields to Reports, Add Calculated Fields, Arranging Fields on a Report, Resizing the Details Sections, Grouping 7 Sorting, Setting Properties on a Report, Report Property Setting, Section Property Sheet, Object Property Sheet, Adding Records Counts, Special Report Fields, Dates, Page Numbering, Controls, Application Parts, Deleting a Report, Formatting a Reports, One Click Report, Formalize the Relationship between Tables

Relationship

• Data Type and Relationship, Views, One Click Report, Formalize the Relationship between Tables

Macro

• Open a Table, Form and Record, Run a Query, Print a Report, Running a Macro, Creating Simple Macros

Completing the Desktop Application

• The Navigation Form, Running Macros from a Navigation Form, Setting the Navigation Form as a Default Form, Creating a navigation Form, Splitting the database, Encrypt with password, Distributing the Front-End Database, Database Maintenance, Compact & Repair, Backup recovery a database, Maintain Backup Compatibility