Introducing Access
An overview of the power and benefits of computer databases.
Terminology.
Tour of the Access initial screen.
Menus and toolbars.


Tables
Creating tables.
Setting field attributes.


Data Entry & Editing
Adding and editing records.
Navigation through data.
Finding specific records.
Sorting and filtering data.


Relational Databases
What they are and why relational databases are useful.
How data stored in different tables can be related.


Queries
Using SELECT Queries to build new record sets.
Sorting and basic filtering.
Deriving new information in queries.
Combining data from different tables through a query.


Forms
Creating forms with and without the Access Forms Wizard.
Using queries and tables as the basis for forms.
Introducing object properties within forms to change data and display characteristics.

Reporting
Creating simple reports with and without the Access Reports Wizard.
Introducing object properties within forms to change report definitions.
Printer set up and printing.


Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

Course Overview:

As a new user, with little or no experience of Microsoft Access, the topics covered on this course introduce you to the main concepts involved in creating and maintaining a simple relational database.

Course Duration:

Course Pre-requisites:

• Create a basic database structure.
• Create standard forms for inputting and amending your data.
• Use simple queries to manipulate your data.
• Produce basic Access reports.

Price Band:

 Specialised