Duration
3 days
LESSON 1: DATABASE ESSENTIALS
Working in the Access Interface Selecting Tools and Commands Defining Data Needs and Types
LESSON 2: CREATING DATABASE TABLES
Creating a Database Creating a Table
LESSON 3: WORKING WITH TABLES AND DATABASE RECORDS
Navigating Among Records
Entering, Editing, and Deleting Records Working with Primary Keys
Finding and Replacing Data
Sorting and Filtering Data and Setting Field Viewing Options within a Table Understanding Table Relationships
LESSON 4: MODIFYING TABLES AND FIELDS
Modifying a Database Table
Creating Fields and Modifying Field Properties
LESSON 5: CREATING FORMS
Creating Forms
Sorting and Filtering Data within a Form
LESSON 6: CREATING REPORTS
Creating Reports Applying a Theme Working with Reports
LESSON 7: CREATING AND MODIFYING QUERIES
Creating a query Modifying a query
Sorting and filtering data within a query
LESSON 8: USING CONTROLS IN REPORTS AND FORMS
Adding controls
Defining control tab order Formatting controls
Arranging control alignment, size, and position
Adjusting page margins and changing page orientation for forms and reports
LESSON 9: ADVANCED TABLES
Creating a Custom Table Summarizing Table Data
LESSON 10: ADVANCED FORMS
Creating Advanced Forms
Using Application Parts to Create Blank Forms Creating and Modifying a Navigation Form
LESSON 11: ADVANCED REPORTS
Defining Groups
Creating a Subform on a Report Creating the Print Layout
LESSON 12: ADVANCED QUERIES
Creating crosstab queries Creating a subquery Saving a filter as a query Creating action queries
Understanding advanced query modification
LESSON 13: DISPLAYING AND SHARING DATA
Creating a Chart Using the Chart Wizard Formatting a Chart
Saving a Database Object as Another File Type Printing a Database Object
LESSON 14: IMPORTING AND EXPORTING DATA
Importing Data Exporting Data
LESSON 15: DATABASE TOOLS
Maintaining a Database
Saving a Database as a Template Encrypting a Database Configuring Database Options Using Database Tools
Programme scope, delivery arrangements and suitability are confirmed during enquiry.