Phone 1300 793 951 or visit www.odysseytraining.com.au

Odyssey Training Logo
Microsoft Access Intermediate Training Course

Microsoft Access Intermediate

2 Day Training Course

Book a public course

Venue – Brisbane

Odyssey Training
Level 1, 60 Edward St
Brisbane QLD 4000
View map and directions

Times and Dates

30 Nov - 1 Dec 2017
2 Days     9:00 am – 4:00 pm

Need your training approved?

Computer Course Inclusions
 

This course is ideal for

This course has been developed for Access users want to report on and manipulate data and improve their working knowledge of the product.

Course prerequisites

Participants will need to be familiar with all of the topics covered in the Microsoft Access Introduction course.

What you will learn

  • Import, link and export tables
  • Work with advanced table properties
  • Use advanced select queries and create crosstab queries and charts, as well as use action queries
  • Design forms and use subforms
  • Create simple macros
  • Design reports

Topics covered in this training course

  • Introductory revision
    • Importing and linking tables
      • Drag and drop import
      • Troubleshooting importing
      • Import a CSV file
      • Linking tables
      • Modify data in linked tables
      • Importing vs linked tables
      • Export data from Access
      • Export to Excel
      • Export to Access
    • Advanced table properties
      • Review basic field properties
      • Create a custom format
      • Custom date formats
      • Input mask property
      • Validation rules
      • Validation text property
      • Table properties
      • Modify lookup field properties
    • Table relationships
      • The relationships window
      • Set table relationships manually
      • Relationship rules
      • Referential integrity
      • Cascade updates and deletes
    • Advanced select queries
      • Find null values
      • To exclude null values
      • NOT queries
      • Parameter queries
      • Parameter data types
      • Query multiple tables
      • Table joins
      • Find orphan (unmatched) records
    • Advanced query expressions
      • Use expression builder
      • Convert nulls to zeros
      • Concatenation
      • StrConv function
      • Date functions
      • DateAdd()
      • DateDiff()
      • IIF function
      • Aggregate queries
      • Format query field properties
      • Format the query headings
      • Top values query
    • Action queries
      • Make table query
      • Delete query
      • Update query
      • Append query
    • Crosstab queries
      • Create a crosstab query using the wizard
      • Modify a crosstab query
      • Create a crosstab query manually
    • Form design
      • Form design view
      • Breaking form layouts
      • Selecting form controls
      • Form properties
      • Form control properties
      • Create an unbound control
      • Add a calculation
      • Add a drop-down control
      • Change combo box properties
      • Add a button
      • Change tab order
      • Align controls
      • Resize controls
      • Evenly spacing controls
      • Add a logo to a form
      • Link a query to a form
    • Subforms
      • Create a subform from control wizard
      • Modify the subform
      • Datasheet view
      • Subform properties
      • Continuous forms view
      • Calculations on a subform
    • Advanced report design
      • Report design view
      • Add a logo to a report
      • Add calculations to reports
      • Concatenation
      • Add calculations to a footer
      • Sum calculated fields
      • Advanced report properties
      • Show and hide report sections
      • Add page breaks

    Home > Microsoft Access Training > Access Intermediate Course > 2016

    Our Training Courses

    - +
    Subtotal