Specialists in:

Computers

Software

Hardware

Training

Networking

Installations

Internet support

On site support

ACCESS INTRODUCTION

• Discussing the Access window
• Navigating a table
• Viewing the fundamental database components
• Adding records to the Form view
• Copying records between tables
• Opening a database
• Creating a new table based on another’s structure
• Closing a file
• Using a database wizard
• Sizing a database column
• Creating a database
• Hiding a column
• Adding a table with a wizard
• Changing the font
• Designing a table
• Printing a datasheet
• Creating a table
• Searching in a field
• Changing a table’s field properties
• Finding records in Form view
• Entering data into a table from the datasheet view
• Using the Filter by Selection option
• Deleting records
• Creating a form
• Creating indexes

• Creating a Select query
• Changing the Control and it’s text
• Using a Totals query
• Assigning a field to a Control
• Changing field labels
• Creating a Combo box
• Using an expression to calculate values
• Changing the Detail Section colour
• Using the Report wizard
• Creating a Make Table query
• Creating a Tabular Style report
• Using a Crosstab query
• Using Microsoft Graph
• Working with the To Value options
• Changing the chart type
• Using the Form wizard
• Viewing the graph options
• Inserting a bitmap
• Demonstrating the Command Button wizard
• Using a Calculated control
• Using the macro window

• Demonstrating the one-to-many
• The Option Value
• Relationship
• Creating a report
• Showing many-to-many
• Adding column labels
• Defining one-to one
• Using a template
• Discussing Referential integrity
• Creating mailing labels
• Using Analyser tools
• Working with tables
• Creating queries
• Linking a FoxPro table
• Joining tables
• Importing an Excel workbook
• Using parameters
• Exporting information
• Creating a list box
• Assigning a password
• Using the Options group
• Creating a backup
• Creating a sub form

Exporting a table