Microsoft Access Training Northern Ireland

Introductory Level

This course is designed to help you to obtain the skills required to update records in a database and to use Access to create a simple database. You will learn to design tables and queries and to create forms and reports using built-in tools.

Access - Basic Database Concepts Understand what a database is • Recognise the advantages of using a computer database • Know the function of the main database objects (table, query, form, report)

Access - What is Access? Recognise the different elements of the Access screen • Create a new blank database • Select a database object using the Objects Bar • Open and close an existing database • Log on to an existing database • Make a backup copy of a database file

Access - The Database and Table Wizards Create a database using the Database Wizard • Create a table using the Table Wizard

Access - Adding and Editing Records Enter records using a datasheet • Undo changes to a field or record • Navigate through records in a datasheet • Find a record • Check spelling in a datasheet • Replace data • Delete records from a table

Access - Using a Datasheet Modify the layout and formatting of a datasheet • Sort records by a single field or by more than one field • Apply and remove a filter • Use Filter by Selection or Filter by Form • Use basic operators to construct simple criteria expressions

Access - Designing a Table Determine data inputs and outputs for a database • Create a table in design view • Use multiple data types • Set a primary key • Switch between design and datasheet views and different object windows • Modify basic field properties (size, format) • Delete a table

Access - Using a Form Understand the differences between a form and a datasheet • Use AutoForm to generate a simple form • Save and close a form • Create a form with the Form Wizard • Open an existing form • Enter and edit records using a form • Navigate through records in a form • Add, delete, and modify records using a form • Find, sort, and filter records using a form • Delete a form • Add a label to a form header or footer

Access - Using a Select Query Understand the differences between a query and a sort or filter • Create a query using the Simple Query Wizard • Add, remove, and hide query fields • Sort query results • Run, save, close, open, and delete a query

Access - Using Criteria Expressions Select records by a single criterion • Create an expression • Select records using multiple criteria

Access - Using a Report Preview output from an object • Print output from database objects (table, query, form, or report) • Use AutoReport to generate a basic report • Save, close, open, and delete a report • Change the Page Setup of database objects

Access - Creating a Report Create a report using the Report Wizard • Create a label report • Use report sections • Move, resize, and delete controls • Add and modify a label control • Undo and Redo design changes

Access - Modifying a Table Set table field properties (size, caption, format) • Set up an index • Use the Hyperlink data type • Modify a table by adding and removing fields and changing field properties

<- Back to Courses