Microsoft Access Basics

Overview of Topics/Behaviors

 

Remarks : Access is a modern day Database program, which is very powerful in its ability to manage data for report writing purposes. Whether you wish to maintain a large database of people, services or any entity that you might think of, Access will be the program of choice for manipulating data. The program represents an extremely powerful and useful program for almost anyone using computers.

Topics

Data Base Terms and Concepts, File, Record, Field etc.

- tables, forms and reports and the like, what these are, differences etc.

- Overview of the Access command menus, invoking the menus & Toolbars;

Opening Database Files using sample databases, entering records

- Viewing capabilities, sorting and filtering records

Overview of Tables & Forms viewing your data via forms

- Viewing data via reports, using the report wizard

- Creating quick reports and forms via the wizard

Creating a Data Base Structure The basics of a database structures;

- Record structure, field types, importance etc

  • Entering field names and attributes, key fields & their use;
  • Brief overview of input masks, setting up indexes, formats etc.
  • Overview of validation rules and validation text,

- Table view and entering, modifying & saving data,

- Changing Column sizes, moving Columns, Moving around a data base file;

- Quick filter and searching for a given Value/Field

Brief Overview of Forms & Reports

  • Purposes of Forms and Reports, Types of Forms, Types of Reports;
  • Creating, Modifying, Deleting Forms using the Wizard, Printing with Forms

- Overview of the design facility within Access, navigation buttons & design capabilities

  • Entering Special Fields, Lists and Combo Fields, Lookup fields, Calculated Fields;
  • Creating Navigation Buttons, Getting to know the Properties of Objects;

- Creating, Modifying, Deleting Reports using the Wizard, Printing Reports

  • Report Fields, Creating Calculated Fields, Using the Expression Builder etc.;

Brief Overview of Queries Why use Queries, uses in forms and reports, types of queries

- Creating, Modifying, Deleting, Viewing Queries,

  • Query criteria, creating and using calculated fields, parameter fields etc.
  • Using Queries for Forms and Reports

Additional Topics (Time permitting) other topics include: Linking tables & forms, types of queries (delete, update etc) exporting/importing to/from Excel & Word, other topics.

CLOSE WINDOW