Live chat by BoldChat

Training on Access Database

If you are new to databases or a self taught and want to expand your knowledge our short courses can help you. Learn to create and maintaining databases using Microsoft Access 2003, 2007 or 2010. You may require some one on one database training or we can tailor more formal training based on some of the following features.

Access Database Course Objectives

  • Database design
  • Create and populate tables
  • Table relationships
  • Search and filter data
  • Create queries
  • Create forms for data entry
  • Create and print reports
  • Import data from other sources

Course Details:

Exploring Access

Start Access, Open & Close a Database, Use the Ribbon, Use the Contextual Tabs, Use Toolbar, Use Database Objects, Use Navigation Pane, Open a Database Object, Use & Close All Tabbed Documents, Use the Status Bar, Use the Options Dialog Box, Exit Access

Creating Tables

Use Database Templates, Create a Database, Design Tables, Create a Table in Datasheet View, Create a Table in Design View, Add Field Names, Assign Data Types, Save a Table, Add a Field Description, Set a Primary Key, Use Multi-valued Fields

Working with Tables

Use Datasheet View, Navigate Fields in Tables, Add & Move through Records, Select, Editing, Save, Delete Records

Editing Tables

Change Row Height & Column Width, Change Font Attribute, Change Cell Effect, Use Alternate Background Colors, Select, Move, Hide, Unhide & Freeze a Column

Finding & Filtering Data

Sort Records, Find Specific Records, Find Records using Wildcards, Use Replace, Use Filter By Selection, Apply / Remove a Filter, Use Filter Exclude Selection, Use the Search Box, Use Quick Filter, Use AutoFilter

Printing Data

Change Page Setup, Use Print Preview, Print Selected Records

Creating Relationships

Use Related Tables, Create a Relationship between Tables, Set Referential Integrity, View Sub datasheets, Delete a Join Line

Using Simple Queries

Use Queries & Recordsets, Simple Query Wizard, Create Query in Design View, Open a Query, Add a Table, Join Tables, Run a Query

Modifying Query Results

Sort a Query, Add Criteria to a Query, Hide a Field in a Query, Display a Totals Row in a Query, Add a Record using a Query, Print a Query

Creating Basic Forms

Use Form Button, Add a Record using a Form, Use the Calendar for Date Picking, Use the Form Wizard, View Records in a Form, Print Records in a Form, Base a Form on a Query

Creating Basic Reports

Use Report Button, Use Print Preview, Print Pages of a Report, Report Wizard, Change Views in a Report, Group & Summarize Report Data, Base a Report on a Query

Modifying Tables

Insert a Column into a Table, Insert a Lookup Column, Insert a Hyperlink Column, Create a Many-to-Many Relationship

Setting Field Properties

Limit Field Size, Set Number Formats, Set Date/Time Formats, Setting Yes / No Formats, Set Default Values, Set Validation Rules, Create an Input Mask - Wizard, Create an Input Mask Manually, Create a Custom Input Mask, Lookup List, Modify Lookup Properties

Using Operators in Queries

Use Comparison Operators, Use an & Condition, Use an Or Condition, Use the Between & Operator, Use a Wildcard Character

Designing Advanced Queries

Set Top Values in a Query, Create a Calculated Field, Format a Calculated Field, Create a Function Query, Create a Parameter Query, Multivalued Fields, Create a Concatenation in a Query, Filter a Query

Using Advanced Query Wizards

Use the Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard

Manipulating Form Controls in Design View

Select, Delete, Size Controls, Set Control Margins & Padding, Hide the Ruler, Disable Snap to Grid Feature, Display Field List, Add a Field, Move Part of a Paired Control, Align & Space Controls

Using Design View

Add a Label, Add an Image, Add a Rectangle, Add a Line, Edit an Unbound Control, Use Multiple Undo / Redo in Design View

Using Editing Tools

Change the Font, Change Character Format, Change Fill & Background Colors, Format Lines & Borders, Apply Special Effects, Conditional Formatting, Use Format Painter, Use AutoFormat, Use Error Checking, Run Spelling Checker, Set AutoCorrect Options, Add AutoCorrect Entries

Using Advanced Form Design

Use Forms in Design View, Create a Combo Box, Edit List Items, Create a List Box, Create an Option Group, Add a Logic Control, Set the Tab Order Automatically, Set the Tab Order Manually, Add a Form Header & Footer, Create a Blank Form

Using Advanced Report Design

Add Report Sections in Design View, Create a Calculated Control, Create a Running Summary, Insert a Date / Time Control, Insert a Page Break, Chang the Report Margins, Use the Label Wizard, Create a Report without Using a Wizard

Request a Quote

Featured Projects

Technical Expertise

Awards

Our Partners

Customer Talk

  • upSage Pastel has streamlined our financial operations. We have achieved stability with the system now and are satisfied with your support.up

    -Principal
    Institute of Social Works

  • upI would like to thanks and congratulate to you and your team who has performed very nice and swift action to fulfil this project in less time and efficient way.up

    -CEO
    Capital Markets and Securities Authority (CMSA)

  • upI have been impressed with your level of technical ability and the ease with which we can work together. I will certainly be recommending Web Technologies to others who need fast and well delivered applications.up

    -Executive Director
    Tanzania Education Authority (TEA)

  • upWe are very happy with the service Web Technologies provides. They are contactable twenty four hours a day, seven days a week and their response times are excellent, which keeps our down time to a minimum.up

    -Johannes Kahwa
    It Manager, Social Security Regulatory Authority ( SSRA)

  • upWeb Technologies have been overseeing the development of our University Website , Software and networks for over 5 years. Work is always completed to a high standards, on time and to budget. We have been very appreciative of the patient, friendly and reliable service.up

    -Elibariki Mushi (Head of ICT)
    Kampala International University (KIU)

Be Social with us

Terms of Service | Terms of Use | Privacy Policy | Connectivity

Articles | FAQ | Sitemap | Inquiry | Client Speaks | Contact | Blog | Partnership