Lesson 15 - IC3BASICS,Internetand KeyApplications Lesson15...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
IC 3  BASICS, Internet and  Computing Core Certification Key Applications Lesson 15 Working with Access  Databases
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Working with Access Databases – Lesson 15 2 Objectives Identify the parts of the Access screen. Understand the purpose of the database  objects. Create a table using a wizard. Enter records in datasheet view. Change the column width in datasheet view. Add and delete fields in Design view. Change field properties.
Background image of page 2
Working with Access Databases – Lesson 15 3 Identify the Parts of the Access  Screen The user interface for Access is similar to other  Office XP applications. There is a Title bar, a Menu bar, a Status bar, and a  Task Pane. Unlike Word and Excel, Access does not have a  standard document view. The Access screen changes based on which feature  or object you are working on. Many of the Access menu options and toolbar  buttons are unique to Access.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Working with Access Databases – Lesson 15 4 The Access Window Title bar Menu bar Database  toolbar Task pane Status bar This area changes based on  what Access object you are  working on.
Background image of page 4
Working with Access Databases – Lesson 15 5 The Open Dialog Box If you click the  More Files  link in the Task pane, this dialog box will appear.  You can locate an existing database file to open. Locate  the  drive  and  folder  where  the  file  is saved here. A list of Access files  will display here. Click a  file name  to  select  it,  then  click  the  Open  button.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Working with Access Databases – Lesson 15 6 The Database Window When  you  open  a  database  file,  a  database  window  like the one shown here will appear. Title bar Toolbar Objects bar Database objects  window
Background image of page 6
15 7 Understand the Purpose of the  Database Objects An Access database may contain the following  objects: Tables: All database data is stored in tables in rows  and columns. Queries: Questions you ask about the data. Forms: Display data in a form format. Pages: Enable you to design database objects to be  published on the Web.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/05/2012 for the course IMS 101 taught by Professor Novak during the Fall '11 term at Moraine Valley Community College.

Page1 / 22

Lesson 15 - IC3BASICS,Internetand KeyApplications Lesson15...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online