Lýsing:
Databases can be complex, that's why you need the expert guidance of this comprehensive reference to help you harness their power with a solid understanding of database purpose, construction, and application. Whether it is your first encounter with Microsoft Access, or youre familiar with earlier version you'll appreciate the thorough attention to database fundamentals and terminology, as well as wider use of XML and Web services Additional coverage and topics youll learn include: Create tables, manipulate datasheets, and work with multiple tables Understand the seven database objects and design systems objects Apply the seven-step design method to build databases tailored to your needs Build forms with wizards, create bound and unbound forms, and add data validation Learn how to use Visual Basic and the VBA Editor to automate Access applications Use XML to create basic and advanced Data Access Pages Automate query parameters, create functions and subroutines, and add programmed error routines Exchange data with Word, Excel, PowerPoint, and other Office applications The Bonus website content contains all source code from the book as well as a complete working example and bonus shareware, freeware, trial, demo, and evaluation programs that work with or enhance Microsoft Office.
Annað
- Höfundur: Michael Alexander
- Útgáfa:1
- Útgáfudagur: 10/2015
- Hægt að prenta út 2 bls.
- Hægt að afrita 10 bls.
- Format:Page Fidelity
- ISBN 13: 9781119086598
- Print ISBN: 9781119086543
- ISBN 10: 1119086590
Efnisyfirlit
- Title Page
- Copyright
- Contents
- Introduction
- Part I: Access Building Blocks
- Chapter 1: An Introduction to Database Development
- The Database Terminology of Access
- Databases
- Tables
- Records and fields
- Values
- Relational Databases
- Access Database Objects
- Tables
- Queries
- Data-entry and display forms
- Reports
- Macros and VBA
- Planning for Database Objects
- A Five-Step Design Method
- Step 1: The overall design—from concept to reality
- Step 2: Report design
- Step 3: Data design
- Step 4: Table design
- Step 5: Form design
- The Database Terminology of Access
- Chapter 1: An Introduction to Database Development
- Chapter 2: Getting Started with Access
- The Access Welcome Screen
- How to Create a Blank Desktop Database
- The Access 2016 Interface
- The Navigation pane
- Custom
- Object Type
- Tables and Related Views
- Created Date
- Modified Date
- The Ribbon
- The Quick Access toolbar
- The Navigation pane
- Chapter 3: Creating Access Tables
- Table Types
- Object tables
- Transaction tables
- Join tables
- Creating a New Table
- Designing tables
- Using the Design tab
- Primary Key
- Insert Rows
- Delete Rows
- Property Sheet
- Indexes
- Working with fields
- Naming a field
- Specifying a data type
- Entering a field description
- Specifying data validation rules
- Table Types
- Creating tblCustomers
- Using AutoNumber fields
- Completing tblCustomers
- Changing a Table Design
- Inserting a new field
- Deleting a field
- Changing a field location
- Changing a field name
- Changing a field size
- Handling data conversion issues
- Assigning field properties
- Common properties
- Format
- Input Mask
- Caption
- Validation Rule and Validation Text
- Required
- AllowZeroLength
- Indexed
- Choosing a primary key
- Creating the primary key
- Creating composite primary keys
- The importance of indexes
- Multiple-field indexes
- When to index tables
- Renaming tables
- Deleting tables
- Copying tables in a database
- Copying a table to another database
- Building Bulletproof Databases
- Data Normalization and Denormalization
- First normal form
- Second normal form
- Identifying entities
- Less obvious entities
- Breaking the rules
- Third normal form
- Denormalization
- Table Relationships
- Connecting the data
- One-to-one
- One-to-many
- Many-to-many
- Integrity Rules
- No primary key can contain a null value
- All foreign key values must be matched by corresponding primary keys
- Keys
- Deciding on a primary key
- Looking at the benefits of a primary key
- Designating a primary key
- Single-field versus composite primary keys
- Natural versus surrogate primary keys
- Creating primary keys
- Creating relationships and enforcing referential integrity
- Specifying the join type between tables
- Enforcing referential integrity
- Viewing all relationships
- Deleting relationships
- Following application-specific integrity rules
- Understanding Datasheets
- Looking at the Datasheet Window
- Moving within a datasheet
- Using the Navigation buttons
- Examining the Datasheet Ribbon
- Views
- Clipboard
- Sort & Filter
- Records
- Find
- Window
- Text Formatting
- Saving the record
- Understanding automatic data-type validation
- Knowing how properties affect data entry
- Standard text data entry
- Date/Time data entry
- Number/Currency data entry with data validation
- OLE object data entry
- Long Text field data entry
- Moving between records
- Finding a specific value
- Manually replacing an existing value
- Changing an existing value
- Changing the field order
- Changing the field display width
- Changing the record display height
- Changing display fonts
- Displaying cell gridlines and alternate row colors
- Aligning data in columns
- Hiding and unhiding columns
- Freezing columns
- Saving the changed layout
- Saving a record
- Sorting your records with QuickSort
- Filtering a selection
- Filtering by form
- How Access Works with External Data
- Types of external data
- Ways of working with external data
- When to link to external data
- When to import external data
- When to export internal data
- Importing from another Access database
- Importing from an Excel spreadsheet
- Importing a SharePoint list
- Importing data from text files
- Delimited text files
- Fixed-width text files
- Importing and exporting XML documents
- Importing and exporting HTML documents
- Importing Access objects other than tables
- Importing an Outlook folder
- Exporting objects to other Access databases
- Exporting through ODBC drivers
- Exporting to Word
- Merging data into Word
- Publishing to PDF or XPS
- Linking External Data
- Identifying linked tables
- Limitations of linked data
- Linking to other Access database tables
- Linking to ODBC data sources
- Linking to non-database data
- Linking to Excel
- Linking to HTML files
- Linking to text files
- Setting view properties
- Setting relationships
- Optimizing linked tables
- Deleting a linked table reference
- Viewing or changing information for linked tables
- Refreshing linked tables
- The benefits of splitting a database
- Knowing where to put which objects
- Using the Database Splitter add-in
- Chapter 8: Selecting Data with Queries
- Introducing Queries
- What queries can do
- What queries return
- Creating a Query
- Adding fields to your queries
- Adding a single field
- Adding multiple fields
- Running your query
- Adding fields to your queries
- Working with Query Fields
- Selecting a field in the QBE grid
- Changing field order
- Resizing columns in the QBE grid
- Removing a field
- Inserting a field
- Hiding a field
- Changing the sort order of a field
- Adding Criteria to Your Queries
- Understanding selection criteria
- Entering simple string criteria
- Entering other simple criteria
- Printing a Query’s Recordset
- Saving a Query
- Creating Multi-Table Queries
- Viewing table names
- Adding multiple fields
- Recognizing the limitations of multi-table queries
- Overcoming query limitations
- Updating a unique index (primary key)
- Replacing existing data in a query with a one-to-many relationship
- Updating fields in queries
- Introducing Queries
- Working with the Table Pane
- Looking at the join line
- Moving a table
- Removing a table
- Adding more tables
- Creating and Working with Query Joins
- Understanding joins
- Leveraging ad hoc table joins
- Specifying the type of join
- Deleting joins
- Introducing Operators
- Types of operators
- Mathematical operators
- Comparison operators
- String operators
- Boolean (logical) operators
- Miscellaneous operators
- Operator precedence
- The mathematical precedence
- The comparison precedence
- The Boolean precedence
- Types of operators
- Using query comparison operators
- Understanding complex criteria
- Using functions in select queries
- Referencing fields in select queries
- Entering character (Text or Memo) criteria
- The Like operator and wildcards
- Specifying non-matching values
- Entering numeric criteria
- Entering true or false criteria
- Entering OLE object criteria
- Understanding an Or operation
- Specifying multiple values with the Or operator
- Using the Or cell of the QBE pane
- Using a list of values with the In operator
- Using And to specify a range
- Using the Between...And operator
- Searching for null data
- Using And and Or across fields in a query
- Specifying Or criteria across fields of a query
- Using And and Or together in different fields
- A complex query on different lines
- Aggregate Queries
- Creating an aggregate query
- About aggregate functions
- Group By
- Sum, Avg, Count, StDev, Var
- Min, Max, First, Last
- Expression, Where
- Make-table queries
- Delete queries
- Append queries
- Update queries
- Creating a crosstab query using the Crosstab Query Wizard
- Creating a crosstab query manually
- Using the query design grid to create your crosstab query
- Customizing your crosstab queries
- Normalizing your database design
- Using indexes on appropriate fields
- Optimizing by improving query design
- Compacting and repairing your database regularly
- Chapter 11: Transforming Data in Access
- Finding and Removing Duplicate Records
- Defining duplicate records
- Finding duplicate records
- Removing duplicate records
- Common Transformation Tasks
- Filling in blank fields
- Concatenating
- Concatenating fields
- Augmenting field values with your own text
- Changing case
- Removing leading and trailing spaces from a string
- Finding and replacing specific text
- Adding your own text in key positions within a string
- Parsing strings using character markers
- Query 1
- Query 2
- Finding and Removing Duplicate Records
- Using Calculations in Your Analyses
- Common calculation scenarios
- Using constants in calculations
- Using fields in calculations
- Using the results of aggregation in calculations
- Using the results of one calculation as an expression in another
- Using a calculation as an argument in a function
- Constructing calculations with the Expression Builder
- Common calculation errors
- Understanding the order of operator precedence
- Watching out for null values
- Watching the syntax in your expressions
- Common calculation scenarios
- Simple date calculations
- Advanced analysis using functions
- The Date function
- The Year, Month, Day, and Weekday functions
- The DateAdd function
- Grouping dates into quarters
- The DateSerial function
- Using Parameter Queries
- How parameter queries work
- Ground rules of parameter queries
- Working with parameter queries
- Working with multiple parameter conditions
- Combining parameters with operators
- Combining parameters with wildcards
- Using parameters as calculation variables
- Using parameters as function arguments
- The IIf function
- Using IIf to avoid mathematical errors
- Saving time with IIf
- Nesting IIf functions for multiple conditions
- Using IIf functions to create crosstab analyses
- The Switch function
- Comparing the IIf and Switch functions
- Understanding Basic SQL
- The SELECT statement
- Selecting specific columns
- Selecting all columns
- The WHERE clause
- Making sense of joins
- Inner joins
- Outer joins
- The SELECT statement
- Expanding your search with the Like operator
- Selecting unique values and rows without grouping
- Grouping and aggregating with the GROUP BY clause
- Setting the sort order with the ORDER BY clause
- Creating aliases with the AS clause
- Creating a column alias
- Creating a table alias
- Showing only the SELECT TOP or SELECT TOP PERCENT
- Top values queries explained
- The SELECT TOP statement
- The SELECT TOP PERCENT statement
- Performing action queries via SQL statements
- Make-table queries translated
- Append queries translated
- Update queries translated
- Delete queries translated
- Creating crosstabs with the TRANSFORM statement
- Merging datasets with the UNION operator
- Creating a table with the CREATE TABLE statement
- Manipulating columns with the ALTER TABLE statement
- Adding a column with the ADD clause
- Altering a column with the ALTER COLUMN clause
- Deleting a column with the DROP COLUMN clause
- Dynamically adding primary keys with the ADD CONSTRAINT clause
- Creating pass-through queries
- Enhancing Your Analyses with Subqueries
- Why use subqueries?
- Subquery ground rules
- Creating subqueries without typing SQL statements
- Using IN and NOT IN with subqueries
- Using subqueries with comparison operators
- Using subqueries as expressions
- Using correlated subqueries
- Uncorrelated subqueries
- Correlated subqueries
- Using a correlated subquery as an expression
- Using subqueries within action queries
- A subquery in a make-table query
- A subquery in an append query
- A subquery in an update query
- A subquery in a delete query
- Understanding the different domain aggregate functions
- DSum
- DAvg
- DCount
- DLookup
- DMin and DMax
- DFirst and DLast
- DStDev, DStDevP, DVar, and DvarP
- Examining the syntax of domain aggregate functions
- Using no criteria
- Using text criteria
- Using number criteria
- Using date criteria
- Using domain aggregate functions
- Calculating the percent of total
- Creating a running count
- Using a value from the previous record
- Basic Descriptive Statistics
- Running descriptive statistics with aggregate queries
- Determining rank, mode, and median
- Ranking the records in your dataset
- Getting the mode of a dataset
- Getting the median of a dataset
- Pulling a random sampling from your dataset
- Advanced Descriptive Statistics
- Calculating percentile ranking
- Determining the quartile standing of a record
- Creating a frequency distribution
- Chapter 17: Creating Basic Access Forms
- Formulating Forms
- Creating a new form
- Using the Form command
- Using the Form Wizard
- Looking at special types of forms
- Navigation forms
- Multiple-items forms
- Split forms
- Datasheet forms
- Resizing the form area
- Saving your form
- Creating a new form
- Working with Controls
- Categorizing controls
- Adding a control
- Using the Controls group
- Using the field list
- Selecting and deselecting controls
- Selecting a single control
- Selecting multiple controls
- Deselecting controls
- Manipulating controls
- Resizing a control
- Sizing controls automatically
- Moving a control
- Aligning controls
- Modifying the appearance of a control
- Grouping controls
- Changing a control’s type
- Copying a control
- Deleting a control
- Reattaching a label to a control
- Formulating Forms
- Introducing Properties
- Displaying the Property Sheet
- Getting acquainted with the Property Sheet
- Changing a control’s property setting
- Naming control labels and their captions
- Using Form View
- Looking at the Home tab of the Ribbon
- The Views group
- The Clipboard group
- The Sort & Filter group
- The Records group
- The Find group
- The Window group
- The Text Formatting group
- Navigating among fields
- Moving among records in a form
- Looking at the Home tab of the Ribbon
- Changing Values in a Form
- Knowing which controls you can’t edit
- Working with pictures and OLE objects
- Entering data in the Long Text field
- Entering data in the Date field
- Using option groups
- Using combo boxes and list boxes
- Switching to Datasheet view
- Saving a record
- Printing a Form
- Working with Form Properties
- Changing the title bar text with the Caption property
- Creating a bound form
- Specifying how to view the form
- Removing the Record Selector
- Looking at other form properties
- Adding a Form Header or Footer
- Working with Section Properties
- The Visible property
- The Height property
- The Back Color property
- The Special Effect property
- The Display When property
- The printing properties
- Changing the Layout
- Changing a control’s properties
- Setting the tab order
- Modifying the format of text in a control
- Using the Field List to add controls
- Converting a Form to a Report
- Setting Control Properties
- Customizing default properties
- Looking at common controls and properties
- The Text Box control
- The Command Button control
- The Combo Box and List Box controls
- The Check Box and Toggle Button controls
- The Option Group control
- The Web Browser control
- Using the Tab Stop property
- Tallying check boxes
- Setting up combo boxes and list boxes
- Using the Page Number and Date/Time controls
- Using the Image control
- Morphing a control
- Using the Format Painter
- Offering more end-user help
- Adding background pictures
- Limiting the records shown on a form
- Designing the query
- Setting up the command buttons
- Adding a default button
- Setting a Cancel button
- Removing the control menu
- Creating the basic form
- Creating a subform
- Adding the subform
- Changing the form’s behavior
- Setting the form properties
- Looking up values during data entry
- Saving the record
- Changing the form’s appearance
- Introducing Reports
- Identifying the different types of reports
- Tabular reports
- Columnar reports
- Mailing label reports
- Distinguishing between reports and forms
- Identifying the different types of reports
- Creating a Report, from Beginning to End
- Defining the report layout
- Assembling the data
- Creating a report with the Report Wizard
- Creating a new report
- Selecting the grouping levels
- Defining the group data
- Selecting the sort order
- Selecting summary options
- Selecting the layout
- Opening the report design
- Adjusting the report’s layout
- Choosing a theme
- Creating new theme color schemes
- Using the Print Preview window
- Publishing in alternate formats
- Viewing the report in Design view
- Printing or viewing the report
- Printing the report
- Viewing the report
- Saving the report
- Banded Report Design Concepts
- The Report Header section
- The Page Header section
- The Group Header section
- The Detail section
- The Group Footer section
- The Page Footer section
- The Report Footer section
- Creating a Report from Scratch
- Creating a new report and binding it to a query
- Defining the report page size and layout
- Placing controls on the report
- Resizing a section
- Modifying the appearance of text in a control
- Working with Text Box controls
- Adding and using Text Box controls
- Entering an expression in a Text Box control
- Sizing a Text Box control or Label control
- Deleting and cutting attached labels from Text Box controls
- Pasting labels into a report section
- Moving Label and Text Box controls
- Modifying the appearance of multiple controls
- Changing Label and Text Box control properties
- Growing and shrinking Text Box controls
- Sorting and grouping data
- Creating a group header or footer
- Sorting data within groups
- Removing a group
- Hiding a section
- Sizing a section
- Moving controls between sections
- Adding page breaks
- Improving the Report’s Appearance
- Adjusting the page header
- Creating an expression in the group header
- Creating a report header
- Grouping and Sorting Data
- Grouping alphabetically
- Grouping on date intervals
- Hiding repeating information
- Hiding a page header
- Starting a new page number for each group
- Formatting Data
- Creating numbered lists
- Creating bulleted lists
- Adding emphasis at run time
- Avoiding empty reports
- Inserting vertical lines between columns
- Adding a blank line every n records
- Even-odd page printing
- Using different formats in the same text box
- Centering the title
- Aligning control labels
- Micro-adjusting controls
- Adding Data
- Adding more information to a report
- Adding the user’s name to a bound report
- Adding Even More Flexibility
- Displaying all reports in a combo box
- Fast printing from queried data
- Using snaking columns in a report
- Exploiting two-pass report processing
- Assigning unique names to controls
- Chapter 22: Using Access Macros
- An Introduction to Macros
- Creating a macro
- Assigning a macro to an event
- Understanding Macro Security
- Enabling sandbox mode
- The Trust Center
- Multi-Action Macros
- Submacros
- Conditions
- Opening reports using conditions
- Multiple actions in conditions
- Temporary Variables
- Enhancing a macro you’ve already created
- Using temporary variables to simplify macros
- Using temporary variables in VBA
- Error Handling and Macro Debugging
- The OnError action
- The MacroError object
- Debugging macros
- Embedded Macros
- Macros versus VBA Statements
- Choosing between macros and VBA
- Converting existing macros to VBA
- An Introduction to Macros
- Introducing Data Macros
- Understanding Table Events
- “Before” events
- “After” events
- Using the Macro Designer for Data Macros
- Understanding the Action Catalog
- Program flow
- Data blocks
- Data actions
- Creating Your First Data Macro
- Managing Macro Objects
- Collapsing and expanding macro items
- Moving macro items
- Saving a macro as XML
- Recognizing the Limitations of Data Macros
- Introducing Visual Basic for Applications
- Understanding VBA Terminology
- Starting with VBA Code Basics
- Creating VBA Programs
- Modules and procedures
- Modules
- Procedures and functions
- Working in the code window
- White space
- Line continuation
- Multi-statement lines
- IntelliSense
- Compiling procedures
- Saving a module
- Modules and procedures
- Branching
- The If keyword
- The Select Case...End Select statement
- Looping
- The Do...Loop statement
- The For...Next statement
- An object primer
- Properties and methods
- Properties
- Methods
- The With statement
- The For Each statement
- The Immediate window
- The Project Explorer
- The Object Browser
- VBE options
- The Editor tab of the Options dialog box
- The Project Properties dialog box
- Using Variables
- Naming variables
- Declaring variables
- The Dim keyword
- The Public keyword
- The Private keyword
- Comparing implicit and explicit variables
- Forcing explicit declaration
- Using a naming convention with variables
- Understanding variable scope and lifetime
- Examining scope
- Determining a variable’s lifetime
- Deciding on a variable’s scope
- Using constants
- Declaring constants
- Using a naming convention with constants
- Eliminating hard-coded values
- Working with arrays
- Fixed arrays
- Dynamic arrays
- Array functions
- Understanding where to create a procedure
- Calling VBA procedures
- Creating subs
- Handling parameters
- Calling a function and passing parameters
- Creating a function to calculate sales tax
- Programming Events
- Understanding how events trigger VBA code
- Creating event procedures
- Identifying Common Events
- Form event procedures
- Essential form events
- Form mouse and keyboard events
- Form data events
- Control event procedures
- Report event procedures
- Report section event procedures
- Form event procedures
- Paying Attention to Event Sequence
- Looking at common event sequences
- Writing simple form and control event procedures
- Opening a form with an event procedure
- Running an event procedure when closing a form
- Using an event procedure to confirm record deletion
- Organizing VBA Code
- Testing Your Applications
- Testing functions
- Compiling VBA code
- Traditional Debugging Techniques
- Using MsgBox
- Using Debug.Print
- Using the Access Debugging Tools
- Running code with the Immediate window
- Suspending execution with breakpoints
- Looking at variables with the Locals window
- Setting watches with the Watches window
- Using conditional watches
- Using the Call Stack window
- Trapping Errors in Your Code
- Understanding error trapping
- On Error Resume Next
- On Error Goto 0
- On Error Goto Label
- The Resume keyword
- The Err object
- Including error handling in your procedures
- Understanding error trapping
- Chapter 28: Accessing Data with VBA Code
- Working with Data
- Understanding ADO Objects
- The ADO Connection object
- The ADO Command object
- The ADO Recordset object
- Navigating recordsets
- Understanding CursorType
- Detecting the recordset end or beginning
- Counting records
- Understanding DAO Objects
- The DAO DBEngine object
- The DAO Workspace object
- The DAO Database object
- The DAO TableDef object
- The DAO QueryDef object
- The DAO Recordset object
- The DAO Field objects (recordsets)
- Writing VBA Code to Update a Table
- Updating fields in a record using ADO
- Updating a calculated control
- Recalculating a control when updating or adding a record
- Checking the status of a record deletion
- Eliminating repetitive code
- Adding a new record
- Deleting a record
- Deleting related records in multiple tables
- Adding an Unbound Combo Box to a Form to Find Data
- Using the FindRecord method
- Using a bookmark
- Filtering a Form
- With code
- With a query
- Creating a parameter query
- Creating an interactive filter dialog box
- Linking the dialog box to another form
- The Ribbon Hierarchy
- Controls for Access Ribbons
- SplitButton
- Menu
- Gallery
- Button
- ToggleButton
- ComboBox
- CheckBox
- Special Ribbon features
- SuperTips
- Collapsing the Ribbon
- Controls for Access Ribbons
- The Ribbon creation process
- Using VBA callbacks
- Step 1: Design the Ribbon and build the XML
- Step 2: Write the callback routines
- Step 3: Create the USysRibbons table
- Step 4: Add XML to USysRibbons
- Step 5: Specify the custom Ribbon property
- Specifying imageMso
- The Label control
- The Button control
- Separators
- The CheckBox control
- The DropDown control
- The SplitButton Control
- Defining the Current Database Options
- Application options
- Application Title
- Application Icon
- Display Form
- Display Status Bar
- Document Window Options
- Use Access Special Keys
- Compact on Close
- Remove Personal Information from File Properties on Save
- Use Windows-Themed Controls on Forms
- Enable Layout View
- Enable Design Changes for Tables in Datasheet View
- Check for Truncated Number Fields
- Picture Property Storage Format
- Navigation options
- The Display Navigation Pane check box
- The Navigation Options button
- Ribbon and toolbar options
- Ribbon Name
- Shortcut Menu Bar
- Allow Full Menus
- Allow Default Shortcut Menus
- Name AutoCorrect Options
- Application options
- Developing the Application
- Building to a specification
- Creating documentation
- Documenting the code you write
- Documenting the application
- Testing the application before distribution
- Polishing Your Application
- Giving your application a consistent look and feel
- Adding common professional components
- A splash screen
- An application switchboard
- An About box
- The status bar
- A progress meter
- Making the application easy to start
- Bulletproofing an Application
- Using error trapping on all Visual Basic procedures
- Maintaining usage logs
- Separating tables from the rest of the application
- Building bulletproof forms
- Validating user input
- Using the /runtime option
- Encrypting or encoding a database
- Removing a database password
- Protecting Visual Basic code
- Using error trapping on all Visual Basic procedures
- Securing the Environment
- Setting startup options in code
- Disabling startup bypass
- Setting property values
- Getting property values
- Chapter 32: Integrating Access with SharePoint
- Introducing SharePoint
- Understanding SharePoint Sites
- SharePoint Documents
- SharePoint lists
- Sharing Data between Access and SharePoint
- Linking to SharePoint lists
- Importing SharePoint lists
- Exporting Access tables to SharePoint
- Moving Access tables to SharePoint
- Using SharePoint Templates
- Chapter 33: Deploying Access Applications to SharePoint
- Understanding Web Publishing with Access
- Understanding Access Services
- Why SharePoint?
- Examining the Limitations of Access Web Applications
- Limitations of Access Services
- Transactional limitations
- Publishing a Custom Access Application to SharePoint
- Preparing the Access data model
- Initializing and configuring the custom web application
- Reviewing and editing table views
- Adding a validation rule to a table
- Adding events to a table
- Creating your own queries and views
- A final word on configuring your web application
- Launching and managing your web application
- Understanding Web Publishing with Access
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 11053
- Útgáfuár : 2015
- Leyfi : 379