- microsoft office
- Telstra
- convergence and telecommunications
- CIW
- courseware development
- contract trainers
microsoft access level 1 training
Upon completion of our Microsoft Access 2003 level 1 training you will be able to create real-world database applications that collect data, permit data to be queried; produce reports and display information in forms.
This course assumes no prior knowledge of Microsoft Access. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.
The course duration is 2 days.
Starting Access 2003
Opening an existing database
The Access 2003 screen
The database window
Working with database objects
Using menu commands
Using keyboard shortcuts
Exiting from Access 2003
Database theory
Understanding databases
How Access stores data
Spreadsheets vs databases
Database design
Designing a relational database
Scoping the system
Determine the inputs
Normalise the table
First normal form
Second normal form
Third normal form
A series of related tables
Relational databases
Creating a new database file
Access 2003 data types
Creating a new table
Changing field properties
Creating a table from a shortcut
Creating a table with numbers
and currency
Assignment – creating tables
Setting table relationships
Understanding table relationships
Accessing the relationships window
Table joins in the case study
Creating table joins
Assignment – creating relational joins
Editing an existing relationship
Printing table relationships
Adding relational records
Adding records in a table
Adding records using an autoform
Assignment – adding records
Data entry key violations
Data integrity violations
Importing records
Importing from a spreadsheet
Importing from a text file
Backing up a table
Importing and key violations
Deleting an unwanted table
Data integrity and importing
Working with records
Navigating in a table
Editing a record
Deleting a record
Deleting several records
Finding and replacing
Undoing an error
Compacting a database
Printing records
Working with sub datasheets
Assigning a sub datasheet
Data validation
Assigning default values
Marking a required field
Validation rules and text
Creating a lookup field
Working with validations
How relational queries work
Queries for viewing data
Creating a query design
Selecting fields for the query grid
Different views of a query
Adding more tables to a query
Modifying fields in a query
Selecting records using a query
Running a query from the database window
Relational select queries
Creating and queries
Clearing query criteria
Selecting numeric data
Selecting dates in a query
Creating or queries
Using a range expression
Selecting opposite values
Using wildcards
Problem selects
Calculated fields
Creating a calculated field
Formatting calculations
Calculating across two tables
Calculating dates
Using criteria in calculations
Concatenating string fields
Parameter queries
Creating a parameter query
Displaying all records
Using parameters to display a record range
Nominating specific data types
Using parameters in expressions
Creating forms
Forms – how they work
Creating a single table form
Working with a form
Creating a subform
Creating a linked form
Creating reports
Reports – how they work
Single table reports
Previewing a report
Creating a multi-table report
Creating a report from a query
Using the switchboard
Creating a switchboard
Creating subsidiary menus
Creating a menu item
Returning to another menu
Creating menu items
Linking the menus
Modifying the menu forms
Changing the startup
Getting help
Printed help sources
The help task pane
Searching for general help
Searching for specific help
Understanding a help window
Disabling online content
Enabling online content
Displaying and using the office assistant
Customising the office assistant
Disabling the office assistant
Screen tips and dialog box help
