Courses / Access 2002/2003 Level 1
Access 2002/2003 Level 1
- Provider
- WWP Training Ltd
- Course ID
- ACC031
- Summary
- This two day course is designed to introduce a user to the basic operations of Access.
About the Course
- Target
- People requiring the necessary skills to create an Access database or report in a database.
- Entry requirements
- There are no formal entry requirements for this course. Some awareness of another programming language is preferred.
- Outcome
- On completion of this course you will have learned how to: create databases in Access and work with the data by using tables, queries, forms and reports as well as gaining an understanding of table relationships.
- Content
- Getting Started * What is Access? Starting Access, the Access application window. * Working with Access menus, basic Access terminology * Examining Access objects * Resetting the database folder, displaying help information * Exiting from Access Setting up a new database * Designing and creating a new database, creating a new table * Entering records in a datasheet view * Printing the datasheet of a table * Navigating through records in a datasheets view * Closing a table/closing a database Creating a form/modifying and manipulating data * Reopening a database/reopening a table * Creating a form * Navigating through records in form view/closing a form * Reopening a form * Switching between form view and datasheet view * Entering records in form view * Editing records in datasheet view and in form view * Using the find feature * Deleting records in datasheet view and in form view * Modifying the datasheet view of a table * Sorting the records in a table Displaying selected data * Filtering the records in a table * Creating a simple query * Creating a query in design view * Modifying a query * Including a numeric condition in a query * Including a calculated field in a query Creating a report * Creating a simple tabular report * Creating a grouped tabular report, modifying a report Additional Access features * Using the spelling checker * Copying, renaming and deleting database objects * Importing spreadsheet data into an access table Modifying the design of a table * Displaying a table in design view * Specifying a required field/defining a default field value * Setting a primary key for a table * Adding a memo field to a table * Additional table design topics Working with multiple tables * Displaying multiple tables on the Access desktop * Resizing and repositioning the table window Relating tables * Creating a relationship between two tables in a database * Displaying and using a subdatasheet Working with a custom form * Designing a custom form * Adding a header/footer to a form * Adding a calculated control to a form * Using a custom form to enter data
- Cost
- Contact course provider for details. Following course delivery, we ensure that you continue to receive the full benefit of our training programmes (excluding Technical programmes) by offering 12 months free telephone support during normal office hours - boosting confidence and providing expert advice when you need help to solve a problem quickly.
- Enrolment
- Contact the provider for details.
Availability
- Starts
- Please contact provider to arrange on site training dates.
- Duration
- 2 days
- Timetable
- Contact course provider for details
- Provider
- WWP Training Ltd
Venue and Contact details
Main
39 - 45 Victoria Street
Windsor
Berkshire
SL4 1HE
UNITED KINGDOM
Telephone 01753 857 828
Fax 01753 858 615
Email info@wwp.co.uk
Website http://www.wwp.co.uk
Contact Notes Please contact the provider to arrange a venue.
Courses
Syndicate
