Database / MS Access Introduction
Details
Outline
Database Terms
- Prebuilt database templates
- An explanation of database terminology
- Plan your Database (Tables, Queries, Forms, Reports, Macros, Pages, Modules)
- Plan a database structure. (tables)
- Create a new database file
Working with Tables
- Design a Table, Conventions for entering, Naming objects and fields (Design View)
- Select data types, enter field descriptions
- Set a Primary Key/Remove a Primary Key
- Field Properties
- Insert, Delete, Move and Rename Fields
- Create a Table with a Wizard
Entering & Editing Data
- Accessing objects through the navigation pane
- Switch Views in Access (design, layout and data entry)
- Entering/Editing Data (Records/Fields)
- Navigating the datasheet
- Sorting Data, Finding & Replacing Data
- Hiding and Un hiding Fields
Relationships
- Relationships explained?
- Different types of relationships (one to many etc)
- Conditions needed for setting up a relationship
- Ensuring Referential Integrity
- Printing Relationships in a Report
- Enter data in related tables
Queries & Filters
- Create a filter by selection
- Create a filter by form
- Creating a query using a wizard
- Build a query using Query Design
- Add/Remove fields in a query
- Sort data in a select query
- Enter Text, numeric, date, logic criteria
- Rename, edit or delete a query
Multi Table Queries
- Build a query across more than one table
- Joining Tables for a query (more relationships)
- Setting Join Properties - Inner and Outer Joins
- Find Unmatched records Query Wizard
- Find Duplicate records Query Wizard
Creating Forms
- Create a Form using Auto Form tool
- Create a Form using the Form Wizard
- Form design view/layout view
- The Field List, Resizing Forms
- Format Painter and AutoFormat
- Set basic form properties
- Data Entry in Forms
- Add, edit, delete a record in form view
Reports
- Standard Reports using Wizard
- Insert, Move, Size and delete controls
- Editing record source
- Page setup
- Print your report
Pery Square Business College provide training for companies, individuals and groups. We run scheduled training courses from our premises in Pery Square and also offer onsite training tailored to the needs of any organisation. Pery Square Business College have over 20 years industry experience.
We cater for all ages and skill levels - from Absolute Beginners to Business Professionals and Trainers.
Our Tutors are all highly qualified and class sizes are kept small.
We cater for Business Training, both in-house at our training rooms or on-site at the company's offices.
Specially customised training affords our Business Clients the assurance of compliance within their I.T. and customer service systems.
Our Recruitment Agency links up with many organisations in the Limerick city and Mid-West Region offering a discreet and confidential service for both temporary and permanent placements to the private and public sectors. All candidates are screened by experienced consultants prior to introduction, in order to match the most suitable candidate to our customer requirements.