Microsoft Access 2003 Intermediate Training Course
Description
This Microsoft Access 2003 training course will help you to obtain the skills required to create a relational database. You will learn relational database concepts and learn to customise forms, reports, and Data Access Pages in design view. Finally, you will be able to calculate and summarise data and import and export data in different formats for different purposes, like mail merge, analysis, or reporting.
Target audience
Those wanting to design relational database structures using Access and master the design and customisation tools available for queries, forms, and reports.
Course prerequisites
Ideally, you will have completed the course "Microsoft Access 2003 Introduction". You sho…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
This Microsoft Access 2003 training course will help you to obtain the skills required to create a relational database. You will learn relational database concepts and learn to customise forms, reports, and Data Access Pages in design view. Finally, you will be able to calculate and summarise data and import and export data in different formats for different purposes, like mail merge, analysis, or reporting.
Target audience
Those wanting to design relational database structures using Access and master the design and customisation tools available for queries, forms, and reports.
Course prerequisites
Ideally, you will have completed the course "Microsoft Access 2003 Introduction". You should be able to use Microsoft Access to create a database, tables, queries, forms, and reports.
Course Outline
Designing a Relational Database
- Basic principles of relational database management systems
- Relational tables using key fields
- Apply referential integrity
Creating Table Relationships
- Create and edit table relationships
- Arrange tables in the Relationship window
- Enforce referential integrity
- Use the Lookup Wizard
- Modify a lookup list
- Display related records in a subdatasheet
Summarising and Calculating Data
- Create a query to summarise values
- Add a calculated field to query output
- Apply query properties
- Add a calculated field to form or report
- Use the Expression Builder to create expressions
Creating a Summary Report
- Create a summary report using the Report Wizard
- Modify group properties
- Add and remove group headers and footers
- Modify group and detail section sort orders
- Modify report section properties
Designing Forms and Reports
- Create a new form or report in design view
- Understand the use of different sections
- Display, hide, and resize a section
- Modify form/report, section, and control properties
- Add a bound control
- Use the Control Wizard to add a control (list box, combo box, check box, option group)
- Add a hyperlink control
Modifying Controls
- Select a single control or multiple controls
- Move, resize, align, and distribute controls
- Change the tab order of controls on a form
- Identify and resolve errors
- Modify control properties
- Insert a graphic control
- Set control defaults
- Create a form/report template
Importing & Exporting Data
- Import data from different sources (spreadsheet, text file, database, Outlook/Exchange Address Book)
- Use Drag-and-Drop and the Clipboard to copy and paste data
- Export a table or query to Excel
- Export data to Word and complete a mail merge
- Create a report snapshot
- Save data in other file formats
- Export data objects to a different database
- Save a table, query, or form as a web page
Designing a Data Access Page
- Create a Data Access Page
- Modify the connection properties of a data access page
- Use the grouping and sorting features of a data access page
- Modify the design of a data access page
- Add and modify fields and controls
- Delete a data access page
Managing the Database File
- Document database structure
- Identify object dependencies
- Compact and repair a database
- Apply password protection to a database file
- Encrypt and decrypt a database
- Convert a database between different Access versions
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.