Bigrockdesigns Microsoft Access 2003 training course makes it easier for anyone to use, or create powerful database solutions to help organize, access, and share data in a short period of time. Bigrockdesigns course guides users through the Access 2003 set of powerful tools which can be understood by beginners, but complex enough for the most complex developers. We will cover the basics of using Access 2003, including navigating within the interface, relational database development and design principles. We then moves to object design construction (tables, queries, forms, and reports) and other advanced features.
Course Outline
What is a database?
database design
system overview
analyze current system
define data elements
normalization
establish relationships
testing and review
Access Interface
exploring the interface
Building a Databases
creating a new database
Office Online
Constructing Tables
creating tables
design view
the table wizard
tables by inputting data
data types
setting field properties
propagating field properties
Understanding Table Records
editing records
display settings
the find feature
sorting and filtering
copying tables
Producing Relational Databases
keys
table relationships
Select Querie
what are queries?
creating select queries
using the query wizard
working with results
Calculations in Your Queries
performing calculations
duplicate records
Creating Forms and Controls
AutoForm
form wizard
working with controls
control properties
form properties
printer forms
adding a subform
adding headers & footers
Creating and Using Reports
AutoReport
using the report wizard
report sections
controls & properties
Enhancing Forms and Reports
using AutoFormat
special effects
opening a form on startup
adding graphics
AutoCorrect & error checking
switchboards
Working with External Data
exporting data
importing external data
linking to external data
Adding Security
passwords
encryption & decryption
using the security wizard
Who Should Do This Course
Ideal for the learner with none or limited skills in Access. You will learn the skills to make complex database solutions. No previous experience is required. A knowledge of the windows would be an advantage.
