Access 2003 for starters the missing manual
Maybe you got Access as part of Microsoft Office and wonder what it can do for you and your household; maybe you're a small business manager and don't have a techie on staff to train the office in Microsoft Access. Regardless, you want to quickly get your feet wet--but not get in over you...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2005.
|
| Edición: | 1st edition |
| Colección: | Missing manual.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626945106719 |
Tabla de Contenidos:
- About The Authors; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What's a Database?; About Access Databases; About This Book; The Very Basics; Example Databases; About MissingManuals.com; Safari Enabled; Part ONe:; Creating Databases; A Tour of an Access Database; The Access Window; Tables; Forms; Queries; Reports; Putting It All Together; Creating a New Database; Starting with a Wizard; Phase 1: Choosing Your Template; Phase 2: Choosing Table Fields; Phase 3: Choosing Styles for Forms and Reports; Phase 4: Adding a Title and a Picture
- Modifying the Wizard's DatabaseOpening a Database; Navigating with the Switchboard; Adjusting Table Designs; Adding Records Using a Form; Printing a Report; Starting from a Blank Database; Creating Tables to Hold Data; Planning Your Tables; Creating Tables with the Wizard; Phase 1: Starting the Table Wizard; Phase 2: Choosing Fields for Your Table; Phase 3: Naming Your Table and Setting a Primary Key; Phase 4: Creating Your Table; Creating Tables in the Design Window; Adding Fields; Choosing Data Types; Text; Memo; Number; Date/Time; Currency; Autonumber; Yes/No; OLE Object; Hyperlink
- Lookup WizardSetting Field Properties; Adding and Editing Table Data; Adding Records to a Datasheet; Editing Records in a Datasheet; Changing How a Table Displays Data; Creating Forms to Add and Display Data; Form Basics; Form Layouts; Controls; Properties and the Property Sheet; Creating Autoforms; Creating Forms with the Form Wizard; Phase 1: Choosing a Record Source; Phase 2: Choosing Fields; Phase 3: Choosing a Form Layout; Phase 4: Choosing a Form Style; Phase 5: Naming and Saving the Form; Modifying the Form Design; Editing the Labels; Adding a Title in the Form Header
- Dragging a ControlCreating Forms in Design View; Phase 1: Starting Your Design; Phase 2: Choosing a Data Source; Phase 3: Adding Fields to the Form; Phase 4: Adding Images to the Form; Phase 5: Adding a Form Style; Phase 6: Naming and Saving the Form; Linking Tables to Combine Data; Why Relate?; A Relational Database Tour; Common Fields; Subdatasheets and Subforms; Linking Tables in the Relationships Window; Adding Tables to the Relationships Window; Adding Relationships Between Tables; Modifying or Deleting Relationships; Printing Relationships; Using Subdatasheets to View Related Items
- Creating SubformsAdding Information in a Subform; Part two:; Sorting and Filtering; Sorting Database Records; Ascending Sorts; Descending Sorts; Sorting on Multiple Fields; Moving fields for multiple choice sorts; Saving Your Sorting Choice; Finding Data with Filters; How to save or discard a filter; Filtering by Selection: The Quick Way to Filter; Adding a filter by selection; Filtering by exclusion; Filtering by Form; Adding filter criteria; Filtering with Wildcards, Operators, and Expressions; Using wildcards in filters; Using operators in filters; Using expressions in filters
- Applying and removing filters
