Courses / Access Fundametals
Access Fundametals
- Provider
- Open Door IT Consultancy & Training Ltd.
- Summary
- Introduction to Access including creating simple database
About the Course
- Target
- New Users to Access
- Entry requirements
- Basic use of Mouse and Keyboard
- Outcome
- To be confident in the basic use of Access including Using Tables , Creating A Database Table, Setting Relationships Between Tables, using Database Forms,Querying Information and Creating Reports
- Content
- Basics
Database terminology
Relational databases
Starting access
Areas of the screen
Opening an existing database file
Creating a new database file
The database window
Using Tables
The table window
Adding a record
Deleting a record
Editing data in a field
Copying information
Searching for specific records
Sorting records
Resizing columns and rows
Moving field columns
Freezing & unfreezing columns
Hiding & unhiding columns
Creating A Database Table
Creating a table
The Primary key
Data types for fields in a table
Field properties
Input masks
Data validation
Adding a field to an existing table
Saving your table design
Setting Relationships Between Tables
Types of relationships
Creating the relationships
Enforcing referential integrity
Database Forms
Creating a form with the wizard
Entering & editing information
Adding & removing controls
Changing a controls appearance
Editing the form layout
Creating a combo box
Saving a form
Querying Information
Creating a single table query
Creating a multiple table query
Adding criteria to select the records required
Creating Reports
Creating a Report with the wizard
Previewing and printing a report
Creating a grouped & totals report
Changing the appearance of a report - Cost
- £200 per day at your premises with up to 6 delegates. Other prices depend on venue to be hired please contact the provider for a quotation.
- Enrolment
- Open IT Consultancy offer IT training courses anywhere in East Anglia. If you or your company is based in Norfolk, Suffolk, Essex or Cambridgeshire then Open Door can offer you on-site training.
Availability
- Starts
- .
- Duration
- 1 Day
- Timetable
- 9:30 to 4:30
- Provider
- Open Door IT Consultancy & Training Ltd.
Venue and Contact details
Main
5, The Woolnoughs
Kesgrave
Ipswich
IP5 2FD
UNITED KINGDOM
Telephone 01473 610891
Fax 01473 610891
Email jan@opendoor-itconsultancy.co.uk
Website http://www.opendoor-itconsultancy.co.uk
Venue Notes Courses at your premises or a hired venue which would have disabled access and parking
Contact Janine Goulding (ICT Training Consultant)
Courses
Syndicate
