Microsoft Access Introduction
Training
In Norwich
Description
-
Type
Training
-
Location
Norwich
-
Duration
2 Days
This course is designed to give delegates an understanding of some of the major features and functions within Access and the advantages of using a relational database running under Windows. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given. Suitable for: Designed for those who need to improve their understanding of and abilty to use Access.
Facilities
Location
Start date
Start date
About this course
A working knowledge of PCs and Windows is assumed gained by attendance on a Jarrold Training PCs, Windows and Internet course, or equivalent workplace experience.
Reviews
Course programme
Microsoft Access Introduction
Two Day Course
Course Aims:
This course is designed to give delegates an understanding of some of the major features and functions within Access and the advantages of using a relational database running under Windows. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.
The course takes a Case Study approach in which a database will be conceived, designed and implemented during the two days. All material will be taught within the context of the developing database. Following the course delegates will be able to design and implement their own relational database in Access.
Assumed Knowledge:
A working knowledge of PCs and Windows is assumed gained by attendance on a Jarrold Training PCs, Windows and Internet course, or equivalent workplace experience.
Course Outline:
Course Introduction
· Starting & exiting Access
· The Access screen
· The database control window
· Accessing help
Creating a Database
· Database concepts & planning
· Designing & creating a database
· Different database components
Creating Tables
· Field names & data types
· Setting the field properties
· Building indexes
· Setting the primary key
· Saving a table
· Changing the table design
Datasheet View
· Using datasheet view
· Changing datasheet view
Creating Forms
· Creating an AutoForm
· Using Form Wizard
· Working with records: adding, finding, editing, deleting and sorting
Enhancing a Form
· Selecting controls
· Moving controls
· Resizing controls
· Inserting controls
· Deleting controls
· Changing the tab order
· Changing the control label text
· Formatting controls
Using the Toolbox
· Adding calculations to forms
· Inserting text onto the form
· Adding rectangles & lines
· Inserting pictures
· Using Option groups
· Using Combo boxes
· Using List boxes
Relating Tables
· Relational concepts & rules
· Relating tables
· Setting referential integrity
· Using forms with linked tables
· Using a Combo box on a form to lookup data from another table
Select Queries
· Select the fields
· Setting the criteria
· Sorting the records
· Hiding fields
· Using queries with linked tables
· Using calculated fields in queries
· Creating a parameter query
Reports
· Using Report Wizard
· Creating a tabular report
· Print preview
· Printing a report
Enhancing a Report
· Report sections
· Applying enhancements
· Controls & calculations
Other Reports
· Grouping & summary reports
· Using reports with linked tables
· Using reports with queries
· Producing mailing labels
· Merging with Word
· Analysing to Excel
Microsoft Access Introduction