Access 2010. Part II. Tables and Queries

201 Pages·5.359 MB·English

by  Moffat S.

Stephen Moffat, The Mouse Training Company
Access 2010
Part II
Download free ebooks at bookboon.com
2
Access 2010: Part II
© 2011 Stephen Moffat, The Mouse Training Company & Ventus Publishing ApS
ISBN 978-87-7681-858-6
Download free ebooks at bookboon.com
3
Access 2010: Part II Contents
Contents
To see Section 1-3 download Access 2010: Part I
Section 1 The Basics Part I
Guide Information Part I
The Access Screen Part I
Ribbons Explained Part I
About Smart Tags Part I
New Features In Access 2010 Part I 360°
Access and Windows Part I
Using the Quick Access Toolbar Part I .
thinking
Section 2 Understanding Access Part I
360°
What is Microsoft Access? Part I
Using the Getting Started Window Part I
.
The File Ribbon Part I
thinking
Help Part I
The Home Ribbon Part I
Create Ribbon Part I
External Data Ribbon Part I
360°
.
thinking
360°
ert
v .
d
a thinking
e
h
k t
c
cli
e
s
a
e
Pl
Discover the truth at www.deloitte.ca/careers Discover the truth at www.deloitte.ca/careers
© Deloitte & Touche LLP and affiliated entities.
Discover the truth at www.deloitte.ca/careers © Deloitte & Touche LLP and affiliated entities.
Download free ebooks at bookboon.com
© Deloitte & Touche LLP and affiliated entities. Discover the truth4 a t www.deloitte.ca/careers
© Deloitte & Touche LLP and affiliated entities.
Access 2010: Part II Contents
Viewing Data Part I
Database Tools Ribbon Part I
Using The “database”Tabs Part I
The Trust Center Part I
First Steps Part I
Section 3 Saving in Access Part I
Saving in Access Part I
Using AutoRecover Part I
Section 4 Tables 10
Creating Tables 10
Primary Key 23
Format Data and appearance (Design View) 27
Relationships 41
Controlling Data EntryIn a Table. 49
Creating A Lookup Field 53
Enter Data In a Table 70
Formatting A Table in Datasheet view 71
Working with records 75
Sorting and Finding Data In a table 89
Filtering data in a table. 94
Increase your impact with MSM Executive Education
ert
v
d
a
e
h
k t
c
cli
e For almost 60 years Maastricht School of Management has been enhancing the management capacity
s
ea of professionals and organizations around the world through state-of-the-art management education.
Pl
Our broad range of Open Enrollment Executive Programs offers you a unique interactive, stimulating and
multicultural learning experience.
Be prepared for tomorrow’s management challenges and apply today.
For more information, visit www.msm.nl or contact us at [phone] or via [email protected]
F tohr em ogrel oinbfoarmllaytio nn, evitswit wowrwk.mesdm .mnl aorn coangtaectm use ant t+ 3s1c 4h3 o38o 7l0 808
or via [email protected]
Download free ebooks at bookboon.com
Executive Education-170x115-B2.indd 1 18-08-11 15:13
5
Access 2010: Part II Contents
Using Advanced Filter Options 97
Changing Field Data Types 100
Section 5 Queries 103
Creating Queries 103
Basic Query use. 111
Filtering a Query 118
Select Queries and criteria 130
Using Multiple Tables In Queries 148
Building queries on queries 161
Parameter Queries 164
Crosstab Query 169
Action Queries 177
To see Section 6-7 download Access 2010: Part III
Section 6 Forms Part III
Creating Forms Part III
Create form Alternatives Part III
Touring Design View To Modify Your Form Part III
Build form in design view Part III
Bind Form to data source Part III
Basic Field Controls Part III
See the light!
The sooner you realize we are right,
the sooner your life will get better!
ert A bit over the top? Yes we know!
v
d
a
e We are just that sure that we can make your
h
k t media activities more effective.
c
cli
e
s
a
e
Pl
Get “Bookboon’s Free Media Advice”
Email [email protected]
Download free ebooks at bookboon.com
6
Access 2010: Part II Contents
Formatting Controls Part III
Form Types Part III
Layout View Part III
Modal and Pop-Up Forms Part III
Advanced Features for form and controls Part III
Formatting Your Forms Part III
Section 7 Reports Part III
Working with Reports Part III
Common Report Tasks Part III
Header and Footer Options Part III
Create report in design view Part III
Subreports Part III
Formatting Reports Part III
To see Section 8-12 download Access 2010: Part IV
Section 8 Macros Part IV
Macro definitions Part IV
Section 9 Printing Part IV
Printing a Database Object Part IV
ert
v
d
a
e
h
k t
c
cli
e
s
a
e
Pl
GOT-THE-ENERGY-TO-LEAD.COM
We believe that energy suppliers should be renewable, too. We are therefore looking for enthusiastic
new colleagues with plenty of ideas who want to join RWE in changing the world. Visit us online to find
out what we are offering and how we are working together to ensure the energy of the future.
Download free ebooks at bookboon.com
7
Access 2010: Part II Contents
Section 10 Other advanced Features Part IV
Web Database Part IV
Split a Database Part IV
Import and export data Part IV
Add data collected via e-mails to your database Part IV
Section 11 Getting Help Part IV
To Access Help Part IV
Section 12 Access 2010 Specifications Part IV
Discontinued & modified functionality in 2010 Part IV
Database specifications for Access 2010 Part IV
Project specifications Part IV
Keyboard shortcuts for Access Part IV
Who is your target group?
And how can we reach them?
At Bookboon, you can segment the exact right
ert audience for your advertising campaign.
v
d
e a Our eBooks offer in-book advertising spot to reach
h
k t the right candidate.
c
cli
e
s
a
e
Pl
Contact us to hear more
[email protected]
Download free ebooks at bookboon.com
8
Access 2010: Part II

To see Section 1-3 download
Access 2010: Part I
Download free ebooks at bookboon.com
9
Access 2010: Part II Tables
Section 4 Tables
BY THE END OF THIS SECTION YOU WILL BE ABLE TO
• Build tables
• Set field properties
• Set primary key
• Create lookup fields
• Relate tables
• Manage data within tables
• Format and set defaults for tables
Creating Tables
In this lesson we will learn much more about the usage of tables, including how to build them from scratch. You now
should be familiar with the views and the terminology within access. W weshould have our database all planned out.
About Tables
You should be very familiar with the components of tables by now. We know a table is made up of several records each
containing fields with data. Access also makes it easy to build and modify any component of a table using Design view,
which we will cover later in this manual.
When designing a database, it is critical that you take the time to design your database carefully. Although it is not a
difficult job to make some adjustments to a field, adding or removing fields in a large established database can be a real
headache. It is important to communicate with everyone who will be using the database to make sure that everyone has
the information they will need. Don’t be afraid to build a database a little bigger than you think it needs to be; if you end
up with unused fields they are much easier to take out than to put new fields in.
Create An Empty Table
Access gives you the ability to create a table in a few different ways: opening an empty table and inputting values, using
a template, or using Design view to construct your table by hand.
Download free ebooks at bookboon.com
10