Microsoft access course outline

Understand context tabs in the ribbon. Understand the Quick Access Toolbar and how to customize. Understand the Navigation Pane. Understand the objects and creation Understand the objects and creation process. Understand the Access work surface. Understand how to create databases using a wizard. Module 2: Fundamentals This module explains how to think about some database fundamentals before diving into database creation. Understand common approaches to database design: top-down and bottom-up.

Go from paperwork and data samples to categorized data data mapping. Understand naming conventions for tables and other objects.

Understand what normalization is. Understand some basic concepts of normalization and how to apply them. Understand primary and foreign keys. Understand relationships and establishing them among tables. Work with tables in Datasheet view. Add and Edit data records in Datasheet view. Understand the purpose of Design view.

Module 4: Tables This module explains how to work with tables in Microsoft Access. Create a table in Design view. MAIN CONCEPTS COVERED Creating your own security inside the database - Making a user table - Logon form - User groups with permissions Controlling the "work flow" in your database - Sales rep enters a work order - Service tech performs the work - Manager approves it - Sales rep follows up - Control who can enter data into what fields - Buttons to move to the next step in the process - Locking access to data once that step is completed - Sending an Email notice with Outlook for the "next step" - Creating a system log to watch everything your users do Determining which users can access what forms, fields, data - Sales reps can't edit each others customers - Service techs can't see customer data - Users can't bypass the "work flow" - Managers can edit everything - Admins can supervise and change access rights - Who can browse customers?

Field notation - Create and edit databases in VBA - Define global constants - Create and work with RecordSets to read user info - Use a recordset to read from an external database with a password. Lesson 1 Set up the database Set up customer table with encryption fields Create customer form for public data Create customer form for encrypted data Why Split Your Database Replace All PreviousControl Docmd.

FindNext CustomerF Width Twips DoCmd. MoveSize SetWarnings ColumnWidths Property Listbox. OpenQuery Printing Reports DoCmd.

Welcome 1. Images Bound v. Embedding When and when not to store objects Access Attachments 2. Empty Controls collection RGB color function Bill Summary Form 1 Create bill summary listbox Add header labels Bill Summary Form 4 Add combo box for due date filter What's past due? Past due 30 days? What's coming up in the next week, month? Payment Form 2 InputBox to prompt for payment amount Payment Form 3 Refresh all forms on updated balance Hide payment button if balance is zero Recurring Bills 3 Target Date Loop to process recurring bills Bug Fixes 2 Show only Active Payees Warning if payee has a balance on inactive Checkbox on payee form to filter payees Lesson Summary Database Walk-Thru Range of Characters [A-P] Not in a range [!

A-P] IN clause OpenForm RecordSource Me. Caption property RecordSource OpenForm Where Criteria Openform Set value across forms Forms! FieldName Close Refresh DoCmd.

OpenReport acViewPreview Application Outlook. Number Err. Description Err. Clear Beep DoError Error Box Refresh NameSpace Outlook. Write Command Response. Value SaveToFile Count SaveAsFile Command Application Remove the Excel Reference and Code Lesson 12 Accounts Receivable Lesson 14 Current Loan Value Report.

Access Beginner 1 What is Microsoft Access? Why use a database? What is a Form? What is a Report? No order info in customer table Separate tables Draw your forms out Gather your printed reports Saving layout changes Moving a column in datasheet view Name Control. MousePointer HourGlass AddNew Dirty 3.

FileDialog CurrentProject. GetExtensionName 2. DriveExists GetDrive vs. Plan Database Tables Relationships Reports 2. Requery 4. Unit Form 1 Build Unit Form 7. Form Footer DateDiff Function Scheduling 3 Filter Boxes for Dates Work Order Report 2 Labor Subreport Introduction B. Welcome C. Dymo Labelmaker 1 X. Dymo Labelmaker 2 Y. Guest Logoff. Access Access Access Seminars. Access Index Page. Welcome to the Access Index page. Access Beginner 1.

Access Beginner 2. Access Index - Beginner. Access Beginner 3. Access Beginner 4. Access Beginner 5. Access Beginner 6. Access Beginner 7. Access Beginner 8. Access Beginner 9. Access Index - Expert. Access Expert 1. Access Expert 2. Access Expert 3. Access Expert 4. Access Expert 5. Access Expert 6.

Access Expert 7. Access Expert 8. Access Expert 9. Access Expert Access Index - Advanced. Access Advanced 1. Access Advanced 2. Access Advanced 3. Access Advanced 4. Access Advanced 5. Access Advanced 6.

Access Index - Developer. Access Developer 1. Access Developer 2. Access Developer 3. Access Developer 4. Access Developer 5. Job role: Developer. Features: none. Find a learning partner. Browse All Sessions. Skills gained Understand database relationships. Work with table relationships. Work with queries at an advanced level. Work with forms at an advanced level. Work with reports at an advanced level. Work with macros. Complete the desktop application with the navigation form.

Prerequisites Introductory-level knowledge and skills working with Microsoft Access. Introductory-level knowledge and skills working with Microsoft Access. Course outline Module 1: Relationships This module explains how to work with relationships in Microsoft Access.