Intermediate Microsoft Access 2013 Training Courses

Displaying the Access 2013 database

•The Navigation pane, customising the Navigation pane
•Database display

Table design - fields

•Applying and modifying data types such as text, memo, hyperlink, currency, date and time in a field
•Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field
•Creating and editing a lookup in a field
•Creating and editing a validation rule in a field
•Creating and editing an input mask in a field
•Applying and modifying default values in a field
•Setting a mandatory field
•Fields with multiple values

Table Relationships

•Understanding the basis for creating a valid relationship
•Creating a one-to-one or a one-to-may relationship between tables
•Understanding and modifying a many-to-many relationship between tables
•Applying inner, outer and self joins
•Applying and using referential integrity
•Applying automatic deletion of related records
•Relating or joining data when designing records
•Adding fields to tables
•Field templates

Microsoft Access Query design

•Grouping information in a query
•Using a crosstab query
•Using wildcards in a query
•Using arithmetic and logical expressions in a query

Form design

•Using bound and unbound controls
•Creating and editing a combo box, list box, check box and option groups
•Inserting a data field to appear within form header or footer on the first page or all pages
•Stacked and tabular layout controls

Report design
•Inserting a data field to appear within report header or on footers on the first page or all pages
•Forcing page breaks for groups on reports

Importing, exporting and linking data

•Importing text, Excel, csv, etc, documents into an Access 2013 database
•Exporting data in Excel, txt, etc. formats
•Linking external data to an Access 2013 database