Access 2013 Introduction Training Courses – Online or Face to Face

Duration: 1 Day

Course Objective:

To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.

Course Contents:

  • Introduction to databases
    • database concepts
    • database layout
    • launching access
    • the access menu system
    • dialog boxes
    • getting help
    • creating a new database
    • closing a database (vs exit access) opening a database
  • Tables
    • database design
    • creating tables using the table wizard
    • creating tables in the datasheet view
    • creating tables in the design view
    • data types
    • field properties
    • data display format vs input mask
    • the input mask
    • data entry problems
    • moving and copying records
  • Working with tables
    • pasting records
    • deleting a table
    • table layout changes
    • find, replace
    • wildcards
  • Queries
    • the simple query wizard
    • the design view
    • modifying the query
    • using basic criteria
    • additional criteria
    • parameters
    • multiple object queries
    • custom calculations in a query
    • calculating fields continued
    • grouping fields
  • Introduction to reports (time permitting)
    • reports
    • the Report Wizard

 

Enquire About Access 2013 Introduction Training Courses – Online or Face to Face Course
This course can be tailored to meet your exact requirements.
 

* fields are mandatory.

What our attendees have said about us:
Excellent tutor, very clear and precise made training interesting I enjoyed the day.
Kenmont
The trainer made the session fun and easy to understand. He was very helpful I need to attend more courses like this.
E.C.S.
Very positive and patient. Willing to answer questions not related to this level.
Maria Silva
Very professional, he learnt everybody's (x6) name without seemingly to refer to any lists, and addressed us individually throughout.
Islington Council
Clearly presented, would recommend utilising Keystar to the Company for further IT training.
Novae
A fantastic teacher, clear and concise. Great at illustrating points, great knowledge of the subject and brilliant in explaining topics.
RMG Group
Good technique, friendly and relaxed yet able to keep momentum and kept course on track. Kept asking if we were ready to move on to next topic making sure we were all on same level.
NHS Central Essex