|
|
|
|
Search using the drop down list, or further refine your search using keywords.
|
|
|
|
|
 |
|
|
Microsoft Access: Introduction
Business Skills Courses |
|
|
|
Microsoft Access is a popular database application which allows you to store, analyse and sort information. This introductory course covers how to use an existing database, confidently search and find information and to use Access to prepare and format reports, lists and labels.
The course will also introduce you to relational database concepts. This outline is based on Microsoft Access 2007. If you are using a different version of Access, please give us a call on 020 7359 9855.
|
|
Introduction to databases
• Database concepts and principles
• What is a relational database?
• Principles of normalisation
• Using the help facility in Access
Essential features
• The new interface
• The Office button
• Quick Access tool bar
• The Ribbon
• Tabs and context tabs
• Page views
• Workspaces
• Readability
Creating tables
• Defining fields
• Formatting fields
• Changing field order
• Field properties
• Adding and deleting data
Using queries
• What is a query?
• Designing select queries
• Using calculations in queries
• Using filters to find data
• Sorting data
• Finding data types |
Creating a report
• Using the Report Wizard
• Designing a report
• Formatting a report
• Editing a report
Creating forms
• Designing and understanding forms and subforms
• Customising forms
• Using Form Wizards
• Editing forms
Printing
• Printing individual records
• Printing a selection of records
• Creating and printing labels
Questions and answers |
|
If you'd like to book by phone, or discuss your requirements;
 Courses provided by partners Media Training.
|
|
|
|
|
|
|
