Microsoft Access – Database Design Essentials
Is this course right for me?
Our Microsoft Access Database Design – Essentials course will enable you to build databases, e.g. training records, help call log, etc., and quickly and easily enter and extract information.
This course is designed for new users who need to build relational database systems. You should be competent in using a PC for general business use. No previous experience of Access is required.
Training course objectives:
- Create a database
- Build tables, forms, queries and reports
- Create fully relational databases
Versions Available
2003, 2007, 2010
Related Training Courses in Our Range
Creating a database
- Creating a new database
- Database elements
Creating a data table
- Setting field properties
- Using input masks
- Validation rules
- Default values
- Setting a primary key
- Creating lookup fields
Working with data tables
- Adding data
- Deleting data
- Sorting data
- Data entry quick keys
- Filtering
Creating simple data forms
- The form wizard
- Building and amending forms
- Entering data using forms
Extracting data using queries
- Creating select queries
- Setting criteria
- Creating parameter queries
- Adding calculations to queries
Printing and reporting
- Printing tables and queries
- The report wizard
- Building and amending reports
- Error checking
- Using layout view (2007 and 2010)
Principles of relational databases
Importing data
- Importing data from Excel
Building relational databases
- Linking information between tables
- One-to-one and one-to-many links
- Defining referential integrity
- Printing table relationships
Sub datasheets
- Viewing a subdatasheet
- Adding a subdatasheet
Building multiple table queries
- Deciding which tables to use
- Adding tables to the query
- Creating links between tables
- Join properties
Advanced form and report design
- Field properties
- Adding calculations
- Adding headers and footers
- Adding dates, times, page numbers
- Sorting and grouping
- Concatenating fields
