Microsoft Access Level 1
You will create and modify new databases and their various objects.
Course Objectives
The course will cover the following elements:
• Identify the elements of the Access interface
• Identify the components of a database
• Examine the relational database design process
• Create a new database
• Create a table using the design view
• Manage tables
• Establish table relationships
• Create a new database
• Create a table using the design view
• Manage tables
• Establish table relationships
• Modify table data
• Sort and filter records
• Work with sub-data sheets
• Create a query
• Add criteria to a query
• Add a calculated field to a query
• Perform calculations on a record grouping
• Create a form
• Modify the design of a form
• View and edit data suing an access form
• Create a report
• Add a control to a report
• Format the controls in a report
• Enhance the appearance of a report
• Prepare a report for print
Prerequisites
To be successful in this course, youshould be familiar with using personal computers and you should have used themouse and keyboard. You should be comfortable in the Windows environment and beable to use Windows to manage information on the computer. Specifically, youshould be able to launch and close programs; navigate to information stored onthe computer; and manage files and folders. To ensure your success, werecommend you first take one of ABCO Technology’s introductory Windows courses,such as either of the following, or have equivalent skills and knowledge:
• Windows XP Professional: Level 1
OR
• Windows XP: Introduction
Course Benefits
Upon successful completion of this course, students will be able to:
•Build database structure
•Mange data in a table
•Query a database
•Design forms
•Generate reports
Course Duration
8 Hours
Microsoft Access Level 2
You will improve and customize tables, queries, forms and reports, and share Access data with other applications.
Course Objectives
The course will cover the following elements:
• Constrain data entry suing filed properties
• Establish data entry formats for entering field values
• Create a list of values for a field
• Create query joins
• Join tables with no common fields
• Relate data within a table
• Set the select query properties
• Retrieve records based on input criteria
• Create action queries
• Restrict data entry in forms
• Organize information with tab pages
• Add command button to a form
• Create a subform
• Display a summary of data in a form
• Change the display of data conditionally
• Organize report information
• Format reports
• Control report pagination
• Summarize report information
• Add a sub-report to an existing report
• Create a mailing label report
• Import data into access
• Export data to text file formats
• Export access data to excel
• Create a mail merge
Prerequisites
To ensure your success, we recommend that you first take one of ABCO Technology’s introductory courses, or the following course or have equivalent knowledge and skills.
• Microsoft®Office Access® : Level 1
Course Benefits
Upon successful completion of this course, students will be able to:
•Control data entry
•Join tables
•Create flexible queries
•Improve forms
•Customize reports
•Share data across different applications
Course Duration
8 Hours
Microsoft Access Level 3
You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
Course Objectives
The course will cover the following elements:
• Create sub-queries
• Create unmatched and duplicate queries
• Group and summarize records using criteria
• Summarize data using a Crosstab query
• Create a PivotTable and a PivoChart
• Create a Macro
• Attach a Macro
• Restrict records using a condition
• Validate data using a macro
• Automate data entry using a macro
• Include a chart in a report
• Print data in columns
• Cancel printing of a blank report
• Publish reports as PDF
• Link tables to external data sources
• Manage a database
• Determine object dependency
• Document a database
• Analyze the performance of a database
Prerequisites
To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following ABCO Technology courses or equivalent knowledge is recommended:
• Microsoft® Office Access® : Level 1
• Microsoft® Office Access® : Level 2
Course Benefits
Upon successful completion of this course, students will be able to:
• Structure existing data
• Writing advanced queries
• Simplifying tasks with macros
• Creating effective reports
• Maintaining an access database
• Course Duration
8 Hours