Book a course
1 day instructor-led course

What you will learn

This course is ideal for those looking to work with existing databases as well as creating a new Access database. Learn effective ways to enter and extract data and convert data into a well-presented format for reports.

Because of the handy shortcuts, this course is also suitable for those who are self-taught.

Prerequisite

No previous experience of using Access is required before attending this course.

Course outline

Access Introduced

  • Planning a database
  • Creating a blank database
  • Opening an existing database
  • Security warnings
  • The Navigation Pane
  • Previewing database components
  • Closing an Access database

Tables Introduced

  • Viewing and navigating table data
  • Navigate using keyboard shortcuts
  • Editing table data
  • Adding Records to tables
  • Selecting and deleting records
  • Finding and replacing data
  • Filtering tables
  • Summing table data

Queries Introduced

  • Opening a query in datasheet view
  • Opening a query in design view
  • Adding fields to a query
  • Sorting query results
  • Modifying datasheet view
  • Saving and closing queries

Forms Introduced

  • Working with form data
  • Sorting records
  • Filtering records
  • Working in design and layout views
  • Changing object attributes

Reports Introduced

  • Opening and viewing reports
  • Viewing a report in design view
  • Previewing and printing report data
  • Creating reports with auto report
  • Creating reports with the report wizard
  • Changing field attributes

Creating a New Database

  • Creating database tables
  • Creating table fields
  • Selecting field data types

Table Relationships

  • Introduction to relationships
  • Establishing table relationships
  • The one-to-many relationship type
  • Establishing Referential Integrity

Creating Queries

  • Streamline query criteria using wildcards
  • Creating summary queries
  • Creating queries based on criteria
  • Running date queries
  • Formatting field properties
  • Building queries from multiple tables
  • Summing in queries

Creating Forms

  • Creating a new form
  • Inserting form fields
  • Working with the property sheet
  • The command button wizard
  • Programming without typing
  • Creating forms with embedded sub forms
  • Creating forms with the sub form wizard
  • Creating forms with the form wizard

Creating Reports

  • What are Report Bands?
  • Managing report controls
  • Basing reports on multiple tables
  • Basing reports on queries
  • Sorting and grouping records
  • Report properties sheet