Workshop_6

Most every command can be found in the ribbon

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ely with the users of the database. Create the design on paper, discuss it, and then start creating tables in Access. I present a brief introduction to database design at the end of this workshop. As soon as you open a database, you see that the structure is different from that of documents in Excel or Word. A database can have up to seven different types of “objects” and many objects within each type. Select the dropdown menu in the left side of the screen to see the different objects. Make sure Tables is selected and observe the existing saved tables in the Practice Database. Our database has four tables: Course Offerings, Course Sign ­ups, Student Info, and Transactions. Now, defining the basic MS Access and NeoOffice screen components: Under Windows: 1. Ribbon Interface: MS Office Excel appears similar to the layout of MS Office Word in regards to the Ribbon Interface. Most every command can be found in the Ribbon Interface. When working on a 2 Workshop 6: MS Office Access and NeoOffice 2. 3. unique object, additional tabs in the Ribbon Interface may open that are specific to formatting the selected object. Quick Access toolbar: Only available under Windows. Contains commonly used buttons to perform tasks such as saving a document and undoing or redoing actions. Click on the drop  ­down arrow to customize the commands available on the Quick Access toolbar. Objects: Along the left side of the database window the objects are listed. For this class we will just work with Tables, Queries, Forms, and Reports. In this workshop, we will focus on Tables and Queries, whereas Forms and Reports are the topics for Workshop 7 Create a new table Database Tools: Relationships Navigation Pane Access Objects Under OS ­X: 1. Menu Bar: Only available under OS ­X. Contains the most complete menu of options and features available in Excel. 2. Tool Bar: Only available under OS ­X. A customized short cut bar filled with icons for frequently used tools. 3. Objects: Along the left side of the database window the objects are listed. For this class we will just work with Tables, Queries, Forms, and Reports. In this workshop, we will focus on Tables and Queries, whereas Forms and Reports are the topics for Workshop 7 Database Tools Menu Bar Database objects 3 Workshop 6: MS Office Access and NeoOffice MS Office Access and NeoOffice Help Function Access and NeoOffice offer a Help function that will guide you through any task. The use of the Help function is encouraged throughout this course....
View Full Document

Ask a homework question - tutors are online