Microsoft Access Level 2 - by invitation only - 1 day
Southwark Employees Price: £100 Associates Price: £100
Who is it for?
The course assumes that you have a basic understanding of relational databases, and that you know how to create tables and select data with queries. This course intends to build on training delivered in the Microsoft Access Level 1 Course.
What does it cover?
Reviewing Access: How Access objects work together; the importance of using appropriate relationships in a database; creating and running queries with various criteria.
Working with imported data: Importing or linking data; importing data from other applications (such as Excel or text files); importing from other Access databases; defining an import specification.
Exporting data: Exporting to a text file, worksheet or database files; merging Access data with a Word document.
More on queries: Using the query wizards to find duplicates or unmatched records; using action queries to create tables, delete data, append or update records; summarising information with cross-tab queries and totals.
Creating forms and reports: Using the form and report wizards to create a basic form and report.
Customising forms: Using form design view; adding controls; setting properties of controls; setting form properties; changing the tab order.
Customising reports: Working in design view; report sections and their properties; working with groups; adding subtotals and totals; controlling page breaks.
What are the course outcomes?
· import and link data and describe the difference between importing and linking
· create and use action queries to delete, update and append data
· export and use data in another application
· create forms using wizards, and use basic design techniques to make them more user-friendly
· create reports using wizards, and modify the layout using basic design techniques